PostgreSQL 7.2.1 on SuSE Linux with Coldfusion MX

Manuel W. wrote:

Hi everyone,
I'm trying to have Coldfusion MX connect to my PostgreSQL 7.2.1 database on
SuSE Linux 8.

I've downloaded PostgreSQL JDBC and copied the file "pgjdbc2.jar" to
"/opt/coldfusionmx/wwwroot/WEB-INF/classes". Then I followed the instruction
you can find in http://vandieten.net/jochem/coldfusion/postgresql/

After adding a datasource I obtain the following error message:

Connection verification failed for data source: pgtest
[]java.sql.SQLException: No suitable driver available for pgtest, please
check the driver setting in jrun-resources.xml, error: org.postgresql.Driver
The root cause was that: java.sql.SQLException: No suitable driver available
for pgtest, please check the driver setting in jrun-resources.xml, error:
org.postgresql.Driver

I've used the following settings:
JDBC URL: jdbc:postgresql:radius (also tried
jdbc:postgresql://127.0.0.1/radius and other stuff)
Driver class: org.postgresql.Driver
Driver name: PostgreSQL

Did you enter a username and password before submitting?

Jochem

"Jochem van Dieten" <nomail@dev.null> ha scritto nel messaggio
news:3D2316D7.6020507@dev.null...

Did you enter a username and password before submitting?

Yes I did - and I'm so stupid, I found the mistake: the permissions on the
JDBC files were incorrect. I have mis-typed something when setting them and
screwed them... I was in a hurry and didn't find out until late tonight.

Thank you anyway!

-Manuel

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Manuel W. wrote:

"Jochem van Dieten" <nomail@dev.null> ha scritto nel messaggio
news:3D2316D7.6020507@dev.null...

Did you enter a username and password before submitting?

Yes I did - and I'm so stupid, I found the mistake: the permissions on the
JDBC files were incorrect. I have mis-typed something when setting them and
screwed them... I was in a hurry and didn't find out until late tonight.

If you can tell me what permissions are needed I will update the tutorial.

Jochem