Aaaargh! I didn't have "driver" capitalized. Thanks everyone. Move along now. Nothing to see here. :)
On 4/10/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: > > Just to confirm, are you using the "other" selection when specifying the > driver type in CF Admin? You can't use the MySQL 3.x type, you have to > choose "other." Then when filling out the datasource info you have to > specify: > > JDBC url: jdbc:mysql://localhost:3306/yourdatabasenamehere > Driver class: com.mysql.jdbc.Driver > > If you've done all that and it still doesn't work, not sure where to go. > > -- Josh > > > ----- Original Message ----- > From: "Deanna Schneider" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Monday, April 10, 2006 10:21 AM > Subject: Re: MySQL Connector/J problems > > > > Nope. Removed the 3.1 jar file and added the 3.0.17 jar file. Restarted > > the > > service, still no joy. > > > > On 4/10/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: > >> > >> AFAIK JDBC connector >=3.1 doesn't work right with CFMX7. 3.0 does > seem > >> to > >> work reliably, I'm currently using 3.0.17 with no problems. Others may > >> have > >> better info. > >> > >> -- Josh > >> > >> > >> ----- Original Message ----- > >> From: "Deanna Schneider" <[EMAIL PROTECTED]> > >> To: "CF-Talk" <[email protected]> > >> Sent: Monday, April 10, 2006 10:02 AM > >> Subject: MySQL Connector/J problems > >> > >> > >> > Hey folks, > >> > I'm trying to install a demo version of abelcommerce, and to do it I > >> > needed > >> > to install the connector/j JDBC connector. The Adobe docs say to use > >> > version > >> > 3.1.10, but the ablecommerce site says to use 3.1.7. I went with the > >> > ablecommerce recommendation, since I need to specifically test it. > >> > > >> > Anyway, I can't get the datasource to verify. I get this error: > >> > > >> > Connection verification failed for data source: ablecommerce > >> > java.sql.SQLException: No suitable driver available for ablecommerce, > >> > please > >> > check the driver setting in resources file, error: null > >> > The root cause was that: java.sql.SQLException: No suitable driver > >> > available > >> > for ablecommerce, please check the driver setting in resources file, > >> > error: > >> > null > >> > > >> > I've followed all the directions in the Adobe technote here: > >> > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170 > >> > > >> > And, I've verified that there are > >> > 1. no trailing spaces > >> > 2. the driver.class file exists at > >> > C:\CFusionMX7\wwwroot\WEB-INF\lib\com\mysql\jdbc > >> > 3. restarted the CF service. > >> > 4. reboot (grasping at straws here) > >> > > >> > Anyone have additional suggestions? > >> > > >> > > >> > > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237380 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
