![[Jenkins]](/jakartaee-tck/static/298584b0/images/svgs/logo.svg){kind=logo}
Regression
com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.positiveTxQueryCommitTest (from tags-tck)
Error Message
test result: Failed. Test case throws exception: [BaseUrlClient] positiveTxQueryCommitTest failed! Check output for cause of failure.
Stacktrace
test result: Failed. Test case throws exception: [BaseUrlClient] positiveTxQueryCommitTest failed! Check output for cause of failure.
Standard Output
#Test Results (version 2)
#Tue Aug 18 13:20:24 UTC 2020
#-----testdescription-----
$file=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/src/com/sun/ts/tests/jstl/spec/sql/transaction/JSTLClient.java
$root=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/src
assertion_ids=JSTL\:SPEC\:61 The < sql\:transaction> action establishes a\n\t\t\t\ttransaction context for its < sql\:query> and < sql\:update>\n\t\t\t\tsubtags.\nJSTL\:SPEC\:61.1 The 'dataSource' attribute specifies the DataSource\n\t\t\t\t\t\tassociated with the database to query.\nJSTL\:SPEC\:61.1.1 The result of the evaluated expression can be of\n\t\t\t\t\t\t\t\ttype String.\nJSTL\:SPEC\:61.2 The 'isolation' attribute specifies the transaciton\n\t\t\t\t\t\tisolation level.\nJSTL\:SPEC\:61.2.1 The result of the evaluated expression must be of\n\t\t\t\t\t\t\t\ttype String.\nJSTL\:SPEC\:61.2.2 A value of 'read_committed' sets the transaction\n\t\t\t\t\t\t\t\tisolation level to TRANSACTION_READ_COMMITTED.\nJSTL\:SPEC\:61.2.3 A value of 'read_uncommitted' sets the transaction\n\t\t\t\t\t\t\t\tisolation level to TRANSACTION_READ_UNCOMMITTED.\nJSTL\:SPEC\:61.2.4 A value of 'repeatable_read' sets the transaction\n\t\t\t\t\t\t\t\tisolation level to TRANSACTION_REPEATABLE_READ.\nJSTL\:SPEC\:61.2.5 A value of 'serializable' sets the transaction\n\t\t\t\t\t\t\t\tisolation level to TRANSACTION_SERIALIZABLE.\nJSTL\:SPEC\:61.2.6 If the evaluated expression is not of type String,\n\t\t\t\t\t\t\t\tan Exception is thrown.\nJSTL\:SPEC\:61.2.7 If the isolation level is not specified, it is the\n\t\t\t\t\t\t\t\tisolation level the DataSource has been configured with.\nJSTL\:SPEC\:61.3 Any nested < sql\:query> and < sql\:update> actions\n\t\t\t\t\t\tmust not specify a 'dataSource' attribute.\nJSTL\:SPEC\:61.4 If 'dataSource' is null, a JspException is thrown.\nJSTL\:SPEC\:61.5 The tag handler of the < sql\:transaction> action\n\t\t\t\t\t\tmust perform the following steps in it's lifecycle methods\:\nJSTL\:SPEC\:61.5.1 doStartTag()\:\nJSTL\:SPEC\:61.5.1.1 Determine the transaction isolation level of the\n\t\t\t\t\t\t\t\t\t\tDBMS (using the Connection method getTransactionIsolation()).\nJSTL\:SPEC\:61.5.1.1.1 If transactions are not supported, an exception\n\t\t\t\t\t\t\t\t\t\t\t\tis raised causing the transaction to fail.\nJSTL\:SPEC\:61.5.1.1.2 For any other transaction isolation level, the\n\t\t\t\t\t\t\t\t\t\t\t\tauto-commit mode is disabled by calling setAutoCommit(false) \n\t\t\t\t\t\t\t\t\t\t\t\ton the connection.\nJSTL\:SPEC\:61.5.1.2 If the 'isolation' attribute is specified, the\n\t\t\t\t\t\t\t\t\t\tcurrent transaction isolation level is save and set to the \n\t\t\t\t\t\t\t\t\t\tspecified level (using the Connection method\n\t\t\t\t\t\t\t\t\t\tsetTransactionIsolation()).\nJSTL\:SPEC\:61.5.2 doEndTag()\:\nJSTL\:SPEC\:61.5.2.1 Calls the cConnection method commit().\nJSTL\:SPEC\:61.5.3 doCatch()\:\nJSTL\:SPEC\:61.5.3.1 Calls the Connection method rollback().\nJSTL\:SPEC\:61.5.4 doFinally()\:\nJSTL\:SPEC\:61.5.4.1 If a transaction isolation level has been saved,\n\t\t\t\t\t\t\t\t\t\tit is restored using the Connection meghod \n\t\t\t\t\t\t\t\t\t\tsetTransactionIsolation().\nJSTL\:SPEC\:61.5.4.2 Enables auto-commit mode by calling\n\t\t\t\t\t\t\t\t\t\tsetAutoCommit(true) on the Connection.\nJSTL\:SPEC\:61.5.4.3 Closes the connection.\nJSTL\:SPEC\:61.6 Any exception occurring during the execution of this\n\t\t\t\t\t\taction must be caught and rethrown after the transaction has been \n\t\t\t\t\t\trolled back.\nJSTL\:SPEC\:61.7 A connection is obtained by the action using the\n\t\t\t\t\t\tfollowing algorithm\:\nJSTL\:SPEC\:61.7.1 If the 'dataSource' attribute is given, the\n\t\t\t\t\t\t\t\tConnection object is obtained through getConnection() on the \n\t\t\t\t\t\t\t\tspecified DataSource and release before the end of the tag.\nJSTL\:SPEC\:61.7.1.1 If 'dataSource' resolves to a String, it is\n\t\t\t\t\t\t\t\t\t\tinterpreted as a JNDI path to a DataSource resource.\nJSTL\:SPEC\:61.7.2 If the 'dataSource' attribute is missing, the\n\t\t\t\t\t\t\t\tDataSource from which to obtain the Connection is retrieved from \n\t\t\t\t\t\t\t\tthe 'javax.servlet.jsp.jstl.sql.dataSource scoped variable.\nJSTL\:SPEC\:61.7.2.1 The Connection object is obtained through\n\t\t\t\t\t\t\t\t\t\tgetConnection() on the specified DataSource and released \n\t\t\t\t\t\t\t\t\t\tbefore the tag completes.\nJSTL\:SPEC\:61.8 If an exception is caused by the body content, it must\n\t\t\t\t\t\tbe propagated.\nJSTL\:SPEC\:61.9 If an exception is caused by the action, it must be\n\t\t\t\t\t\tpropagated.
classname=com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient
direction=forward
finder=cts
id=positiveTxQueryCommitTest
keywords=all jstl javaee javaee_web_profile positiveTxQueryCommitTest novehicle forward
service_eetest=no
testName=positiveTxQueryCommitTest
testProps=\ webServerHost webServerPort ts_home jstl.db.url jstl.db.user jstl.db.password jstl.db.driver
test_directory=com/sun/ts/tests/jstl/spec/sql/transaction
#-----environment-----
JAVA_HOME=/opt/jdk1.8.0_191/jre
JAVA_OPTIONS=
LOCAL_CLASSES=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/tsharness.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/jstltck.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/javatest.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../classes\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp.jstl.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp.jstl-api.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet-api.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp-api.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.el.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.el-api.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/../javadb/lib/derbyclient.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/commons-httpclient-3.1.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/commons-codec-1.9.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/commons-logging-1.1.3.jar\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/sigtest.jar
SYSTEMROOT=${env.SystemRoot}
TS_HOME=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../..
command.testExecute=com.sun.ts.lib.harness.ExecTSTestCmd CLASSPATH\=${JAVA_HOME}/lib/rt.jar${pathsep}${LOCAL_CLASSES} HOME\="${user.home}" windir\=${windir} SYSTEMROOT\=${SYSTEMROOT} ${JAVA_HOME}/bin/java ${JAVA_OPTIONS} $testExecuteClass $testExecuteArgs
harness.executeMode=2
harness.log.delayseconds=1
harness.log.port=2000
harness.log.traceflag=true
harness.socket.retry.count=10
harness.temp.directory=${ts.home}/tmp
jstl.db.driver=org.apache.derby.jdbc.ClientDriver
jstl.db.name=derbyDB
jstl.db.password=cts1
jstl.db.port=1527
jstl.db.server=localhost
jstl.db.url=jdbc\:derby\://${jstl.db.server}\:${jstl.db.port}/${jstl.db.name};create\=true
jstl.db.user=cts1
pathsep=\:
porting.ts.url.class.1=com.sun.ts.lib.implementation.sun.common.SunRIURL
ts.home=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../..
ts_home=${TS_HOME}
user.home=?
webServerHost=localhost
webServerPort=8080
windir=${env.windir}
#-----testresult-----
description=file\:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/src/com/sun/ts/tests/jstl/spec/sql/transaction/JSTLClient.java\#positiveTxQueryCommitTest
end=Tue Aug 18 13\:20\:24 UTC 2020
environment=ts_unix
execStatus=Failed. Test case throws exception\: [BaseUrlClient] positiveTxQueryCommitTest failed\! Check output for cause of failure.
harnessLoaderMode=Classpath Loader
harnessVariety=Full Bundle
javatestOS=Linux 3.10.0-1062.12.1.el7.x86_64 (amd64)
javatestVersion=5.0
script=com.sun.ts.lib.harness.TSScript
sections=script_messages TestRun
start=Tue Aug 18 13\:20\:23 UTC 2020
test=com/sun/ts/tests/jstl/spec/sql/transaction/JSTLClient.java\#positiveTxQueryCommitTest
timeoutSeconds=600
totalTime=1500
work=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tckwork/tags-tck/com/sun/ts/tests/jstl/spec/sql/transaction
#section:script_messages
----------messages:(0/0)----------
#section:TestRun
----------messages:(1/1911)----------
command: com.sun.ts.lib.harness.ExecTSTestCmd CLASSPATH=:/opt/jdk1.8.0_191/jre/lib/rt.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/tsharness.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/jstltck.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/javatest.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../classes:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp.jstl.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp.jstl-api.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet-api.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.servlet.jsp-api.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.el.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/modules/jakarta.el-api.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/glassfish6/glassfish/../javadb/lib/derbyclient.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/commons-httpclient-3.1.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/commons-codec-1.9.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/commons-logging-1.1.3.jar:/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../lib/sigtest.jar HOME=? windir= SYSTEMROOT= /opt/jdk1.8.0_191/jre/bin/java com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient -p /home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../tmp/tstest.jte -t positiveTxQueryCommitTest
----------log:(96/6907)----------
************************************************************
* props file set to "/tmp/?-cts-props.txt"
************************************************************
08-18-2020 13:20:23: TRACE: ####### Value of harness.socket.retry.count is "10"
08-18-2020 13:20:23: TRACE: ####### Value of harness.log.port is "2000"
08-18-2020 13:20:23: TRACE: ####### Actual bind value of harness.log.port is "2000"
08-18-2020 13:20:23: TRACE: *** in EETest.run(argv,p)
08-18-2020 13:20:23: TRACE: TESTCLASS=com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient
08-18-2020 13:20:23: TRACE: ** IN getRunMethod: testClass=com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient
08-18-2020 13:20:23: TRACE: ** IN getRunMethod: testname=positiveTxQueryCommitTest
08-18-2020 13:20:23: TRACE: ** GOT RUN METHOD!
08-18-2020 13:20:23: TRACE: **runmethod=positiveTxQueryCommitTest
08-18-2020 13:20:23: TRACE: ABOUT TO GET SETUP METHOD!
08-18-2020 13:20:23: TRACE: No setupMethod annotation present
08-18-2020 13:20:23: TRACE: getSetupMethod - checking for testcase specific setup method: positiveTxQueryCommitTest_setup
08-18-2020 13:20:23: TRACE: getSetupMethod - checking for default class specific setup method
08-18-2020 13:20:23: TRACE: GOT SETUP METHOD!
08-18-2020 13:20:23: TRACE: No cleanupMethod annotation present
08-18-2020 13:20:23: TRACE: getCleanupMethod - checking for testcase specific cleanup method: positiveTxQueryCommitTest_cleanup
08-18-2020 13:20:23: TRACE: getCleanupMethod - checking for default class specific cleanup method
08-18-2020 13:20:23: TRACE: GOT CLEANUP METHOD!
08-18-2020 13:20:23: TRACE: ABOUT TO INVOKE SETUP METHOD!
08-18-2020 13:20:23: [BaseUrlClient] Test setup OK
08-18-2020 13:20:23: TRACE: INVOKED SETUP METHOD!
08-18-2020 13:20:23: TRACE: ABOUT TO INVOKE EETEST RUN METHOD!
08-18-2020 13:20:23: TRACE: [HttpRequest] Added request header: jstl.db.user: cts1
08-18-2020 13:20:23: TRACE: [HttpRequest] Added request header: jstl.db.driver: org.apache.derby.jdbc.ClientDriver
08-18-2020 13:20:23: TRACE: [HttpRequest] Added request header: jstl.db.password: cts1
08-18-2020 13:20:23: TRACE: [HttpRequest] Added request header: jstl.db.url: jdbc:derby://localhost:1527/derbyDB;create=true
08-18-2020 13:20:23: TRACE: [BaseUrlClient] EXECUTING
08-18-2020 13:20:23: ERROR: Root cause of Failure: Connection refused (Connection refused)
08-18-2020 13:20:23: ERROR: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:286)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at com.sun.ts.tests.common.webclient.http.HttpRequest.execute(HttpRequest.java:409)
at com.sun.ts.tests.common.webclient.WebTestCase.execute(WebTestCase.java:171)
at com.sun.ts.tests.common.webclient.BaseUrlClient.invoke(BaseUrlClient.java:455)
at com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.positiveTxQueryCommitTest(JSTLClient.java:157)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.ts.lib.harness.EETest.run(EETest.java:596)
at com.sun.ts.lib.harness.EETest.getPropsReady(EETest.java:486)
at com.sun.ts.lib.harness.EETest.run(EETest.java:337)
at com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.run(JSTLClient.java:66)
at com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.main(JSTLClient.java:51)
08-18-2020 13:20:23: ERROR: Test case throws exception: [BaseUrlClient] positiveTxQueryCommitTest failed! Check output for cause of failure.
08-18-2020 13:20:23: ERROR: Exception at:
08-18-2020 13:20:23: ERROR: com.sun.ts.tests.common.webclient.TestFailureException: [FATAL] Unexpected failure during test execution.Connection refused (Connection refused)
at com.sun.ts.tests.common.webclient.WebTestCase.execute(WebTestCase.java:175)
at com.sun.ts.tests.common.webclient.BaseUrlClient.invoke(BaseUrlClient.java:455)
at com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.positiveTxQueryCommitTest(JSTLClient.java:157)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.ts.lib.harness.EETest.run(EETest.java:596)
at com.sun.ts.lib.harness.EETest.getPropsReady(EETest.java:486)
at com.sun.ts.lib.harness.EETest.run(EETest.java:337)
at com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.run(JSTLClient.java:66)
at com.sun.ts.tests.jstl.spec.sql.transaction.JSTLClient.main(JSTLClient.java:51)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:286)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at com.sun.ts.tests.common.webclient.http.HttpRequest.execute(HttpRequest.java:409)
at com.sun.ts.tests.common.webclient.WebTestCase.execute(WebTestCase.java:171)
... 11 more
08-18-2020 13:20:23: [BaseUrlClient] Test cleanup OK
STATUS:Failed.Test case throws exception: [BaseUrlClient] positiveTxQueryCommitTest failed! Check output for cause of failure.
result: Failed. Test case throws exception: [BaseUrlClient] positiveTxQueryCommitTest failed! Check output for cause of failure.
test result: Failed. Test case throws exception: [BaseUrlClient] positiveTxQueryCommitTest failed! Check output for cause of failure.