boolean channelOpen = adaptorChannel.isOpen();
if (!channelOpen) {
adaptorChannel.openChannel();
}
try {
JDBCContext jdbccontext = (JDBCContext) adaptorChannel.adaptorContext();
try {
jdbccontext.beginTransaction();
Connection conn = jdbccontext.connection();
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
conn.commit();
} catch (SQLException sqlexception) {
sqlexception.printStackTrace(System.out);
jdbccontext.rollbackTransaction();
throw sqlexception;
}
} finally {
if (!channelOpen) {
adaptorChannel.closeChannel();