@Test
public void testConnection() throws Exception {
Connection conn = getConnection();
assertNull(conn.getMetaData());
assertFalse(conn.getAutoCommit());
conn.setAutoCommit(true);
assertTrue(conn.getAutoCommit());
conn.setAutoCommit(false);
assertTrue(conn.isReadOnly());
conn.setReadOnly(true);
assertTrue(conn.isReadOnly());
assertEquals(Connection.TRANSACTION_NONE, conn.getTransactionIsolation());
conn.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
assertEquals(Connection.TRANSACTION_READ_UNCOMMITTED, conn.getTransactionIsolation());
conn.setTransactionIsolation(Connection.TRANSACTION_NONE);
assertNull(conn.getWarnings());
conn.clearWarnings();
assertEquals(ResultSet.HOLD_CURSORS_OVER_COMMIT, conn.getHoldability());
conn.setHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT);
assertEquals(ResultSet.CLOSE_CURSORS_AT_COMMIT, conn.getHoldability());
conn.setHoldability(ResultSet.HOLD_CURSORS_OVER_COMMIT);
conn.commit();
conn.rollback();
assertTrue(conn.isValid(0));
conn.setClientInfo("prop1", "value1");
Properties props = new Properties();
props.setProperty("prop2", "value2");
props.setProperty("prop3", "value3");
conn.setClientInfo(props);
assertEquals("value1", conn.getClientInfo("prop1"));
assertEquals("value2", conn.getClientInfo("prop2"));
assertEquals("value3", conn.getClientInfo("prop3"));
Properties props2 = conn.getClientInfo();
assertEquals("value1", props2.getProperty("prop1"));
assertEquals("value2", props2.getProperty("prop2"));
assertEquals("value3", props2.getProperty("prop3"));
assertNotNull(((JcrJdbcConnection) conn).getJcrSession());
assertFalse(conn.isClosed());
conn.close();
assertTrue(conn.isClosed());
}
public C3P0PooledConnection(
Connection con,
ConnectionTester connectionTester,
boolean autoCommitOnClose,
boolean forceIgnoreUnresolvedTransactions,
ConnectionCustomizer cc,
String pdsIdt)
throws SQLException {
try {
if (cc != null) cc.onAcquire(con, pdsIdt);
} catch (Exception e) {
throw SqlUtils.toSQLException(e);
}
this.physicalConnection = con;
this.connectionTester = connectionTester;
this.autoCommitOnClose = autoCommitOnClose;
this.forceIgnoreUnresolvedTransactions = forceIgnoreUnresolvedTransactions;
this.supports_setTypeMap =
C3P0ImplUtils.supportsMethod(con, "setTypeMap", new Class[] {Map.class});
this.supports_setHoldability =
C3P0ImplUtils.supportsMethod(con, "setHoldability", new Class[] {int.class});
this.dflt_txn_isolation = con.getTransactionIsolation();
this.dflt_catalog = con.getCatalog();
this.dflt_holdability =
(supports_setHoldability ? con.getHoldability() : ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
public int getHoldability() {
try {
return con.getHoldability();
} catch (Exception ex) {
ex.printStackTrace();
}
return 0;
}
public int getHoldability() throws SQLException {
String methodCall = "getHoldability()";
try {
return reportReturn(methodCall, realConnection.getHoldability());
} catch (SQLException s) {
reportException(methodCall, s);
throw s;
}
}
public DruidConnectionHolder(DruidAbstractDataSource dataSource, Connection conn)
throws SQLException {
this.dataSource = dataSource;
this.conn = conn;
this.connectTimeMillis = System.currentTimeMillis();
this.lastActiveTimeMillis = connectTimeMillis;
this.underlyingAutoCommit = conn.getAutoCommit();
{
boolean initUnderlyHoldability = !holdabilityUnsupported;
if (JdbcConstants.SYBASE.equals(dataSource.getDbType()) //
|| JdbcConstants.DB2.equals(dataSource.getDbType()) //
) {
initUnderlyHoldability = false;
}
if (initUnderlyHoldability) {
try {
this.underlyingHoldability = conn.getHoldability();
} catch (UnsupportedOperationException e) {
holdabilityUnsupported = true;
LOG.warn("getHoldability unsupported", e);
} catch (SQLFeatureNotSupportedException e) {
holdabilityUnsupported = true;
LOG.warn("getHoldability unsupported", e);
} catch (SQLException e) {
// bug fixed for hive jdbc-driver
if ("Method not supported".equals(e.getMessage())) {
holdabilityUnsupported = true;
}
LOG.warn("getHoldability error", e);
}
}
}
this.underlyingReadOnly = conn.isReadOnly();
try {
this.underlyingTransactionIsolation = conn.getTransactionIsolation();
} catch (SQLException e) {
// compartible for alibaba corba
if (!"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException"
.equals(e.getClass().getName())) {
throw e;
}
}
this.defaultHoldability = underlyingHoldability;
this.defaultTransactionIsolation = underlyingTransactionIsolation;
this.defaultAutoCommit = underlyingAutoCommit;
this.defaultReadOnly = underlyingReadOnly;
}
public void checkConnection(String dsName, Connection conn) throws SQLException {
System.out.println("Running JDBC 3.0 connection checks on " + dsName);
System.out.println(
" holdability " + (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
// check it's a 3.0 connection object
try {
conn.releaseSavepoint(conn.setSavepoint());
System.out.println("JDBC 3.0 savepoint OK");
} catch (SQLException sqle) {
// we expect savepoints exceptions because either
// it's a global transaction, or it's in auto commit mode.
System.out.println("JDBC 3.0 savepoint " + sqle.toString());
}
super.checkConnection(dsName, conn);
}
@Override
public int getHoldability() throws SQLException {
return conn.getHoldability();
}
private void checkXAHoldability() {
System.out.println("START XA HOLDABILITY TEST");
try {
EmbeddedXADataSource dscsx = new EmbeddedXADataSource();
dscsx.setDatabaseName("wombat");
XAConnection xac = dscsx.getXAConnection("fred", "wilma");
XAResource xr = xac.getXAResource();
Xid xid = getXid(25, (byte) 21, (byte) 01);
Connection conn1 = xac.getConnection();
System.out.println(
"By default, autocommit is " + conn1.getAutoCommit() + " for a connection");
System.out.println("Default holdability for a connection is HOLD_CURSORS_OVER_COMMIT");
System.out.println(
"CONNECTION(not in xa transaction yet) HOLDABILITY "
+ (conn1.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
// start a global transaction and default holdability and autocommit will be switched to match
// Derby XA restrictions
xr.start(xid, XAResource.TMNOFLAGS);
System.out.println(
"Notice that autocommit now is "
+ conn1.getAutoCommit()
+ " for connection because it is part of the global transaction");
System.out.println(
"Notice that connection's holdability at this point is CLOSE_CURSORS_AT_COMMIT because it is part of the global transaction");
System.out.println(
"CONNECTION(in xa transaction) HOLDABILITY "
+ (conn1.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
xr.end(xid, XAResource.TMSUCCESS);
conn1.commit();
conn1.close();
xid = getXid(27, (byte) 21, (byte) 01);
xr.start(xid, XAResource.TMNOFLAGS);
conn1 = xac.getConnection();
System.out.println(
"CONNECTION(in xa transaction) HOLDABILITY "
+ (conn1.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"Autocommit on Connection inside global transaction has been set correctly to "
+ conn1.getAutoCommit());
xr.end(xid, XAResource.TMSUCCESS);
conn1.rollback();
Connection conn = xac.getConnection();
conn.setAutoCommit(false);
conn.setHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT);
System.out.println(
"CONNECTION(non-xa) HOLDABILITY "
+ (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
Statement s = conn.createStatement();
System.out.println(
"STATEMENT HOLDABILITY "
+ (s.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
s.executeUpdate("create table hold_30 (id int not null primary key, b char(30))");
s.executeUpdate("insert into hold_30 values (1,'init2'), (2, 'init3'), (3,'init3')");
s.executeUpdate("insert into hold_30 values (4,'init4'), (5, 'init5'), (6,'init6')");
s.executeUpdate("insert into hold_30 values (7,'init7'), (8, 'init8'), (9,'init9')");
System.out.println(
"STATEMENT HOLDABILITY "
+ (s.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
Statement sh =
conn.createStatement(
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
PreparedStatement psh =
conn.prepareStatement(
"select id from hold_30 for update",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
CallableStatement csh =
conn.prepareCall(
"select id from hold_30 for update",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
System.out.println(
"STATEMENT HOLDABILITY "
+ (sh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"PREPARED STATEMENT HOLDABILITY "
+ (psh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"CALLABLE STATEMENT HOLDABILITY "
+ (csh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
ResultSet rsh = sh.executeQuery("select id from hold_30 for update");
rsh.next();
System.out.println("H@1 id " + rsh.getInt(1));
rsh.next();
System.out.println("H@2 id " + rsh.getInt(1));
conn.commit();
rsh.next();
System.out.println("H@3 id " + rsh.getInt(1));
conn.commit();
xid = getXid(23, (byte) 21, (byte) 01);
xr.start(xid, XAResource.TMNOFLAGS);
Statement stmtInsideGlobalTransaction = conn.createStatement();
PreparedStatement prepstmtInsideGlobalTransaction =
conn.prepareStatement("select id from hold_30");
CallableStatement callablestmtInsideGlobalTransaction =
conn.prepareCall("select id from hold_30");
System.out.println(
"CONNECTION(xa) HOLDABILITY "
+ (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY "
+ (s.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY "
+ (sh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY "
+ (stmtInsideGlobalTransaction.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"PREPAREDSTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY "
+ (prepstmtInsideGlobalTransaction.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"CALLABLESTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY "
+ (callablestmtInsideGlobalTransaction.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
ResultSet rsx = s.executeQuery("select id from hold_30 for update");
rsx.next();
System.out.println("X@1 id " + rsx.getInt(1));
rsx.next();
System.out.println("X@2 id " + rsx.getInt(1));
xr.end(xid, XAResource.TMSUCCESS);
// result set should not be useable, since it is part of a detached
// XAConnection
try {
rsx.next();
System.out.println("FAIL - rsx's connection not active id " + rsx.getInt(1));
} catch (SQLException sqle) {
System.out.println("Expected SQLException " + sqle.getMessage());
}
// result set should not be useable, it should have been closed by the xa start.
try {
rsh.next();
System.out.println("FAIL - rsh's should be closed " + rsx.getInt(1));
} catch (SQLException sqle) {
System.out.println("Expected SQLException " + sqle.getMessage());
}
System.out.println("resume XA transaction and keep using rs");
xr.start(xid, XAResource.TMJOIN);
Statement stmtAfterGlobalTransactionResume = conn.createStatement();
PreparedStatement prepstmtAfterGlobalTransactionResume =
conn.prepareStatement("select id from hold_30");
CallableStatement callablestmtAfterGlobalTransactionResume =
conn.prepareCall("select id from hold_30");
System.out.println("Check holdability of various jdbc objects after resuming XA transaction");
System.out.println(
"CONNECTION(xa) HOLDABILITY "
+ (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY "
+ (s.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY "
+ (sh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY "
+ (stmtInsideGlobalTransaction.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"PREPAREDSTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY "
+ (prepstmtInsideGlobalTransaction.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"CALLABLESTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY "
+ (callablestmtInsideGlobalTransaction.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"STATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY "
+ (stmtAfterGlobalTransactionResume.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"PREPAREDSTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY "
+ (prepstmtAfterGlobalTransactionResume.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
System.out.println(
"CALLABLESTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY "
+ (callablestmtAfterGlobalTransactionResume.getResultSetHoldability()
== ResultSet.HOLD_CURSORS_OVER_COMMIT));
rsx.next();
System.out.println("X@3 id " + rsx.getInt(1));
xr.end(xid, XAResource.TMSUCCESS);
if (xr.prepare(xid) != XAResource.XA_RDONLY) xr.commit(xid, false);
// try again once the xa transaction has been committed.
try {
rsx.next();
System.out.println("FAIL - rsx's connection not active id (B)" + rsx.getInt(1));
} catch (SQLException sqle) {
System.out.println("Expected SQLException " + sqle.getMessage());
}
try {
rsh.next();
System.out.println("FAIL - rsh's should be closed (B) " + rsx.getInt(1));
} catch (SQLException sqle) {
System.out.println("Expected SQLException " + sqle.getMessage());
}
System.out.println("Set connection to hold ");
conn.setHoldability(ResultSet.HOLD_CURSORS_OVER_COMMIT);
System.out.println(
"CONNECTION(held) HOLDABILITY "
+ (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
xid = getXid(24, (byte) 21, (byte) 01);
xr.start(xid, XAResource.TMNOFLAGS);
System.out.println(
"CONNECTION(xa) HOLDABILITY "
+ (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
try {
conn.setHoldability(ResultSet.HOLD_CURSORS_OVER_COMMIT);
System.out.println("FAIL allowed to set hold mode in xa transaction");
} catch (SQLException sqle) {
System.out.println("Expected SQLException(setHoldability) " + sqle.getMessage());
}
// try to create a statement with held attributes
try {
Statement shxa =
conn.createStatement(
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
System.out.println(
"FAIL opened statement with hold cursor attribute in global transaction");
} catch (SQLException sqle) {
System.out.println("Expected SQLException (Statement hold) " + sqle.getMessage());
}
try {
Statement shxa =
conn.prepareStatement(
"select id from hold_30",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
System.out.println(
"FAIL opened statement with hold cursor attribute in global transaction");
} catch (SQLException sqle) {
System.out.println("Expected SQLException (PreparedStatement hold) " + sqle.getMessage());
}
try {
Statement shxa =
conn.prepareCall(
"CALL XXX.TTT()",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
System.out.println(
"FAIL opened statement with hold cursor attribute in global transaction");
} catch (SQLException sqle) {
System.out.println("Expected SQLException (CallableStatement hold) " + sqle.getMessage());
}
// check we cannot use a holdable statement set up in local mode.
System.out.println(
"STATEMENT HOLDABILITY "
+ (sh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
try {
sh.executeQuery("select id from hold_30");
System.out.println("FAIL used held statement in global transaction");
} catch (SQLException sqle) {
System.out.println("Expected SQLException (local Statement hold) " + sqle.getMessage());
}
try {
sh.execute("select id from hold_30");
System.out.println("FAIL used held statement in global transaction");
} catch (SQLException sqle) {
System.out.println("Expected SQLException (local Statement hold) " + sqle.getMessage());
}
System.out.println(
"PREPARED STATEMENT HOLDABILITY "
+ (psh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
try {
psh.executeQuery();
System.out.println("FAIL used held prepared statement in global transaction");
} catch (SQLException sqle) {
System.out.println(
"Expected SQLException (local PreparedStatement hold) " + sqle.getMessage());
}
try {
psh.execute();
System.out.println("FAIL used held prepared statement in global transaction");
} catch (SQLException sqle) {
System.out.println(
"Expected SQLException (local PreparedStatement hold) " + sqle.getMessage());
}
System.out.println(
"CALLABLE STATEMENT HOLDABILITY "
+ (csh.getResultSetHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
try {
csh.executeQuery();
System.out.println("FAIL used held callable statement in global transaction");
} catch (SQLException sqle) {
System.out.println(
"Expected SQLException (local CallableStatement hold) " + sqle.getMessage());
}
try {
csh.execute();
System.out.println("FAIL used held callable statement in global transaction");
} catch (SQLException sqle) {
System.out.println(
"Expected SQLException (local CallableStatement hold) " + sqle.getMessage());
}
// but an update works
sh.executeUpdate("insert into hold_30 values(10, 'init10')");
xr.end(xid, XAResource.TMSUCCESS);
System.out.println(
"CONNECTION(held) HOLDABILITY "
+ (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
conn.close();
System.out.println("PASS XA HOLDABILITY TEST");
} catch (XAException xae) {
System.out.println("XAException error code " + xae.errorCode);
xae.printStackTrace(System.out);
Throwable t = xae.getCause();
if (t instanceof SQLException) JDBCDisplayUtil.ShowSQLException(System.out, (SQLException) t);
} catch (SQLException sqle) {
JDBCDisplayUtil.ShowSQLException(System.out, sqle);
} catch (Throwable t) {
t.printStackTrace(System.out);
}
System.out.flush();
}
protected void getHoldability(Connection conn) throws SQLException {
System.out.println(
" holdability " + (conn.getHoldability() == ResultSet.HOLD_CURSORS_OVER_COMMIT));
}
public int getHoldability() throws SQLException {
return connection.getHoldability();
}
@Test
public void testConnectionWhenClosed() throws Exception {
Connection conn = getConnection();
conn.close();
try {
conn.createStatement();
fail();
} catch (SQLException ignore) {
}
try {
conn.createStatement(1, 1);
fail();
} catch (SQLException ignore) {
}
try {
conn.createStatement(1, 1, 1);
fail();
} catch (SQLException ignore) {
}
try {
conn.prepareStatement(null);
fail();
} catch (SQLException ignore) {
}
try {
conn.prepareStatement(null, 1, 1);
fail();
} catch (SQLException ignore) {
}
try {
conn.prepareStatement(null, 1, 1, 1);
fail();
} catch (SQLException ignore) {
}
try {
conn.prepareStatement(null, 1);
fail();
} catch (SQLException ignore) {
}
try {
conn.prepareStatement(null, (int[]) null);
fail();
} catch (SQLException ignore) {
}
try {
conn.prepareStatement(null, (String[]) null);
fail();
} catch (SQLException ignore) {
}
try {
conn.nativeSQL(null);
fail();
} catch (SQLException ignore) {
}
try {
conn.setAutoCommit(true);
fail();
} catch (SQLException ignore) {
}
try {
conn.getAutoCommit();
fail();
} catch (SQLException ignore) {
}
try {
conn.commit();
fail();
} catch (SQLException ignore) {
}
try {
conn.rollback();
fail();
} catch (SQLException ignore) {
}
try {
conn.setReadOnly(true);
fail();
} catch (SQLException ignore) {
}
try {
conn.isReadOnly();
fail();
} catch (SQLException ignore) {
}
try {
conn.setTransactionIsolation(1);
fail();
} catch (SQLException ignore) {
}
try {
conn.getTransactionIsolation();
fail();
} catch (SQLException ignore) {
}
try {
conn.setHoldability(1);
fail();
} catch (SQLException ignore) {
}
try {
conn.getHoldability();
fail();
} catch (SQLException ignore) {
}
try {
conn.setClientInfo("var1", "value1");
fail();
} catch (SQLException ignore) {
}
try {
conn.getClientInfo("var1");
fail();
} catch (SQLException ignore) {
}
try {
conn.setClientInfo(null);
fail();
} catch (SQLException ignore) {
}
try {
conn.getClientInfo();
fail();
} catch (SQLException ignore) {
}
}
@Override
public int getHoldability() throws SQLException {
return _wrapped.getHoldability();
}