Get out your scuba gear -- you'll most likely be diving deep! Did you get the mysql connector working?
-- Josh ----- Original Message ----- From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, April 10, 2006 11:00 AM Subject: Re: MySQL Connector/J problems > Yep, we're familiar with cfwebstore, but it didn't meet all our needs. > Neither does ablecommerce, for that matter, but it got us closer. And, > yes, > we realize it's a java back end. One of the reasons we want to get the > demo > installed locally is to see how much of what we'd need to "enhance" could > be > done without diving into the java. > > > On 4/10/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: >> >> 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:237381 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
