Project How-To: MySQL

Java driver

The name of the Java class for the Mysql driver is "org.gjt.mm.mysql.Driver". E.g.:

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

The connection string that you will need to use to get the database handle is:

String url = "jdbc:mysql://" + dbHost + "/" + dbName;
db = DriverManager.getConnection(url, dbUser, dbPassword);

where dbName is your username and dbHost is bugatti.cs.ucsb.edu.

Transactions

We now have a version of mysql with support for the Berkeley DB tables. These support transactions. See the MySQL BDB documentation for more details. To take advantage of the BDB features, you must create tables of type BDB: use CREATE TABLE ... TYPE = BDB;

Updated 05/07/2001