Ok - I finally had some time to revisit this issue and resolved it -- thought I would post the solution here for posterity's sake.
I chmod'd the jar file to 777 and moved it to the lib file. I then had to go to the postgresql.conf file and enable tcp/ip connections -- and it is now working. Thanks everyone for the help! -Josh On 12/18/05, Cliff Meyers <[EMAIL PROTECTED]> wrote: > > Interestingly, someone else had trouble using the MySQL JDBC driver > available from MySQL.com. I don't think we ever figured out what the > issue was there, but we can keep plugging away on this one until it > works ;) > > > On 12/18/05, Josh < [EMAIL PROTECTED]> wrote: > > 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:4105 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=11502.10531.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
