| /* |
| * Copyright (c) 1997, 2018 Oracle and/or its affiliates. All rights reserved. |
| * |
| * This program and the accompanying materials are made available under the |
| * terms of the Eclipse Public License v. 2.0, which is available at |
| * http://www.eclipse.org/legal/epl-2.0. |
| * |
| * This Source Code may also be made available under the following Secondary |
| * Licenses when the conditions for such availability set forth in the |
| * Eclipse Public License v. 2.0 are satisfied: GNU General Public License, |
| * version 2 with the GNU Classpath Exception, which is available at |
| * https://www.gnu.org/software/classpath/license.html. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0 |
| */ |
| |
| /* |
| * To change this template, choose Tools | Templates |
| * and open the template in the editor. |
| */ |
| package myapp.test; |
| |
| import java.io.PrintWriter; |
| import java.sql.Connection; |
| import java.sql.ResultSet; |
| import java.sql.Statement; |
| import java.util.HashMap; |
| import java.util.Map; |
| import javax.naming.InitialContext; |
| import javax.sql.DataSource; |
| import jakarta.transaction.SystemException; |
| import myapp.util.HtmlUtil; |
| import myapp.util.TablesUtil; |
| |
| /** |
| * |
| * @author jagadish |
| */ |
| public class UserTxTest implements SimpleTest { |
| |
| Map<String, Boolean> resultsMap = new HashMap<String, Boolean>(); |
| |
| public Map<String, Boolean> runTest(DataSource ds1, PrintWriter out) { |
| try { |
| if (testUserTxWithRollback(ds1, out)) { |
| resultsMap.put("user-tx-rollback", true); |
| }else{ |
| resultsMap.put("user-tx-rollback", false); |
| } |
| } catch (Exception e) { |
| resultsMap.put("user-tx-rollback", false); |
| } |
| |
| try { |
| if (testUserTxWithCommit(ds1, out)) { |
| resultsMap.put("user-tx-commit", true); |
| }else{ |
| resultsMap.put("user-tx-commit", false); |
| } |
| } catch (Exception e) { |
| resultsMap.put("user-tx-commit", false); |
| } |
| |
| return resultsMap; |
| |
| } |
| |
| private boolean testUserTxWithRollback(DataSource ds1, PrintWriter out) throws SystemException { |
| boolean result = false; |
| Connection con = null; |
| |
| Statement stmt = null; |
| ResultSet rs = null; |
| |
| String tableName = "user_tx_table_rollback_test"; |
| String content = "testUserTxWithRollback"; |
| String columnName = "message"; |
| TablesUtil.createTables(ds1, out, tableName, columnName); |
| |
| HtmlUtil.printHR(out); |
| out.println("<h4> user-tx-rollback test </h4>"); |
| jakarta.transaction.UserTransaction ut = null; |
| try { |
| InitialContext ic = new InitialContext(); |
| ut = (jakarta.transaction.UserTransaction) ic.lookup("java:comp/UserTransaction"); |
| out.println("<br>Able to lookup UserTransaction"); |
| ut.begin(); |
| out.println("<br>"); |
| out.println("Started UserTransaction<br>"); |
| |
| out.println("Trying to get connection ...<br>"); |
| |
| out.println("ds value : " + ds1); |
| con = ds1.getConnection(); |
| out.println("Got connection : " + con); |
| stmt = con.createStatement(); |
| stmt.executeUpdate("insert into " + tableName + " values ('" + content + "')"); |
| out.println("<br>"); |
| |
| out.println("Able to lookup datasource"); |
| out.println("<br>"); |
| out.println("Rolling back transaction<br>"); |
| ut.rollback(); |
| if (!TablesUtil.verifyTableContent(ds1, out, tableName, columnName, content)) { |
| result = true; |
| } |
| |
| } catch (Throwable e) { |
| HtmlUtil.printException(e, out); |
| result = false; |
| } finally { |
| try { |
| if (rs != null) { |
| rs.close(); |
| } |
| } catch (Exception e) { |
| HtmlUtil.printException(e, out); |
| } |
| |
| try { |
| if (stmt != null) { |
| stmt.close(); |
| } |
| } catch (Exception e) { |
| HtmlUtil.printException(e, out); |
| } |
| |
| try { |
| if (con != null) { |
| con.close(); |
| } |
| } catch (Exception e) { |
| HtmlUtil.printException(e, out); |
| } |
| |
| TablesUtil.deleteTables(ds1, out, tableName); |
| HtmlUtil.printHR(out); |
| return result; |
| } |
| } |
| |
| private boolean testUserTxWithCommit(DataSource ds1, PrintWriter out) throws SystemException, |
| IllegalStateException, SecurityException { |
| boolean result = false; |
| Connection con = null; |
| |
| Statement stmt = null; |
| ResultSet rs = null; |
| |
| String tableName = "user_tx_table_commit_test"; |
| String content = "testUserTxWithCommit"; |
| String columnName = "message"; |
| TablesUtil.createTables(ds1, out, tableName, columnName); |
| |
| HtmlUtil.printHR(out); |
| out.println("<h4> user-tx-commit test </h4>"); |
| jakarta.transaction.UserTransaction ut = null; |
| try { |
| InitialContext ic = new InitialContext(); |
| ut = (jakarta.transaction.UserTransaction) ic.lookup("java:comp/UserTransaction"); |
| out.println("<br>Able to lookup UserTransaction"); |
| ut.begin(); |
| out.println("<br>"); |
| out.println("Started UserTransaction<br>"); |
| |
| out.println("Trying to get connection ...<br>"); |
| |
| out.println("ds value : " + ds1); |
| con = ds1.getConnection(); |
| out.println("Got connection : " + con); |
| stmt = con.createStatement(); |
| stmt.executeUpdate("insert into " + tableName + " values ('" + content + "')"); |
| out.println("<br>"); |
| |
| out.println("Able to lookup datasource"); |
| out.println("<br>"); |
| ut.commit(); |
| result = TablesUtil.verifyTableContent(ds1, out, tableName, columnName, content); |
| |
| } catch (Throwable e) { |
| HtmlUtil.printException(e, out); |
| out.println("Rolling back transaction<br>"); |
| ut.rollback(); |
| result = false; |
| } finally { |
| try { |
| if (rs != null) { |
| rs.close(); |
| } |
| } catch (Exception e) { |
| HtmlUtil.printException(e, out); |
| } |
| |
| try { |
| if (stmt != null) { |
| stmt.close(); |
| } |
| } catch (Exception e) { |
| HtmlUtil.printException(e, out); |
| } |
| |
| try { |
| if (con != null) { |
| con.close(); |
| } |
| } catch (Exception e) { |
| HtmlUtil.printException(e, out); |
| } |
| TablesUtil.deleteTables(ds1, out, tableName); |
| HtmlUtil.printHR(out); |
| return result; |
| } |
| } |
| } |