net.loadbang.sql.mxj
Class MySQL

java.lang.Object
  com.cycling74.max.MaxObject
      net.loadbang.util.EnrichedMaxObject
          net.loadbang.sql.mxj.MXJ_SQL
              net.loadbang.sql.mxj.MySQL

public class MySQL
extends MXJ_SQL

An MXJ object to connect to a MySQL database.

Every instance of this object maintains its own database connection (via the embedded Database object); there's no complicated connection pooling (and no real need for it).

We synchronise access to the connection inside the MySQL connector to avoid interference between scheduler and GUI threads.

Author:

Nick Rothwell, nick@cassiel.com / nick@loadbang.net

Field Summary

Fields inherited from class com.cycling74.max.MaxObject

EMPTY_STRING_ARRAY, NO_INLETS, NO_OUTLETS

Constructor Summary

MySQL()
Constructor.

Method Summary

void	connect() Connect to MySQL, taking setup parameters from attributes.
void	disconnect() Disconnect from MySQL (done automatically when MXJ instance deleted).
java.lang.String	getDb()
java.lang.String	getHost()
java.lang.String	getPass()
java.lang.String	getUser()
void	setDb(java.lang.String database)
void	setHost(java.lang.String host)
void	setPass(java.lang.String pass)
void	setUser(java.lang.String user)

Methods inherited from class net.loadbang.sql.mxj.MXJ_SQL

dropDatabase, getDatabase, notifyDeleted, query, setDatabase, update

Methods inherited from class net.loadbang.util.EnrichedMaxObject

getLogger

Methods inherited from class com.cycling74.max.MaxObject

anything, bail, bang, createInfoOutlet, dblclick, declareAttribute, declareAttribute, declareInlets, declareIO, declareOutlets, declareReadOnlyAttribute, declareReadOnlyAttribute, declareTypedIO, embedMessage, error, gc, getAttr, getAttrAtomArray, getAttrBool, getAttrBoolArray, getAttrByte, getAttrByteArray, getAttrChar, getAttrCharArray, getAttrDouble, getAttrDoubleArray, getAttrFloat, getAttrFloatArray, getAttributeInfo, getAttrInt, getAttrIntArray, getAttrLongArray, getAttrShort, getAttrShortArray, getAttrString, getAttrStringArray, getCodeSourcePath, getContext, getErrorStream, getInfoIdx, getInlet, getInletAssist, getInletType, getLongAttr, getMaxBox, getName, getNumInlets, getNumOutlets, getOutletAssist, getOutletType, getParentPatcher, getPostStream, inlet, inlet, list, loadbang, ouch, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outlet, outletBang, outletBangHigh, outletHigh, outletHigh, outletHigh, outletHigh, outletHigh, outletHigh, outletHigh, outletHigh, outletHigh, outletHigh, post, postCodePath, save, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setAttr, setInletAssist, setInletAssist, setName, setOutletAssist, setOutletAssist, showException, showException, toString, viewsource, zap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

MySQL

public MySQL()

Constructor. Initialises Log4j, sets up attributes.

Method Detail

getDb

public java.lang.String getDb()

setDb

public void setDb(java.lang.String database)

getHost

public java.lang.String getHost()

setHost

public void setHost(java.lang.String host)

getPass

public java.lang.String getPass()

setPass

public void setPass(java.lang.String pass)

getUser

public java.lang.String getUser()

setUser

public void setUser(java.lang.String user)

connect

public void connect()
             throws SetupException

Connect to MySQL, taking setup parameters from attributes.

Throws:

SetupException

disconnect

public void disconnect()

Disconnect from MySQL (done automatically when MXJ instance deleted).