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:

setHelped#

public void setHelped(TransactionInterface transaction)#