I used the update tool from CFADMIN to handle the jar file accordingly, but will try putting the file where you indicated. At this point, I am willing to try virtually anything
-----Original Message----- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 1:42 PM To: CF-Talk Subject: Re: MySQL/CFMX7 is the death of me. Im no expert here, so take my advice with a grain of salt. I put the 3.1.12 driver (mysql-connector-java-3.1.12-bin.jar) in my C:\CFusionMX7\wwwroot\WEB-INF\lib folder and then restarted. I dont see the mysql connector in my class path in the cfadmin. I am also using mysql 5.0.something. Are you sure you put the driver in the same place? I have also had problems before with beta drivers from mysql. On 2/6/06, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Ok for those of you who are familiar with this thread. > > I backed out of the 5.0 beta connectors from MySQL and loaded the > 3.1.12 connectors. > > How I did this was deleted all the 5.0 jar files from the system. Then > used the System Information are to update the jar file for the 3.1.12 > connectors. > > Restarted the machine each time. Viewed the classpath area under > System Information (CFMX7) and only found the new drivers for 3.1.12. > So the 5.0 BETAs are gone. > > So I am thinking GREAT! Now I have the 3.1.12 drivers loaded. > BTW: This is CFMX 7.0.1 > > So I go to datasources, add a new datasource using Other as people > have mentioned using the following: > > JBDC URL: jdbc:mysql://localhost:3306/myDevDB > Driver Class: com.mysql.jdbc.Driver > Driver Name: [nothing entered here] > Username: root > Password: [rootlevelpassword] > > and when I click Submit Changes I get the following error: > > Connection verification failed for data source: myDevDB > java.sql.SQLException: Timed out trying to establish connection The > root cause was that: java.sql.SQLException: Timed out trying to > establish connection > > Now, I use NaviCat and I can connect locally using that GUI interface > for MySQL. > MySQL is 5.0.xxxx (sorry do not remember the actual number) I connect > just fine and can add, edit, and update databases without a problem. > I can also use the Windows XP Control Panel to create the datasource > there and it validates just fine, but not in CFMX 7. > > So any idea why in the world CFMX 7 has this issue? > > Thanks to all! > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231474 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
