what :
Home > Objects > M > MySQLJDBC > author : MarkDavid Hosale

MySQLJDBC


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


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


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

- Start max.

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

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

Format : Javaclass (mxj)
Environment : max / msp
freeware
Max 5.x / 4.x / 6.x


http://www.mdhosale.com/mysqljdbc/

4855 objects and 135 libraries within the database Last entries : December 23rd, 2023 Last comments : 0 0 visitor and 89739000 members connected RSS
Site under GNU Free Documentation License