Also Deanna, don't know if you've popped open the code for AbleCommerce, but it's not really a CF application, it's basically a Java app with a few cfscript tags around hundreds of lines of java code. If you're looking for a true CF shopping cart you might want to check out CFWebstore (http://www.cfwebstore.com) . It's Fusebox 3, however even if you're not familiar with Fusebox it's not too hard to decipher, and it's a true CF app. Unless you're very comfortable with lots o' Java you'll find AbleCommerce hard to work with.
-- Josh ----- Original Message ----- From: "Josh Nathanson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, April 10, 2006 10:37 AM Subject: Re: MySQL Connector/J problems > 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:237376 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
