Mark-David Hosale

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 in MXJ, it is compatible 

- 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. 

- 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 

- place the mysql-connector-java-5.0.6-bin.jar file in your / 

Applications/MaxMSP 4.6/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 4.6/Cycling 

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 

- place the MySQLJDBC.class file in your /Applications/MaxMSP 4.6/ 

In the max window you should see something very similar to:

/Applications/MaxMSP 4.6/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".

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

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

http://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/

MySQLJDBC
Download: MySQLJDBC.zip (12kb) http://www.mdhosale.com/media/ 
MySQLJDBC.zip

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 in 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-5.0.6-bin.jar file in your / 
Applications/MaxMSP 4.6/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 4.6/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 4.6/ 
Cycling '74/java/classes/ folder

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

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
