checkdatasource30.out

derby database source code.good for you.

  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 2
    1 type 12
    2 type 12
Params-local-2: ru(params) contents {3}
LOCK TABLE
  xid row 0 lock count 14
  xid row 1 lock count 14
END LOCK TABLE
sru1-local-8: ru(SN1) contents {1} {2} {3}
sru2-local-9: ru(OAK2) contents {1} {2} {3}
sru3-local-10: ru(SF3) contents {1} {2} {3}
Statement State @ LOCAL 2 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 444
  getMaxFieldSize() 713
  getMaxRows() 19
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
Statement State @ PS LOCAL 2 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 1
    1 type 4
Statement State @ CS LOCAL 2
  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 12
LOCK TABLE
  xid row 0 lock count 14
  xid row 1 lock count 12
END LOCK TABLE
sruBatch update counts : 1  1  2  1 :
sruBatch: ru(null) contents {1} {2} {3} {4} {5} {6} {7} {8}
XAConnection.getXAResource : No current connection.
XAConnection.getConnection : No current connection.
XAResource.start : XAException - No current connection.
ERROR 08003: No current connection.
XAResource.end : XAException - No current connection.
ERROR 08003: No current connection.
XAResource.commit : XAException - No current connection.
ERROR 08003: No current connection.
XAResource.prepare : XAException - No current connection.
ERROR 08003: No current connection.
XAResource.recover : XAException - No current connection.
ERROR 08003: No current connection.
XAResource.prepare : XAException - No current connection.
ERROR 08003: No current connection.
XAResource.isSameRM : XAException - No current connection.
ERROR 08003: No current connection.
Patricio update count 1
conn4 autcommit true
acxs 1
acxs 2
autocommitxastart expected No current connection.
acxs 1
acxs 2
autocommitxastart expected  : XAException - null
Expected XA error code: -9
acxs 3
testing jira 95 for DataSource; ok - expected exception: XCY00
testing jira 95 for XADataSource; ok - expected exception: XCY00
DataSource - EMPTY
  getConnection() - XJ004:Database '' not found.
  getConnection(null, null) - XJ004:Database '' not found.
  getConnection(fred, null) - XJ004:Database '' not found.
  getConnection(fred, wilma) - XJ004:Database '' not found.
  getConnection(null, wilma) - XJ004:Database '' not found.
  getConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
DataSource - connectionAttributes=databaseName=wombat
  getConnection() - XJ004:Database '' not found.
  getConnection(null, null) - XJ004:Database '' not found.
  getConnection(fred, null) - XJ004:Database '' not found.
  getConnection(fred, wilma) - XJ004:Database '' not found.
  getConnection(null, wilma) - XJ004:Database '' not found.
  getConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
DataSource - attributesAsPassword=true
  getConnection() - XJ004:Database '' not found.
  getConnection(null, null) - XJ004:Database '' not found.
  getConnection(fred, null) - XJ004:Database '' not found.
  getConnection(fred, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getConnection(null, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
DataSource - attributesAsPassword=true, connectionAttributes=databaseName=kangaroo
  getConnection() - XJ004:Database '' not found.
  getConnection(null, null) - XJ004:Database '' not found.
  getConnection(fred, null) - XJ004:Database '' not found.
  getConnection(fred, wilma) - XJ028:The URL 'jdbc:derby: ;databaseName=kangaroo;wilma' is not properly formed.
  getConnection(null, wilma) - XJ028:The URL 'jdbc:derby: ;databaseName=kangaroo;wilma' is not properly formed.
  getConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
Enable Authentication
08006:Database 'wombat' shutdown.
AUTHENTICATION NOW ENABLED
DataSource - attributesAsPassword=true
  getConnection() - XJ004:Database '' not found.
  getConnection(null, null) - XJ004:Database '' not found.
  getConnection(fred, null) - XJ004:Database '' not found.
  getConnection(fred, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getConnection(null, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
DataSource - attributesAsPassword=true, user=fred, password=databaseName=wombat;password=wilma
  getConnection() - XJ004:Database '' not found.
  getConnection(null, null) - XJ004:Database '' not found.
  getConnection(fred, null) - XJ004:Database '' not found.
  getConnection(fred, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getConnection(null, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
ConnectionPoolDataSource - EMPTY
  getPooledConnection() - XJ004:Database '' not found.
  getPooledConnection(null, null) - XJ004:Database '' not found.
  getPooledConnection(fred, null) - XJ004:Database '' not found.
  getPooledConnection(fred, wilma) - XJ004:Database '' not found.
  getPooledConnection(null, wilma) - XJ004:Database '' not found.
  getPooledConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
ConnectionPoolDataSource - connectionAttributes=databaseName=wombat
  getPooledConnection() - XJ004:Database '' not found.
  getPooledConnection(null, null) - XJ004:Database '' not found.
  getPooledConnection(fred, null) - XJ004:Database '' not found.
  getPooledConnection(fred, wilma) - XJ004:Database '' not found.
  getPooledConnection(null, wilma) - XJ004:Database '' not found.
  getPooledConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
ConnectionPoolDataSource - attributesAsPassword=true
  getPooledConnection() - XJ004:Database '' not found.
  getPooledConnection(null, null) - XJ004:Database '' not found.
  getPooledConnection(fred, null) - XJ004:Database '' not found.
  getPooledConnection(fred, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getPooledConnection(null, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getPooledConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
ConnectionPoolDataSource - attributesAsPassword=true, user=fred, password=databaseName=wombat;password=wilma
  getPooledConnection() - XJ004:Database '' not found.
  getPooledConnection(null, null) - XJ004:Database '' not found.
  getPooledConnection(fred, null) - XJ004:Database '' not found.
  getPooledConnection(fred, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getPooledConnection(null, wilma) - XJ028:The URL 'jdbc:derby: ;wilma' is not properly formed.
  getPooledConnection(null, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=wilma) - XJ004:Database '' not found.
  getPooledConnection(fred, databaseName=wombat;password=betty) - XJ004:Database '' not found.
XADataSource - EMPTY
  getXAConnection() - 08006:Database not available
  getXAConnection(null, null) - 08006:Database not available
  getXAConnection(fred, null) - 08006:Database not available
  getXAConnection(fred, wilma) - 08006:Database not available
  getXAConnection(null, wilma) - 08006:Database not available
  getXAConnection(null, databaseName=wombat) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat;password=wilma) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat;password=betty) - 08006:Database not available
XADataSource - databaseName=wombat
  getXAConnection() - 08004:Connection refused : Invalid authentication.
  getXAConnection(null, null) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, null) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, wilma) - OK
  getXAConnection(null, wilma) - 08004:Connection refused : Invalid authentication.
  getXAConnection(null, databaseName=wombat) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, databaseName=wombat) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, databaseName=wombat;password=wilma) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, databaseName=wombat;password=betty) - 08004:Connection refused : Invalid authentication.
XADataSource - connectionAttributes=databaseName=wombat
  getXAConnection() - 08006:Database not available
  getXAConnection(null, null) - 08006:Database not available
  getXAConnection(fred, null) - 08006:Database not available
  getXAConnection(fred, wilma) - 08006:Database not available
  getXAConnection(null, wilma) - 08006:Database not available
  getXAConnection(null, databaseName=wombat) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat;password=wilma) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat;password=betty) - 08006:Database not available
