Thanks Cliff, I will try it in the lib folder...as I mentioned previously, I have already added it to the classpath.
I have had this exact configuration working on another server for several years...but for some reason it does not want to work properly on this one...very strange. -Josh On 12/18/05, Cliff Meyers <[EMAIL PROTECTED]> wrote: > I would recommend doing either of the following: > > (1) Try placing the .jar in WEB-INF/lib, restarting CF and seeing if > you can successfully create the datasource > > (2) If not, following the instructions on the page below, which > involving explicitly adding the .jar to your Java classpath using the > CF Admin: > > http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 > > Good luck and let me know if you get it working... > > > On 12/17/05, Josh <[EMAIL PROTECTED]> wrote: > > Gladly. Thanks. > > > > -CF Standalone w/Apache > > -/opt/coldfusionmx/wwwroot/WEB-INF/classes/ > > -here are the values for the datasource: > > CF Datasource Name: asthma > > JDBC URL: jdbc:postgresql://127.0.0.1/asthma > > Driver Class: org.postgresql.Driver > > Driver Name: PostgreSQL > > Username: asthma > > Password: **************** > > > > I would appreciate any ideas... > > > > > > > > On 12/17/05, Cliff Meyers <[EMAIL PROTECTED]> wrote: > > > Can you please reply with the following information? > > > > > > - CF standalone or multiserver (JRun) install > > > - Where you're putting the JDBC driver .jar file > > > - Values you're entering for all fields on the data source page > > > > > > > > > On 12/16/05, Josh <[EMAIL PROTECTED]> wrote: > > > > I have a new server I am setting up that I need to hook up with > > > > postgresql. > > > > > > > > Here are the specs: > > > > > > > > RedHat Enterprise Linux 3ES > > > > PostgreSQL 7.3.10 > > > > CFMX 6.1 (due to customer constraints) > > > > > > > > I have tried to use the following drivers with no success: > > > > > > > > pg73jdbc2.jar > > > > pg73jdbc3.jar > > > > pg74.215.jdbc3.jar > > > > pg74.216.jdbc3.jar > > > > > > > > I thought that CFMX 6.1 came with the 1.4.1 jdk, so I should be using > > > > a jdbc3 driver...but none of them work for some odd reason. > > > > > > > > Here is the error I get in the cfadmin when I try to add and test the > > > > DSN: > > > > > > > > Connection verification failed for data source: asthma > > > > []java.sql.SQLException: No suitable driver available for asthma, > > > > 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 asthma, please check the driver setting in resources > > > > file, error: org.postgresql.Driver > > > > > > > > I have had this same exact config working on another server > > > > previously, using pg74.215.jdbc3.jar, however this does not want to > > > > work this time! > > > > > > > > I have added them to the class path and restarted the CF services as > > > > well, but no luck. I have been at it for several hours now...and am > > > > hoping that someone on this list can steer me in the right direction. > > > > > > > > Thanks, > > > > > > > > Josh > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:4098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
