utplsql run throws Unknown exception

[maxbernhardt]

When trying to run tests under RHEL 5.11 we receive the following error

ccuser@adeagibx:~/utPLSQL-cli/utPLSQL-cli/bin$ ./utplsql run /@host:port:DB -d
2019-08-05 17:20:51 [main] INFO org.utplsql.cli.RunAction - utPLSQL cli
utPLSQL-cli 3.1.7-SNAPSHOT.local
utPLSQL-java-api 3.1.7.504
Java-Version: 1.8.0_192
ORACLE_HOME: /opt/oracle/product/111_cl_64/cl
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1

Thanks for testing!
2019-08-05 17:20:51 [main] INFO org.utplsql.cli.RunAction -
2019-08-05 17:20:51 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';
EXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';
END;
2019-08-05 17:20:55 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:thin:/@host:port:DB
2019-08-05 17:20:56 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.0.4.1372
2019-08-05 17:20:56 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 11.2.0.4.0
2019-08-05 17:20:58 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_DOCUMENTATION_REPORTER, ID: 8F5D61CE2F2B69AEE0537B55E9C3F666
2019-08-05 17:20:58 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now.
2019-08-05 17:20:58 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - --------------------------------------
2019-08-05 17:20:58 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized
2019-08-05 17:20:58 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.0.4.1372
2019-08-05 17:20:58 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters
Unknown exception, wrapping: oracle.jdbc.OracleConnection.createOracleArray(Ljava/lang/String;Ljava/lang/Object;)Ljava/sql/Array;

[pesse]

Thank you for reporting.
Can you tell me which version of ojdbc you are using?
Also: you seem to use a pretty old version of utPLSQL - any chance you can give a newer version a try?

[maxbernhardt]

Thank you for the response and sorry for the delay !

We're using ojdbc6.jar, this is the newest ojdbc jar-file included in the 11.2 client we have installed.

Once I find the time, We'll upgrade to the latest version of utPLSQL and try again. I'll report the results here.

[pesse]

@maxbernhardt could you possibly try a newer thin driver like ojdbc8? They should be downwards-compatible.
It's downloadable from the oracle website https://www.oracle.com/database/technologies/appdev/jdbc-ucp-183-downloads.html

[maxbernhardt]

I'll try and get back to you tomorrow

[maxbernhardt]

@pesse: The update of the ojdbc driver package worked fine. Thanks for hint. From my POV the issue can be closed, maybe with a hint in usage to use the ojdbc later than ojdbc6 ?

[pesse]

Yes, will do so. Thanks for checking!