.. java:import:: java.io UnsupportedEncodingException

.. java:import:: java.sql CallableStatement

.. java:import:: java.sql Connection

.. java:import:: java.sql PreparedStatement

.. java:import:: java.sql SQLException

.. java:import:: java.sql Statement

.. java:import:: java.util HashMap

.. java:import:: org.caosdb.server.accessControl Principal

.. java:import:: org.caosdb.server.database.misc DBHelper

.. java:import:: org.caosdb.server.transaction ChecksumUpdater

.. java:import:: org.caosdb.server.transaction TransactionInterface

.. java:import:: org.caosdb.server.transaction WriteTransactionInterface

.. java:import:: org.slf4j Logger

.. java:import:: org.slf4j LoggerFactory

MySQLHelper
===========

.. java:package:: org.caosdb.server.database.backend.implementation.MySQL
   :noindex:

.. java:type:: public class MySQLHelper implements DBHelper

   Provides cached statements for a MySQL back-end.

   :author: tf

Methods
-------
cleanUp
^^^^^^^

.. java:method:: @Override public void cleanUp()
   :outertype: MySQLHelper

   Reset SRID variable, close all statements, roll back to last save point and close connection.

commit
^^^^^^

.. java:method:: @Override public void commit() throws SQLException
   :outertype: MySQLHelper

   Make all changes permanent.

getConnection
^^^^^^^^^^^^^

.. java:method:: public Connection getConnection() throws SQLException, ConnectionException
   :outertype: MySQLHelper

initConnection
^^^^^^^^^^^^^^

.. java:method:: public Connection initConnection(TransactionInterface transaction) throws ConnectionException, SQLException
   :outertype: MySQLHelper

initTransaction
^^^^^^^^^^^^^^^

.. java:method:: public void initTransaction(Connection connection, WriteTransactionInterface transaction) throws SQLException
   :outertype: MySQLHelper

   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
^^^^^^^^^^^^^^^^

.. java:method:: public PreparedStatement prepareStatement(String statement) throws SQLException, ConnectionException
   :outertype: MySQLHelper

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

   :param statement:
   :throws SQLException:
   :throws ConnectionException:

setHelped
^^^^^^^^^

.. java:method:: @Override public void setHelped(TransactionInterface transaction)
   :outertype: MySQLHelper