XADataSource - attributesAsPassword=true
  getXAConnection() - 08006:Database not available
  getXAConnection(null, null) - 08006:Database not available
  getXAConnection(fred, null) - 08006:Database not available
  getXAConnection(fred, wilma) - 08006:Database not available
  getXAConnection(null, wilma) - 08006:Database not available
  getXAConnection(null, databaseName=wombat) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat;password=wilma) - 08006:Database not available
  getXAConnection(fred, databaseName=wombat;password=betty) - 08006:Database not available
XADataSource - databaseName=wombat, attributesAsPassword=true
  getXAConnection() - 08004:Connection refused : Invalid authentication.
  getXAConnection(null, null) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, null) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, wilma) - XJ028:The URL 'jdbc:derby:wombat;wilma' is not properly formed.
  getXAConnection(null, wilma) - XJ028:The URL 'jdbc:derby:wombat;wilma' is not properly formed.
  getXAConnection(null, databaseName=wombat) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, databaseName=wombat) - 08004:Connection refused : Invalid authentication.
  getXAConnection(fred, databaseName=wombat;password=wilma) - OK
  getXAConnection(fred, databaseName=wombat;password=betty) - 08004:Connection refused : Invalid authentication.
START XA HOLDABILITY TEST
By default, autocommit is true for a connection
Default holdability for a connection is HOLD_CURSORS_OVER_COMMIT
CONNECTION(not in xa transaction yet) HOLDABILITY true
Notice that autocommit now is false for connection because it is part of the global transaction
Notice that connection's holdability at this point is CLOSE_CURSORS_AT_COMMIT because it is part of the global transaction
CONNECTION(in xa transaction) HOLDABILITY false
CONNECTION(in xa transaction) HOLDABILITY false
Autocommit on Connection inside global transaction has been set correctly to false
CONNECTION(non-xa) HOLDABILITY false
STATEMENT HOLDABILITY false
STATEMENT HOLDABILITY false
STATEMENT HOLDABILITY true
PREPARED STATEMENT HOLDABILITY true
CALLABLE STATEMENT HOLDABILITY true
H@1 id 1
H@2 id 2
H@3 id 3
CONNECTION(xa) HOLDABILITY false
STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false
STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false
STATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false
PREPAREDSTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false
CALLABLESTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false
X@1 id 1
X@2 id 2
Expected SQLException No current connection.
Expected SQLException No current connection.
resume XA transaction and keep using rs
Check holdability of various jdbc objects after resuming XA transaction
CONNECTION(xa) HOLDABILITY false
STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false
STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false
STATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false
PREPAREDSTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false
CALLABLESTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false
STATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false
PREPAREDSTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false
CALLABLESTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false
X@3 id 3
Expected SQLException ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
Expected SQLException ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
Set connection to hold 
CONNECTION(held) HOLDABILITY true
CONNECTION(xa) HOLDABILITY false
Expected SQLException(setHoldability) Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
HOLDABLE Statement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.
HOLDABLE PreparedStatement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.
HOLDABLE CallableStatement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.
STATEMENT HOLDABILITY false
PREPARED STATEMENT HOLDABILITY false
CALLABLE STATEMENT HOLDABILITY false
CONNECTION(held) HOLDABILITY true
PASS XA HOLDABILITY TEST
**Test holdability state for: PooledConnection **
PASS: Holdability matches expected holdability:HOLD_CURSORS_OVER_COMMIT
** Test autoCommit state for: PooledConnection**
PASS: autoCommit reset on getConnection
done creating  table
*** Test isolation level reset on PooledConnection.getConnection()***
setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED
PASS: No lock timeout occurs for READ_UNCOMMITTED
Get a new connection with PooledConnection.getConnection()
Isolation level should be reset to READ_COMMITTED
PASS: Expected lock timeout for READ_COMMITTED
done creating  table
*** Test isolation level reset on XAConnection.getConnection()***
setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED
PASS: No lock timeout occurs for READ_UNCOMMITTED
Get a new connection with XAConnection.getConnection()
Isolation level should be reset to READ_COMMITTED
PASS: Expected lock timeout for READ_COMMITTED
Completed checkDataSource30