Connecting to a mysql database
I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J AND (note the emphasis) I set my local and remote folders in my DW site local folder, remote folder and testing server folders all to C:\CFusionMX\db\, I can connect to my mysql database in CF Administrator. However, with these DW site folder settings, DW doesn't recognize any databases (Access or Mysql) at all. When I change my DW site folder settings to 'wwwroot' (e.g.local folder C:\CFusionMX\db\' is changed to 'C:\CFusionMX\wwwroot') DW now lists all my CF Administrator databases. The problem is CF Administrator can't connect to my Mysql data sources. It gives me the error: Connection verification failed for data source: javaserver []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info I've tried changing the 3306 port to 8500, but this doesn't help. My java path and connector file is: C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar, Is this a ID/password problem? I've tried both 'root' and leaving the ID field in the CF Administrator add data source block, both to no avail. I don't have a password set in Mysql for 'root' either. Any help would be gratefully appreciated. I've been working on this for weeks and keep running into one problem after another. Thanks a million in advance. Sincerely, Graham A. Kerby ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connecting to a mysql database
What version of ColdFusion are you running. There is a special connector that you may ahve to install to enable you to connect to a MySQL database. It is the mysql-connector-odbc-3.51.21-win32 available form the MySQL website. Download it and instal and then you also have to place a copy in a folder in CF, the lib folder but you better check on that one. Hope that helps a little. T I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J AND (note the emphasis) I set my local and remote folders in my DW site local folder, remote folder and testing server folders all to C:\CFusionMX\db\, I can connect to my mysql database in CF Administrator. However, with these DW site folder settings, DW doesn't recognize any databases (Access or Mysql) at all. When I change my DW site folder settings to 'wwwroot' (e.g.local folder C:\CFusionMX\db\' is changed to 'C:\CFusionMX\wwwroot') DW now lists all my CF Administrator databases. The problem is CF Administrator can't connect to my Mysql data sources. It gives me the error: Connection verification failed for data source: javaserver []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info I've tried changing the 3306 port to 8500, but this doesn't help. My java path and connector file is: C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar, Is this a ID/password problem? I've tried both 'root' and leaving the ID field in the CF Administrator add data source block, both to no avail. I don't have a password set in Mysql for 'root' either. Any help would be gratefully appreciated. I've been working on this for weeks and keep running into one problem after another. Thanks a million in advance. Sincerely, Graham A. Kerby ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connecting to a mysql database
You've almost got it: JDBC URL - jdbc:mysql://localhost:3306/test Driver Class - com.mysql.jdbc.Driver Driver Name - MySQL Connector/J HTH, Adrian I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
