Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <31086672.1157665582851.JavaMail.jira@brutus>
Date: Thu, 7 Sep 2006 14:46:22 -0700 (PDT)
From: "Mike Matrigali (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1757) checkDataSource30 produces no output,
 most likely hangs
In-Reply-To: <21101966.1156450514679.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

     [ http://issues.apache.org/jira/browse/DERBY-1757?page=3Dall ]

Mike Matrigali updated DERBY-1757:
----------------------------------

    Fix Version/s: 10.2.1.0

> checkDataSource30 produces no output, most likely hangs
> -------------------------------------------------------
>
>                 Key: DERBY-1757
>                 URL: http://issues.apache.org/jira/browse/DERBY-1757
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.2.1.0
>         Environment: Seen both on
> JVM: Sun JDK 6 (build 1.6.0-rc-b95)
> OS: Solaris 10 (sparc)=20
> and
> JVM: Sun JDK 5 (1.5.0_04)
> OS: RHEL 4=20
>            Reporter: Vemund =C3=98stgaard
>            Priority: Minor
>             Fix For: 10.2.1.0
>
>
> Seen while testing the 10.2.1.0 beta, in two different environments.
> Test produces no output, most likely it hangs and is killed after 1 hour.
> ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetma=
ts/jdk14/checkDataSource30.diff
> *** Start: checkDataSource30 jdk1.5.0_04 DerbyNetClient derbynetmats:jdk1=
4 2006-08-15 01:21:15 ***
> 711 del
> < 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 o=
f 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 correct=
ly 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 glob=
al transaction. Check it's holdability inside global transaction) HOLDABILI=
TY false
> < STATEMENT(this one was created with holdability true, outside the globa=
l transaction. Check it's holdability inside global transaction) HOLDABILIT=
Y true
> < STATEMENT(this one was created with default holdability inside this glo=
bal 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. :=20
> < Expected SQLException ResultSet not open.  Verify that autocommit is OF=
F.
> < 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 glob=
al transaction. Check it's holdability inside global transaction) HOLDABILI=
TY false
> < STATEMENT(this one was created with holdability true, outside the globa=
l transaction. Check it's holdability inside global transaction) HOLDABILIT=
Y true
> < STATEMENT(this one was created with default holdability inside the glob=
al transaction when it was first started. Check it's holdability) HOLDABILI=
TY false
> < PREPAREDSTATEMENT(this one was created with default holdability inside =
the global transaction when it was first started. Check it's holdability) H=
OLDABILITY false
> < CALLABLESTATEMENT(this one was created with default holdability inside =
the global transaction when it was first started. Check it's holdability) H=
OLDABILITY false
> < STATEMENT(this one was created with default holdability after the globa=
l transaction was resumed. Check it's holdability) HOLDABILITY false
> < PREPAREDSTATEMENT(this one was created with default holdability after t=
he global transaction was resumed. Check it's holdability) HOLDABILITY fals=
e
> < CALLABLESTATEMENT(this one was created with default holdability after t=
he global transaction was resumed. Check it's holdability) HOLDABILITY fals=
e
> < Expected SQLException ResultSet not open.  Verify that autocommit is OF=
F.
> < Expected SQLException ResultSet not open.  Verify that autocommit is OF=
F.
> < Set connection to hold=20
> < 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 ResultSetHol=
dability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global trans=
action.
> < HOLDABLE PreparedStatement in global xact false connection warning Resu=
ltSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a glob=
al transaction.
> < HOLDABLE CallableStatement in global xact false connection warning Resu=
ltSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a glob=
al transaction.
> < 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
> < Checked class declared as: javax.sql.DataSource
> < Completed checkDataSource30
> Test Failed.
> *** End:   checkDataSource30 jdk1.5.0_04 DerbyNetClient derbynetmats:jdk1=
4 2006-08-15 02:21:22 ***

--=20
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: htt=
p://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira