Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
PostgreSQL 8.01/CFMX7 and JDBC
0 views
Skip to first unread message
anderegg
Mar 1, 2005, 1:50:13 PM3/1/05
to
I'm trying to connect to a postgreSQL 8.01 server via JDBC and ColdFusion MX7.
It all worked fine with PostgreSQL 7.4, but when I update to 8.0.1, I always
get 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 resources file, error: null The root cause
was that: java.sql.SQLException: No suitable driver available for pgtest,
please check the driver setting in resources file, error: null Anyone has been
able to connect to a postgres 8 database?
It all worked fine with PostgreSQL 7.4, but when I update to 8.0.1, I always
get 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 resources file, error: null The root cause
was that: java.sql.SQLException: No suitable driver available for pgtest,
please check the driver setting in resources file, error: null Anyone has been
able to connect to a postgres 8 database?
Jochem van Dieten - TMM
Mar 1, 2005, 2:16:09 PM3/1/05
to
Yes. Just download the latest driver from
http://jdbc.postgresql.org/ and it should work fine.
Jochem
--
Jochem van Dieten
Team Macromedia Volunteer for ColdFusion, beer and fun.
anderegg
Mar 1, 2005, 3:11:54 PM3/1/05
to
Thanks for the hint. I also forgot to update to change the Class Path in the ColdFusion Administrator. Now it works perfect!
0 new messages