PostgreSQL 7.2.1 on SuSE Linux with Coldfusion MX

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

Any idea about why this doesn't work?

Thanks & regards
-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:
> 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(at)dev(dot)null> ha scritto nel messaggio
news:3D2316D7(dot)6020507(at)dev(dot)null(dot)(dot)(dot)
> 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(at)dev(dot)null> ha scritto nel messaggio
> news:3D2316D7(dot)6020507(at)dev(dot)null(dot)(dot)(dot)
>
>>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