📄 checkdatasource30.out
字号:
Switch to local XADataSource <closedconn>.createStatement() 08003 - No current connection.Switch to local XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.Running JDBC 3.0 connection checks on Switch to global XADataSource holdability falseJDBC 3.0 savepoint SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface.Running connection checks on Switch to global XADataSource isolation level 2 auto commit false read only false has warnings falsesetTypeMap(EMPTY_MAP) - oksetTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap'setTypeMap(map) - ok 0A000 - Feature not implemented: no details.EVENT(5):connectionClosedmethod calls on a closed connectionSwitch to global XADataSource <closedconn>.close() no errorSwitch to global XADataSource <closedconn>.createStatement() 08003 - No current connection.Switch to global XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.Running JDBC 3.0 connection checks on Switch to global XADataSource holdability falseJDBC 3.0 savepoint SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface.Running connection checks on Switch to global XADataSource isolation level 2 auto commit false read only false has warnings falsesetTypeMap(EMPTY_MAP) - oksetTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap'setTypeMap(map) - ok 0A000 - Feature not implemented: no details.EVENT(5):connectionClosedmethod calls on a closed connectionSwitch to global XADataSource <closedconn>.close() no errorSwitch to global XADataSource <closedconn>.createStatement() 08003 - No current connection.Switch to global XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.initial 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 truemodified local holdability false isolation level READ_UNCOMMITTED auto commit true read only truereset 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 trueback 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 truelocal 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 trueback 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 trueEVENT(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 truepost-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 TABLEStatement State @ Create getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 444 getMaxFieldSize() 713 getMaxRows() 19 getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT Statement State @ PS Create getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 888 getMaxFieldSize() 317 getMaxRows() 91 getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT Parameter Count 1 1 type 4Statement State @ CS Create getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 999 getMaxFieldSize() 137 getMaxRows() 85 getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT Parameter Count 2 1 type 12 2 type 12Params-local-1: ru(params) contents {3}sru1-local-1: ru(SN1) contents {1} {2} {3}Expecting downgrade because global transaction sru1-global-2 is using a statement with holdability truesru1-global-2: ru(SN1) contents {1} {2} {3}sru2-global-3: ru(OAK2) contents {1} {2} {3}Expecting downgrade because global transaction sru1-global-4 is using a statement with holdability truesru1-global-4: ru(SN1) contents {1} {2} {3}Statement State @ GLOBAL getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 444 getMaxFieldSize() 713 getMaxRows() 19 getResultSetHoldability() CLOSE_CURSORS_AT_COMMIT Statement State @ PS GLOBAL getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 888 getMaxFieldSize() 317 getMaxRows() 91 getResultSetHoldability() CLOSE_CURSORS_AT_COMMIT Parameter Count 1 1 type 4Statement State @ CS GLOBAL getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 999 getMaxFieldSize() 137 getMaxRows() 85 getResultSetHoldability() CLOSE_CURSORS_AT_COMMIT Parameter Count 2 1 type 12 2 type 12Params-global-1: ru(params) contents {3}sru1-local-5: ru(SN1) contents {1} {2} {3}sru2-local-6: ru(OAK2) contents {1} {2} {3}sru3-local-7: ru(SF3) contents {1} {2} {3}Statement State @ LOCAL getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 444 getMaxFieldSize() 713 getMaxRows() 19 getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT Statement State @ PS LOCAL getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY getFetchDirection() REVERSE getFetchSize() 888 getMaxFieldSize() 317 getMaxRows() 91 getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT Parameter Count 1 1 type 4Statement State @ CS LOCAL getResultSetType() SCROLL_INSENSITIVE getResultSetConcurrency() READ_ONLY⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -