[DERBY-2681] SetQueryTimeoutTest. fails in J2ME environment

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0
• Fix Version/s: 10.2.2.1
• Component/s: Test

Environment

Generating report for RunSuite derbyall j9_foundation j9 null null true
------------------ Java Information ------------------
Java Version: J2ME Foundation Specification v1.0
Java Vendor: IBM Corporation
Java home: c:\jartest\wctme5.7\ive
Java classpath: c:/jartest/classes/derby.jar;c:/jartest/classes/derbyLocale*jar;c:/jartest/classes/derbytools.jar;
c:/jartest/classes/derbynet.jar;c:/jartest/classes/derbyclient.jar;;
c:/jartest/classes/derbyrun.jar;c:/jartest/classes/derbyTesting.jar;
c:/jartest/classes/maps.jar;c:/jartest/classes/functionTests.jar;c:/jartest/classes/csext.jar;
c:/jartest/tools/java/junit.jar;c:/jartest/tools/java/jndi/fscontext.jar
OS name: Windows 2000
OS architecture: x86
OS version: 5.0 build 2195 Service Pack 4
Java user name: cloudtest
Java user home: C:\Documents and Settings\cloudtest
Java user dir: C:\jartest\JarResults.2007-05-21\wctme5.7_foundation_derbyall
java.specification.name: J2ME Foundation Specification
java.specification.version: 1.0
--------- Derby Information --------
JRE - JDBC: J2ME - JDBC for CDC/FP 1.0
[C:\jartest\classes\derby.jar] 10.2.2.1 - (539674)
[C:\jartest\classes\derbytools.jar] 10.2.2.1 - (539674)
[C:\jartest\classes\derbynet.jar] 10.2.2.1 - (539674)
[C:\jartest\classes\derbyclient.jar] 10.2.2.1 - (539674)

• Bug behavior facts: Regression Test Failure
• Assignee: Myrna van Lunteren
• Reporter: Mike Matrigali
• Created: 22/May/07 22:21
• Updated: 21/Jan/11 17:50
• Resolved: 03/May/08 01:13

Description

Have seen this error a number of times, but not every run in this environment.

• • • • • • • • • Diff file derbyall/jdbcapi/SetQueryTimeoutTest.diff
    • Start: SetQueryTimeoutTest jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2007-05-22 04:28:51 ***
      7 del
      < Statement 1 completed
      8 del
      < Statement 2 completed
      9 del
      < Statement 3 completed
      10 del
      < Testing timeout with an execute operation
      11 del
      < Statements that should time out timed out, and statements that should complete completed
      12 del
      < Testing setting a negative timeout value
      13 del
      < Negative timeout value caused exception, as expected
      14 del
      < Execute returned a ResultSet
      15 del
      < Testing that Statement remembers timeout.
      16 del
      < Testing that PreparedStatement remembers timeout.
      17 del
      < Testing that CallableStatement remembers timeout.
      18 del
      < Testing timeout with executeUpdate call.
      19 del
      < Test SetQueryTimeoutTest PASSED
      19a7,11
      > Test SetQueryTimeoutTest FAILED
      > org.apache.derbyTesting.functionTests.tests.jdbcapi.SetQueryTimeoutTest$TestFailedException: Unexpected exception in 1: java.sql.SQLException: The statement has been cancelled or timed out.
      > ERROR XCL52: The statement has been cancelled or timed out.
      > java.sql.SQLException: Invalid transaction state.
      > java.sql.SQLException: Invalid transaction state.
      Test Failed.
    • End: SetQueryTimeoutTest jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2007-05-22 04:29:13 ***