Thread: 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
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
"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! =-----