Installing MySQL JDBC driver for ColdFusion MX 6.1

Posted by: scoopseven 17 years, 6 months ago

download latest version of mySQL JDBC driver from MySQL website (mysql-connector-java-3.2.0-alpha-bin.jar) currently running on FADWEB move jar file to C:\CFusionMX\wwwroot\WEB-INF\lib *** I didn't take these steps**** You should also add the complete path to this JAR file in your CLASSPATH environment variable. In case if you don't know how to do that, go to Start -> Settings -> Control Panel -> System -> Advanced (tab) -> Environment Variables. Double-click 'CLASSPATH' if it is already listed there or click 'New' to create one with the name of 'CLASSPATH'. If you already had a 'CLASSPATH environment variable listed, simply type in (or paste) the complete path including file name in the window that opens up *at the end of* existing CLASSPATH values. If you are creating a new 'CLASSPATH' environment variable then simple enter '.;' and then append the complete path to Connector/J's JAR file. Note: The CLASSPATH variable contains a list of semi-colon separated folders and JAR files where JVM will search for Java class files. You should always separate paths with semi-colon (;) so that JVM can understand where one path ends and next one begins. Also keep in mind that in CLASSPATH variable paths, the first path is always '.' (single dot) which means urrent folder, so that JVM starts the search for Java class files from the current folder. *** END I didn't take these steps**** I took these steps instead... Add the full class path to your jar file to the Class Path textarea in the Java and JVM settings within ColdFusion Administrator. This allows CF to see the jar. That's it! Share on Twitter Share on Facebook

• ← MySQL: Windows v Linux
• Connecting MySQL ODBC 3.51 to CFMX →