MySQLJDBC

works in Max 4.6 and above (including Max 5 & 6)

Download: MySQLJDBC.zip (12kb)

MySQL Connector/J for MXJ
The MySQLJDBC MXJ object provides max with a simple interface to the MySQL Connector/J native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database. Being that it is developed with MXJ, it is compatible with Windows and Mac.

 

-------------
INSTALLATION:
-------------
- If you haven't done so, Install MySQL and make sure it is running
(covering installing, using, and running MySQL is beyond the scope of this doc. Try a Google search or similar for more details on this. Some references are provided below)

- Download the MySQL Java Connector class from here:
http://www.mysql.com/products/connector/j/

For developers details on this jar and its use can be found here (also see the resources below):
http://dev.mysql.com/usingmysql/java/

- place the mysql-connector-java-x.x.x-bin.jar file in your /Applications/MaxMSP x.x/Cycling '74/java/lib/ folder (or whatever folder you may have defined as a classpath in your max.java.config.txt file found under /Applications/MaxMSP x.x/Cycling '74/java/)

NOTE: do not place it in a subfolder or else it will not work. In otherwords don't copy the entire distribution to the classpath, just the jar file.

- place the MySQLJDBC.class file in your /Applications/MaxMSP x.x/Cycling '74/java/classes/ folder

- Start max.

In the max window you should see something very similar to:
/Applications/MaxMSP x.x/Cycling '74/java/lib/mysql-connector-java.jar

The included help file provides some simple examples.

NOTE: The help file assumes you have already created a database called "maxmsp", with a user name "maxmspuser", and password "mathews".

----------------
ONLINE RESOURCES
----------------

..:For Everyone:..

MySQL Docs
http://dev.mysql.com/doc/

phpMyAdmin (for administration)
http://www.phpmyadmin.net


..:For MXJ Developers:..
Using MySQL With Java:
http://dev.mysql.com/usingmysql/java/

java.sql API
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/package-summary.html

JDBC Basics
http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html

jGuru: JDBC 2.0 Fundamentals
http://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/JDBC20.html#JDBC202_5