As a galasa user, when I run a test using the Db2 manager I expect to get a Byte Array from db2 containing the result of my statement, so that I can interact with the database.
Issue?
When I run a test with the Db2 manager with all the properties supplied, I get an error when the manager tries to read the response from the database.
dev.galasa.boot.LauncherException: java.lang.NoClassDefFoundError: com.ibm.dataaccess.ByteArrayUnmarshaller
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.boot.felix.FelixFramework.runTest(FelixFramework.java:235)
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.boot.Launcher.launch(Launcher.java:176)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.boot.Launcher.main(Launcher.java:126)
2024/05/17 13:53:41 JVM output: (runid:L24) : Caused by:
2024/05/17 13:53:41 JVM output: (runid:L24) : java.lang.NoClassDefFoundError: com.ibm.dataaccess.ByteArrayUnmarshaller
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.a.j.f(j.java:17)
at com.ibm.db2.jcc.a.i.e(i.java:139)
at com.ibm.db2.jcc.a.i.b(i.java:74)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.y.q(y.java:1373)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.z.c(z.java:4792)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.z.b(z.java:4740)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.z.a(z.java:4726)
at com.ibm.db2.jcc.t4.ab.n(ab.java:909)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.ab.f(ab.java:156)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.p.e(p.java:81)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.av.k(av.java:175)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.k3.ao(k3.java:2413)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.k4.a(k4.java:4686)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.CallableStatement.b(CallableStatement.java:134)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.CallableStatement.a(CallableStatement.java:103)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.CallableStatement.execute(CallableStatement.java:93)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.Connection.callLicenseProcStaticV9(Connection.java:9525)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.Connection.isLicenseValidatedWithServerLicenseProc(Connection.java:9137)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.Connection.validatedByLicenseProc(Connection.java:5117)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.Connection.checkForLicenseRestrictions(Connection.java:5080)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.am.Connection.completeConnect(Connection.java:5026)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.b.completeConnect(b.java:653)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.b.a(b.java:455)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.b.a(b.java:414)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.t4.b.<init>(b.java:352)
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:233)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:200)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:471)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113)
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at dev.galasa.db2.internal.Db2InstanceImpl.<init>(Db2InstanceImpl.java:58)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.db2.internal.Db2ManagerImpl.generateDb2Instance(Db2ManagerImpl.java:120)
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.db2.internal.Db2ManagerImpl.provisionGenerate(Db2ManagerImpl.java:96)
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.framework.TestRunManagers.provisionGenerate(TestRunManagers.java:477)
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.framework.TestRunner.generateEnvironment(TestRunner.java:502)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.framework.TestRunner.runTest(TestRunner.java:424)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.base/java.lang.reflect.Method.invoke(Method.java:566)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at dev.galasa.boot.felix.FelixFramework.runTest(FelixFramework.java:233)
2024/05/17 13:53:41 JVM output: (runid:L24) : ... 2 more
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : Caused by:
2024/05/17 13:53:41 JVM output: (runid:L24) : java.lang.ClassNotFoundException: com.ibm.dataaccess.ByteArrayUnmarshaller not found by dev.galasa.db2.manager [22]
2024/05/17 13:53:41 JVM output: (runid:L24) : at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1585)
at org.apache.felix.framework.BundleWiringImpl.access$300(BundleWiringImpl.java:79)
at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1970)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:1075)
2024/05/17 13:53:41 JVM output: (runid:L24) :
2024/05/17 13:53:41 JVM output: (runid:L24) : ... 44 more
2024/05/17 13:53:41 JVM output: (runid:L24) : 17/05/2024 13:53:41.045 DEBUG dev.galasa.boot.felix.FelixFramework.stopFramework - Stopping Felix framework
2024/05/17 13:53:41 JVM output: (runid:L24) : 17/05/2024 13:53:41.051 INFO d.g.f.Framework - Framework service deactivated
2024/05/17 13:53:41 JVM output: (runid:L24) : 17/05/2024 13:53:41.063 DEBUG dev.galasa.boot.felix.FelixFramework.stopFramework - Felix framework stopped
2024/05/17 13:53:41 JVM output: (runid:L24) : 17/05/2024 13:53:41.116 ERROR dev.galasa.boot.Launcher.main - Exiting launcher due to exception
2024/05/17 13:53:41 JVM output: (runid:L24) : dev.galasa.boot.LauncherException: java.lang.NoClassDefFoundError: com.ibm.dataaccess.ByteArrayUnmarshaller
Steps to reproduce
Using a running Db2 instance and the respective db2 manager cps properties run the a test against the db2 instance:
galasactl runs submit local --log - --obr mvn:dev.galasa/dev.galasa.uber.obr/0.34.0/obr --class dev.galasa.db2.manager.ivt/dev.galasa.db2.manager.ivt.Db2ManagerIVT
As a galasa user, when I run a test using the Db2 manager I expect to get a Byte Array from db2 containing the result of my statement, so that I can interact with the database.
Issue?
When I run a test with the Db2 manager with all the properties supplied, I get an error when the manager tries to read the response from the database.
Steps to reproduce
Using a running Db2 instance and the respective db2 manager cps properties run the a test against the db2 instance: