• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• ibmutl001_unlock_transaction.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

h2.function.ibmutl001_unlock_transaction.sql Maven / Gradle / Ivy

DROP ALIAS IF EXISTS ibmutl001_unlock_transaction;
CREATE ALIAS ibmutl001_unlock_transaction AS $$
void execute(java.sql.Connection connection) throws Exception {
  java.sql.PreparedStatement preparedStatement = connection.prepareStatement("delete from TRANSLOCK where SID = SESSION_ID()");
  preparedStatement.execute();

  java.sql.PreparedStatement preparedStatementMaster = connection.prepareStatement("delete from TRANSLOCK_MASTER where SID = SESSION_ID()");
  preparedStatementMaster.execute();
}
$$;