Eric Creese wrote: >Okay still having trouble with this. I downloaded the connector and followed >the directions at this link >(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253) However >I now get a new error. > >Connection verification failed for data source: bhkjxk >[]java.lang.NoClassDefFoundError: java/sql/Savepoint >The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint > > Don't know if this is related or not, but there's a line missing from that KB article.
You also need to add the path to the J Connector to the Class Path in the Java/JVM settings in the CF Admin, then you can restart the server. Actually, I set up the connector a whole different way that doesn't include using the WEB-INF/lib folder. Save the mysql-connector-java-3.1.7-bin.jar (latest version I believe) to anywhere you like (I have mine saved in CFusionMX/runtime/servers/lib - can't remember why, but it works) Add the path, including the full jar file name, to the class path under the Java/JVM settings in the CF Admin. Make sure you use the correct seperator for your server OS, if you already have anything in the Class Path. Make sure that the user CF is running under has access to the jar file and now restart the CF services. Other than that, my DSN settings are exactly the same as the way you have yours set. Another possibility to look into is changing the JVM that CF is using. I have mine currently using Sun j2sdk1.4.2_04, but I believe that you can go up to j2sdk1.4.2_07, but 07 may possibly break LDAP. Hope that helps. Stephen PS. You were posting at 1am, 1:40am and 3am GMT! Its got to be quite out there in list land at that time. ;) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:200393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
