C D G H M N O P Q S U W

C

close() - Method in class net.loadbang.sql.Database

Close the connection.

connect() - Method in class net.loadbang.sql.mxj.MySQL

Connect to MySQL, taking setup parameters from attributes.

D

Database - Class in net.loadbang.sql

This is a connection to a database, with some intelligence to support callbacks and understand Max Atoms.

Database(String, String, String, String) - Constructor for class net.loadbang.sql.Database

Constructor: set up a database connector.

Database.ConnectionCallback<T> - Interface in net.loadbang.sql

An inner interface for connection callbacks.

disconnect() - Method in class net.loadbang.sql.mxj.MySQL

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

dropDatabase() - Method in class net.loadbang.sql.mxj.MXJ_SQL

Drop the database connection (closing it).

G

getDatabase() - Method in class net.loadbang.sql.mxj.MXJ_SQL

Return database connection, or fail.

getDb() - Method in class net.loadbang.sql.mxj.MySQL

getHost() - Method in class net.loadbang.sql.mxj.MySQL

getPass() - Method in class net.loadbang.sql.mxj.MySQL

getUser() - Method in class net.loadbang.sql.mxj.MySQL

go(Connection) - Method in interface net.loadbang.sql.Database.ConnectionCallback

Run a query or update operation, given a database connection.

H

HSQL_DB - Class in net.loadbang.sql

This is an encapsulated database connection to a HSQLDB located in the Max/MSP search path.

HSQL_DB(String) - Constructor for class net.loadbang.sql.HSQL_DB

Constructor: create an HSQLDB database in a location specified by the place-holder.

HSQL_JDBC_DRIVER - Static variable in interface net.loadbang.sql.util.Manifest

Name of the JDBC driver class for HSQL.

M

Manifest - Interface in net.loadbang.sql.util

Manifest constants.

MXJ_SQL - Class in net.loadbang.sql.mxj

A superclass for MXJ objects which connect to databases.

MXJ_SQL(Class) - Constructor for class net.loadbang.sql.mxj.MXJ_SQL

Constructor.

MySQL - Class in net.loadbang.sql.mxj

An MXJ object to connect to a MySQL database.

MySQL() - Constructor for class net.loadbang.sql.mxj.MySQL

Constructor.

MySQL_DB - Class in net.loadbang.sql

A connection to a MySQL database.

MySQL_DB(String, String, String, String) - Constructor for class net.loadbang.sql.MySQL_DB

Constructor.

MYSQL_JDBC_DRIVER - Static variable in interface net.loadbang.sql.util.Manifest

Name of the JDBC driver class for MySQL.

MYSQL_NONE - Static variable in interface net.loadbang.sql.util.Manifest

Magic identifier for empty user/pass in MySQL.

N

net.loadbang.sql - package net.loadbang.sql

net.loadbang.sql.exn - package net.loadbang.sql.exn

net.loadbang.sql.mxj - package net.loadbang.sql.mxj

net.loadbang.sql.util - package net.loadbang.sql.util

NoddySQL - Class in net.loadbang.sql.mxj

This is a simple MXJ object which provides an SQL connection to an embedded HSQLDB database.

NoddySQL() - Constructor for class net.loadbang.sql.mxj.NoddySQL

A constructor which bombs out unless it's been passed the name of the place-holder file.

NoddySQL(String) - Constructor for class net.loadbang.sql.mxj.NoddySQL

Constructor.

notifyDeleted() - Method in class net.loadbang.sql.mxj.MXJ_SQL

On object deletion, close the database connection.

O

open() - Method in class net.loadbang.sql.Database

Open a connection to the database.

OperationException - Exception in net.loadbang.sql.exn

A wrapper exception for runtime problems.

OperationException(String, Exception) - Constructor for exception net.loadbang.sql.exn.OperationException

Constructor.

OperationException(String) - Constructor for exception net.loadbang.sql.exn.OperationException

Constructor.

P

PLACE_HOLDER_SUFFIX - Static variable in interface net.loadbang.sql.util.Manifest

Suffix for place-holder files.

Q

query(String) - Method in class net.loadbang.sql.Database

Simple query method, without any prepared statement support, returning the results as a list of Atom arrays.

query(Atom[]) - Method in class net.loadbang.sql.mxj.MXJ_SQL

Run an SQL query.

S

setDatabase(Database) - Method in class net.loadbang.sql.mxj.MXJ_SQL

Set the database, having attempted to open it.

setDb(String) - Method in class net.loadbang.sql.mxj.MySQL

setHost(String) - Method in class net.loadbang.sql.mxj.MySQL

setPass(String) - Method in class net.loadbang.sql.mxj.MySQL

SetupException - Exception in net.loadbang.sql.exn

Exception for configuration/setup problems.

SetupException(String, Exception) - Constructor for exception net.loadbang.sql.exn.SetupException

SetupException(String) - Constructor for exception net.loadbang.sql.exn.SetupException

setUser(String) - Method in class net.loadbang.sql.mxj.MySQL

U

update(String) - Method in class net.loadbang.sql.Database

Simple update method, without any prepared statement support.

update(Atom[]) - Method in class net.loadbang.sql.mxj.MXJ_SQL

Run an update, and output the number of changed rows (as a message "update <N>").

W

withConnection(Database.ConnectionCallback<T>) - Method in class net.loadbang.sql.Database

Execute a callback on the connection; useful for prepared statements.

C D G H M N O P Q S U W