MySQLHelper

public class MySQLHelper implements DBHelper 

Provides cached statements for a MySQL back-end.

Author:: tf

Methods

cleanUp

public void cleanUp(): Reset SRID variable, close all statements, roll back to last save point and close connection.

commit

public void commit(): Make all changes permanent.

getConnection

public Connection getConnection()

initConnection

public Connection initConnection(TransactionInterface transaction)

initTransaction

public void initTransaction(Connection connection, WriteTransactionInterface transaction)

Initialize a transaction by calling the corresponding SQL procedure.

In the database, this adds a row to the transaction table with SRID, user and timestamp.

prepareStatement

public PreparedStatement prepareStatement(String statement)

Prepare a statement from a string. Reuse prepared statements from the cache if available.

Parameters:

statement –

Throws:

SQLException –
ConnectionException –

setHelped

public void setHelped(TransactionInterface transaction)