Yes I have user a username and password, but its not require in Postgresql if its the same computer.
I do have try chaging the jar file to postgresql.jar still no luck. Is there any log where you can see the error more in details? TIA, Ernesto Vargas --- Jillian Carroll <[EMAIL PROTECTED]> wrote: > I assume that you are actually enterine a username > and password and not just > leaving it blank? > > -----Original Message----- > From: Ernesto Vargas > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 11:25 AM > To: CF-Linux > Subject: CFMX, RH 7.3, PostgreSQL JDBC drivers > > > I am having the following error: > > Connection verification failed for data source: test > []java.sql.SQLException: SQLException occurred in > JDBCPool while attempting to connect, please check > your username, password, URL, and other connectivity > info. > The root cause was that: java.sql.SQLException: > SQLException occurred in JDBCPool while attempting > to > connect, please check your username, password, URL, > and other connectivity info. > > > I have installed Postgresql JDBC 2 driver from > http://jdbc.postgresql.org/download/pgjdbc2.jar > under > /usr/coldfusionmx/lib where all standard CFMX .jar > files are. > > I am defining the datasource as follow: > > CF Datasource Name: Test > JDBC URL: jdbc: postgresql://localhost/gyn > Driver Class: org.postgresql.Driver > Driver Name: PostgreSQL > Username: > Password: > > Any body with advice? > > TIA, > > Ernesto Vargas > > __________________________________________________ > Do you Yahoo!? > Yahoo! News - Today's headlines > http://news.yahoo.com > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
