📄 checkdatasource30.out
字号:
has warnings falseFAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for DatabaseMetaData.getConnection()setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supportedsetTypeMap(null) - ok null - Connection.setTypeMap is not supportedsetTypeMap(map) - ok null - Connection.setTypeMap is not supportedEVENT(5):connectionClosedmethod calls on a closed connectionSwitch to local XADataSource <closedconn>.close() no errorSwitch to local XADataSource <closedconn>.createStatement() null - Attempt to use a closed connection. Switch to local XADataSource <closedstmt>.execute() null - Invalid operation: statement closedRunning JDBC 3.0 connection checks on Switch to local XADataSource holdability trueJDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode.Running connection checks on Switch to local XADataSource isolation level 2 auto commit true read only false has warnings falseFAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for DatabaseMetaData.getConnection()setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supportedsetTypeMap(null) - ok null - Connection.setTypeMap is not supportedsetTypeMap(map) - ok null - Connection.setTypeMap is not supportedEVENT(5):connectionClosedmethod calls on a closed connectionSwitch to local XADataSource <closedconn>.close() no errorSwitch to local XADataSource <closedconn>.createStatement() null - Attempt to use a closed connection. Switch to local XADataSource <closedstmt>.execute() null - Invalid operation: statement closedRunning JDBC 3.0 connection checks on Switch to global XADataSource holdability falseJDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode.Running connection checks on Switch to global XADataSource isolation level 2 auto commit false read only false has warnings falseFAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for DatabaseMetaData.getConnection()setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supportedsetTypeMap(null) - ok null - Connection.setTypeMap is not supportedsetTypeMap(map) - ok null - Connection.setTypeMap is not supportedEVENT(5):connectionClosedmethod calls on a closed connectionSwitch to global XADataSource <closedconn>.close() no errorSwitch to global XADataSource <closedconn>.createStatement() null - Attempt to use a closed connection. Switch to global XADataSource <closedstmt>.execute() null - Invalid operation: statement closedRunning JDBC 3.0 connection checks on Switch to global XADataSource holdability falseJDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode.Running connection checks on Switch to global XADataSource isolation level 2 auto commit false read only false has warnings falseFAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for Statement.getConnection()FAIL incorrect connection object returned for DatabaseMetaData.getConnection()setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supportedsetTypeMap(null) - ok null - Connection.setTypeMap is not supportedsetTypeMap(map) - ok null - Connection.setTypeMap is not supportedEVENT(5):connectionClosedmethod calls on a closed connectionSwitch to global XADataSource <closedconn>.close() no errorSwitch to global XADataSource <closedconn>.createStatement() null - Attempt to use a closed connection. Switch to global XADataSource <closedstmt>.execute() null - Invalid operation: statement closedinitial local holdability true isolation level READ_COMMITTED auto commit true read only falseinitial X1 holdability false isolation level READ_COMMITTED auto commit false read only falsemodified X1 holdability false isolation level READ_UNCOMMITTED auto commit false read only falsemodified local holdability false isolation level READ_UNCOMMITTED auto commit true read only falsereset local holdability false isolation level READ_COMMITTED auto commit true read only falsere-join X1 holdability false isolation level READ_UNCOMMITTED auto commit false read only falseback to local (same as reset) holdability false isolation level READ_COMMITTED auto commit true read only falsere-join X1 second time holdability false isolation level READ_UNCOMMITTED auto commit false read only falselocal after suspend holdability false isolation level READ_COMMITTED auto commit true read only falseresume X1 holdability false isolation level READ_UNCOMMITTED auto commit false read only falseback to local (second time) holdability false isolation level READ_COMMITTED auto commit true read only falseEVENT(6):connectionClosednew handle - local holdability true isolation level READ_COMMITTED auto commit true read only falseEVENT(6):connectionClosedre-join with new handle X1 holdability false isolation level READ_UNCOMMITTED auto commit false read only falseEVENT(6):connectionClosedpre-X1 commit - local holdability true isolation level REPEATABLE_READ auto commit true read only falsepre-X1 commit - X1 holdability false isolation level READ_UNCOMMITTED auto commit false read only falsepost-X1 end - local holdability true isolation level REPEATABLE_READ auto commit true read only falsepost-X1 commit - local holdability true isolation level REPEATABLE_READ auto commit true read only falseEVENT(6):connectionClosedSome more isolation testing using SQL and JDBC apiinitial local holdability true isolation level READ_COMMITTED auto commit true read only falseIssue setTransactionIsolation in local transactionsetTransactionIsolation in local holdability true isolation level READ_UNCOMMITTED auto commit true read only falseIssue SQL to change isolation in local transactionSQL to change isolation in local holdability true isolation level SERIALIZABLE auto commit true read only false1st global(new) holdability false isolation level SERIALIZABLE auto commit false read only falselocal holdability true isolation level SERIALIZABLE auto commit true read only falseIssue SQL to change isolation in local transactionSQL to change isolation in local holdability true isolation level REPEATABLE_READ auto commit true read only false1st global(existing) holdability false isolation level SERIALIZABLE auto commit false read only falselocal holdability true isolation level REPEATABLE_READ auto commit true read only false2nd global(new) holdability false isolation level REPEATABLE_READ auto commit false read only false1st global(existing) holdability false isolation level SERIALIZABLE auto commit false read only falselocal holdability true isolation level REPEATABLE_READ auto commit true read only false1st global(existing) holdability false isolation level SERIALIZABLE auto commit false read only falseIssue SQL to change isolation in 1st global transactionchange isolation of existing 1st global transaction holdability false isolation level READ_UNCOMMITTED auto commit false read only falselocal holdability true isolation level READ_UNCOMMITTED auto commit true read only false2nd global(existing) holdability false isolation level REPEATABLE_READ auto commit false read only false(After 2nd global rollback) local holdability true isolation level READ_UNCOMMITTED auto commit true read only false(After 1st global rollback) local holdability true isolation level READ_UNCOMMITTED auto commit true read only falseTESTING RE_USE OF STATEMENT OBJECTSLOCK TABLEEND LOCK TABLE
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -