[TOMEE-2604] Derby TCK setup not finding StoredProc

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Jean-Louis Monteiro
• Reporter: Jean-Louis Monteiro
• Created: 31/Jul/19 19:31
• Updated: 22/Aug/19 20:25
• Resolved: 22/Aug/19 20:25

Description

When running jakarta EE 8 TCK, there is a ClassNotFoundException happening because the stored procs can't be found.

 

To reproduce, you can run this `./runtests --web tomee-plus com.sun.ts.tests.jdbc.ee.callStmt.callStmt1.callStmtClient1`

 

You should see in javatest.log

 

07-30-2019 17:54:03: ERROR: java.sql.SQLSyntaxErrorException: The class 'com.sun.ts.lib.tests.jdbc.CS_Procs' does not exist or is inaccessible. This can happen if the class is not public.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareCall(Unknown Source)
at com.sun.ts.tests.jdbc.ee.callStmt.callStmt1.callStmtClient1.testGetBigDecimal01(callStmtClient1.java:135)
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.ServiceEETest.run(ServiceEETest.java:115)
at com.sun.ts.tests.common.vehicle.EmptyVehicleRunner.run(EmptyVehicleRunner.java:40)
at com.sun.ts.lib.harness.ServiceEETest.run(ServiceEETest.java:105)
at com.sun.ts.lib.harness.EETest.getPropsReady(EETest.java:486)
at com.sun.ts.lib.harness.ServiceEETest.run(ServiceEETest.java:209)
at com.sun.ts.lib.harness.EETest.run(EETest.java:285)
at com.sun.ts.tests.common.vehicle.VehicleClient.main(VehicleClient.java:38)
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 org.apache.openejb.client.Main.invoke(Main.java:132)
at org.apache.openejb.client.Main.main(Main.java:100)
Caused by: org.apache.derby.client.am.SqlException: The class 'com.sun.ts.lib.tests.jdbc.CS_Procs' does not exist or is inaccessible. This can happen if the class is not public.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepare_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepare(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareCallX(Unknown Source)
... 20 more
Caused by: org.apache.derby.client.am.SqlException: Java exception: 'com.sun.ts.lib.tests.jdbc.CS_Procs: java.lang.ClassNotFoundException'.
... 31 more