![[Jenkins]](/jakartaee-tck/static/298584b0/images/svgs/logo.svg){kind=logo}
Regression
com.sun.ts.tests.jstl.spec.sql.param.JSTLClient.negativeParamQuerySQLAttributeTest (from tags-tck)
Error Message
test result: Failed. Test case throws exception: [BaseUrlClient] negativeParamQuerySQLAttributeTest failed! Check output for cause of failure.
Stacktrace
test result: Failed. Test case throws exception: [BaseUrlClient] negativeParamQuerySQLAttributeTest failed! Check output for cause of failure.
Standard Output
#Test Results (version 2)
#Tue Aug 18 13:18:12 UTC 2020
#-----testdescription-----
$file=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/src/com/sun/ts/tests/jstl/spec/sql/param/JSTLClient.java
$root=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/src
assertion_ids=JSTL\:SPEC\:94 < sql\:dateParam> Sets the values of parameter markers\n\t\t\t\t(“?”) in a SQL statement for values of type java.util.Date. Subtag \n\t\t\t\tof SQLExecutionTag actions, such as < sql\:query> and\n\t\t\t\t < sql\:update>.\nJSTL\:SPEC\:94.1 The 'value' attribute represents a parameter value for\n\t\t\t\t\t\tDATE, TIME, or TIMESTAMP column in a database table.\nJSTL\:SPEC\:94.1.1 The 'value' attribute is required.\nJSTL\:SPEC\:94.1.2 The result of the evaluated expression must be of\n\t\t\t\t\t\t\t\ttype java.util.Date.\nJSTL\:SPEC\:94.1.3 If the evaluated expression is not of type\n\t\t\t\t\t\t\t\tjava.util.Date, an Exception is thrown.\nJSTL\:SPEC\:94.1.4 If value is null, the parameter is set to the SQL\n\t\t\t\t\t\t\t\tvalue NULL\nJSTL\:SPEC\:94.2 The 'type' attribute represents one of "date", "time"\n\t\t\t\t\t\tor "timestamp".\nJSTL\:SPEC\:94.2.1 The result of the evaluated expression must be of\n\t\t\t\t\t\t\t\ttype String.\nJSTL\:SPEC\:94.2.2 If the evaluated expression is not of type String,\n\t\t\t\t\t\t\t\tan Exception is thrown.\nJSTL\:SPEC\:94.3 The body content must be empty.\nJSTL\:SPEC\:94.4 The < sql\:dateParam> tags must be nested inside an\n\t\t\t\t\t\taction whose tag handler is an instance of SQLExecu tionTag.\nJSTL\:SPEC\:94.5 < sql\:dateParam> converts the provided\n\t\t\t\t\t\tjava.util.Date instance to one of java.sql.Date, java.sql.Time or \n\t\t\t\t\t\tjava.sql.Timestamp as defined by the type attribute as follows\:\nJSTL\:SPEC\:94.5.1 If the java.util.Date object provided by the value\n\t\t\t\t\t\t\t\tattribute is an instance of java.sql.Time, java.sql.Date, or \n\t\t\t\t\t\t\t\tjava.sql.Timestamp, and the type attribute matches this object's\n\t\t\t\t\t\t\t\ttype, then it is passed as is to the database.\nJSTL\:SPEC\:94.5.2 Otherwise, the object is converted to the\n\t\t\t\t\t\t\t\tappropriate type by calling that type's constructor with a \n\t\t\t\t\t\t\t\tparameter of date.getTime(), where date is the value of the\n\t\t\t\t\t\t\t\tvalue attribute.\nJSTL\:SPEC\:94.6 The < sql\:dateParam> action substitutes the given\n\t\t\t\t\t\t\t\tparameter value for a parameter marker(“?”) in the SQL statement \n\t\t\t\t\t\t\t\tof its enclosing SQLExecutionTag action.\nJSTL\:SPEC\:94.6.1 Parameters are substituted in the order in which\n\t\t\t\t\t\t\t\t\t\tthey are specified.\nJSTL\:SPEC\:94.6.2 The < sql\:dateParam> action locates its nearest\n\t\t\t\t\t\t\t\t\t\tancestor that is an instance of SQLExecutionTag and calls its \n\t\t\t\t\t\t\t\t\t\taddSQLParameter() method, supplying it with the given\n\t\t\t\t\t\t\t\t\t\tparameter value.
classname=com.sun.ts.tests.jstl.spec.sql.param.JSTLClient
direction=forward
finder=cts
id=negativeParamQuerySQLAttributeTest
keywords=all jstl javaee javaee_web_profile negativeParamQuerySQLAttributeTest novehicle forward
service_eetest=no
testName=negativeParamQuerySQLAttributeTest
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/param
#-----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/param/JSTLClient.java\#negativeParamQuerySQLAttributeTest
end=Tue Aug 18 13\:18\:12 UTC 2020
environment=ts_unix
execStatus=Failed. Test case throws exception\: [BaseUrlClient] negativeParamQuerySQLAttributeTest 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\:18\:10 UTC 2020
test=com/sun/ts/tests/jstl/spec/sql/param/JSTLClient.java\#negativeParamQuerySQLAttributeTest
timeoutSeconds=600
totalTime=1513
work=/home/jenkins/agent/workspace/jakartaee-tck_master/tags-tckwork/tags-tck/com/sun/ts/tests/jstl/spec/sql/param
#section:script_messages
----------messages:(0/0)----------
#section:TestRun
----------messages:(1/1914)----------
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.param.JSTLClient -p /home/jenkins/agent/workspace/jakartaee-tck_master/tags-tck/bin/xml/../../tmp/tstest.jte -t negativeParamQuerySQLAttributeTest
----------log:(96/6931)----------
************************************************************
* props file set to "/tmp/?-cts-props.txt"
************************************************************
08-18-2020 13:18:10: TRACE: ####### Value of harness.socket.retry.count is "10"
08-18-2020 13:18:10: TRACE: ####### Value of harness.log.port is "2000"
08-18-2020 13:18:10: TRACE: ####### Actual bind value of harness.log.port is "2000"
08-18-2020 13:18:10: TRACE: *** in EETest.run(argv,p)
08-18-2020 13:18:10: TRACE: TESTCLASS=com.sun.ts.tests.jstl.spec.sql.param.JSTLClient
08-18-2020 13:18:10: TRACE: ** IN getRunMethod: testClass=com.sun.ts.tests.jstl.spec.sql.param.JSTLClient
08-18-2020 13:18:10: TRACE: ** IN getRunMethod: testname=negativeParamQuerySQLAttributeTest
08-18-2020 13:18:10: TRACE: ** GOT RUN METHOD!
08-18-2020 13:18:10: TRACE: **runmethod=negativeParamQuerySQLAttributeTest
08-18-2020 13:18:10: TRACE: ABOUT TO GET SETUP METHOD!
08-18-2020 13:18:10: TRACE: No setupMethod annotation present
08-18-2020 13:18:10: TRACE: getSetupMethod - checking for testcase specific setup method: negativeParamQuerySQLAttributeTest_setup
08-18-2020 13:18:10: TRACE: getSetupMethod - checking for default class specific setup method
08-18-2020 13:18:10: TRACE: GOT SETUP METHOD!
08-18-2020 13:18:10: TRACE: No cleanupMethod annotation present
08-18-2020 13:18:10: TRACE: getCleanupMethod - checking for testcase specific cleanup method: negativeParamQuerySQLAttributeTest_cleanup
08-18-2020 13:18:10: TRACE: getCleanupMethod - checking for default class specific cleanup method
08-18-2020 13:18:10: TRACE: GOT CLEANUP METHOD!
08-18-2020 13:18:10: TRACE: ABOUT TO INVOKE SETUP METHOD!
08-18-2020 13:18:10: [BaseUrlClient] Test setup OK
08-18-2020 13:18:10: TRACE: INVOKED SETUP METHOD!
08-18-2020 13:18:10: TRACE: ABOUT TO INVOKE EETEST RUN METHOD!
08-18-2020 13:18:10: TRACE: [HttpRequest] Added request header: jstl.db.user: cts1
08-18-2020 13:18:10: TRACE: [HttpRequest] Added request header: jstl.db.driver: org.apache.derby.jdbc.ClientDriver
08-18-2020 13:18:10: TRACE: [HttpRequest] Added request header: jstl.db.password: cts1
08-18-2020 13:18:10: TRACE: [HttpRequest] Added request header: jstl.db.url: jdbc:derby://localhost:1527/derbyDB;create=true
08-18-2020 13:18:10: TRACE: [BaseUrlClient] EXECUTING
08-18-2020 13:18:10: ERROR: Root cause of Failure: Connection refused (Connection refused)
08-18-2020 13:18:10: 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.param.JSTLClient.negativeParamQuerySQLAttributeTest(JSTLClient.java:339)
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.param.JSTLClient.run(JSTLClient.java:66)
at com.sun.ts.tests.jstl.spec.sql.param.JSTLClient.main(JSTLClient.java:51)
08-18-2020 13:18:10: ERROR: Test case throws exception: [BaseUrlClient] negativeParamQuerySQLAttributeTest failed! Check output for cause of failure.
08-18-2020 13:18:10: ERROR: Exception at:
08-18-2020 13:18:10: 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.param.JSTLClient.negativeParamQuerySQLAttributeTest(JSTLClient.java:339)
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.param.JSTLClient.run(JSTLClient.java:66)
at com.sun.ts.tests.jstl.spec.sql.param.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:18:10: [BaseUrlClient] Test cleanup OK
STATUS:Failed.Test case throws exception: [BaseUrlClient] negativeParamQuerySQLAttributeTest failed! Check output for cause of failure.
result: Failed. Test case throws exception: [BaseUrlClient] negativeParamQuerySQLAttributeTest failed! Check output for cause of failure.
test result: Failed. Test case throws exception: [BaseUrlClient] negativeParamQuerySQLAttributeTest failed! Check output for cause of failure.