db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r158663 [1/2] - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNet/setTransactionIsolation.out master/setTransactionIsolation.out suites/jdbcapi.runall tests/jdbcapi/copyfiles.ant tests/jdbcapi/setTransactionIsolation.java tests/jdbcapi/setTransactionIsolation_derby.properties
Date Tue, 22 Mar 2005 20:27:53 GMT
Author: kmarsden
Date: Tue Mar 22 12:27:51 2005
New Revision: 158663

URL: http://svn.apache.org/viewcvs?view=rev&rev=158663
Log:
Add test for setTransactionIsolationLevel


Added:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/setTransactionIsolation.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/setTransactionIsolation.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/setTransactionIsolation.java   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/setTransactionIsolation_derby.properties   (with props)
Modified:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/setTransactionIsolation.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/setTransactionIsolation.out?view=auto&rev=158663
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/setTransactionIsolation.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/setTransactionIsolation.out Tue Mar 22 12:27:51 2005
@@ -0,0 +1,566 @@
+Creating table...
+done creating table and inserting data.
+*** testIsolation. makeNewStatements =true
+*** Test with no lock timeouts ***
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:true
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH100C1
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH300C1
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH200C2
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH400C1
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at serializable isolation level using share table locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:true
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+*** Test with lock timeouts on everything but read uncommitted***
+conn :insert into t1 values(4,'Forth Hello') (no commit)
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:true
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH100C1
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH300C1
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH200C2
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(select * from t1)
+select * from t1
+A lock could not be obtained within the time requested
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:true
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+*** testIsolation. makeNewStatements =false
+*** Test with no lock timeouts ***
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:false
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH200C2
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH200C2
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH200C2
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+-----
+Statement Name: 
+	SQL_CURSH200C2
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:false
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+insert into t1copy (select * from t1)
+null
+*** Test with lock timeouts on everything but read uncommitted***
+conn :insert into t1 values(4,'Forth Hello') (no commit)
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:false
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+select * from t1
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+select * from t1
+'Statement' already closed.
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+select * from t1
+'Statement' already closed.
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+select * from t1
+'Statement' already closed.
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:false
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/setTransactionIsolation.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/setTransactionIsolation.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/setTransactionIsolation.out?view=auto&rev=158663
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/setTransactionIsolation.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/setTransactionIsolation.out Tue Mar 22 12:27:51 2005
@@ -0,0 +1,674 @@
+Creating table...
+done creating table and inserting data.
+*** testIsolation. makeNewStatements =true
+*** Test with no lock timeouts ***
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:true
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at serializable isolation level using share table locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:true
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+*** Test with lock timeouts on everything but read uncommitted***
+conn :insert into t1 values(4,'Forth Hello') (no commit)
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:true
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(select * from t1)
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(select * from t1)
+select * from t1
+A lock could not be obtained within the time requested
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:true
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+*** testIsolation. makeNewStatements =false
+*** Test with no lock timeouts ***
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:false
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at serializable isolation level using share table locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:false
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+insert into t1copy (select * from t1)
+null
+*** Test with lock timeouts on everything but read uncommitted***
+conn :insert into t1 values(4,'Forth Hello') (no commit)
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:false
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+select * from t1
+1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+Statement Name: 
+	null
+Statement Text: 
+	select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text: 
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+	constructor time (milliseconds) = 0
+	open time (milliseconds) = 0
+	next time (milliseconds) = 0
+	close time (milliseconds) = 0
+scan information: 
+	Bit set of columns fetched=All
+	Number of columns fetched=2
+	Number of pages visited=0
+	Number of rows qualified=0
+	Number of rows visited=0
+	Scan type=heap
+	start position: 
+null	stop position: 
+null	qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+select * from t1
+A lock could not be obtained within the time requested
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:false
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/setTransactionIsolation.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall?view=diff&r1=158662&r2=158663
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall Tue Mar 22 12:27:51 2005
@@ -12,3 +12,5 @@
 jdbcapi/LOBTest.java
 jdbcapi/blobclob4BLOB.java
 jdbcapi/parameterMapping.java
+jdbcapi/setTransactionIsolation.java
+

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant?view=diff&r1=158662&r2=158663
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant Tue Mar 22 12:27:51 2005
@@ -38,6 +38,7 @@
 secureUsersldap_derby.properties
 secureUsersldap_sed.properties
 searchclob.txt
+setTransactionIsolation_derby.properties
 short.txt
 parameterMetaDataJdbc30_app.properties
 users.sql



Mime
View raw message