1) I've downloaded the jar file (pg73jdbc1.jar) into the coldfusion directory /opt/coldfusionmx/wwwroot/WEB-INF/classes.
2) I entered the above path into the CLASS PATH field in the Jave and JVM section of the Coldfusion Administrator and restarted CF.
3) I made sure that TCP/IP connections to postgresql are enabled.
4) I set up the pg_hba.conf as indicated in the documentation to allow host connections with md5 authentication. (This is one part that I'm a bit unsure about, though. I have localhost to accept all connections from all users with md5 passwords, and a host connection with the server IP number and mask with md5 passwords.)
5) I created a new datasource in CF Admin with the following settings:
Data Source Name: cropsci
JDBC URL: jdbc:postgresql://<server IP number>/cropsci
Driver Class: org.postgresql.Driver
Username: <username>
Password: <password>
(I've also tried this with JDBC URL: jdbc:postgresql:<DBname>)
When I submit the datasource, I get the following error:
"Connection verification failed for data source: cropsci
[java.sql.CQLException: So suitable driver available for cropsci, please check the driver setting in resources file, error:
org.postgresql.Driver
The root cause was that java.sql.SQLException: No suitable driver available for cropsci, please check the driver setting in resources file, error: org.postgresql.Driver"
The only reference to this kind of error I can find in the Macromedia support docs is the Technote: "ColdFusion MX: Trailing space in Driver Class field causes data source verification failure (Technote 18612)", but when I edit the datasource, there is no trailing space after the Driver Class, and in the note is says this problem was fixed in version 6.1 anyway...
Has anyone encountered a similar problem trying to connect to a postgreSQL database? There's got to be something I'm missing, but I have no idea what it might be...
--Mary Winters-Meyer
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
