Original Message:
Sent: Mon February 26, 2024 10:14 AM
From: NIGEL CAMPBELL
Subject: COGNOS ANALYTICS 12.0.2 x Oracle Data Server Connection
The second two errors are expected given the ORACLE classes are compiled such that a new JRE is required.
CA is using JRE 8 and you would be using using IBM JRE or perhaps ORACLE JRE.
That said, when you say 'does not connect' you did not provide any details.
Suggest you open a support call if you have a support account.
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Mon February 26, 2024 10:05 AM
From: Sptrading Brazil
Subject: COGNOS ANALYTICS 12.0.2 x Oracle Data Server Connection
Thank you NIGEL ... but it seams does not work.
When using ojdbc8 for Oracle Database 19c (19.22.0.0) - it Implements JDBC 4.2 spec and certified with JDK8, JDK11, JDK17, and JDK19. It does not connect.
When using ojdbc10 for Oracle Database 19c (19.22.0.0)- it implements JDBC 4.3 spec and certified with JDK11 and JDK17. XQE-GEN-0002 An unexpected exception occurred: JVMCFRE199E bad major version 55.0 of class=oracle/jdbc/OracleDriver, the maximum supported major version is 52.0; offset=6
When using ojdbc11 for Oracle Database 23c (23.3.0.23.09) - it implements JDBC 4.3 spec and certified with JDK11, JDK17, JDK19, and JDK21. XQE-GEN-0002 An unexpected exception occurred: JVMCFRE199E bad major version 55.0 of class=oracle/jdbc/OracleDriver, the maximum supported major version is 52.0; offset=6
CA is using:
Any thoughts ?
------------------------------
Sptrading Brazil
Original Message:
Sent: Mon February 26, 2024 07:07 AM
From: NIGEL CAMPBELL
Subject: COGNOS ANALYTICS 12.0.2 x Oracle Data Server Connection
You have put a copy of a JAR file into <cognos>\drivers compiled for a higher Java version such as Java 11, 17 etc..
See ojdbc8.
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Fri February 23, 2024 04:07 PM
From: Sptrading Brazil
Subject: COGNOS ANALYTICS 12.0.2 x Oracle Data Server Connection
Hello...
Currently moving from CA11.2.2 to CA12.0.2.
Everything works fine EXCEPT connection to Oracle Data Source (that BTW it works fine on CA11.2.2)
XQE-GEN-0002 An unexpected exception occurred: JVMCFRE199E bad major version 55.0 of class=oracle/jdbc/OracleDriver, the maximum supported major version is 52.0; offset=6
We are using the same drivers as CA11.2.2.
We tried using bundled CA12.0.2 JRE and also 8.0-8.20 IBM JRE.
Any thoughts.
Thank you ...
------------------------------
Sptrading Brazil
------------------------------