Oracle 19c warnings with JDBC driver and AQ client on Java 17
Oracle Products:
Database: 19.18
Problem:
Overview:
Our application has Oracle queues in 19c and we are in the process of migrating to Springboot 3 and Java 17 LTS version. We are getting warnings in our database logs that seem to be caused by the following statements:
1) BEGIN :1 := sys.dbms_aqjms.getDBCompatMajorVersion; :2 := sys.dbms_aqjms.getDBCompatMinorVersion; END;
and
2) BEGIN :1 := sys.dbms_aqjms.getMaxIdentifierLength; END;
These statements are not being issued by our code but instead by libraries that we are using.
These libraries are:
Oracle AQ: com.oracle.database.messaging:aqapi-jakarta:23.2.1.0 JDBC
JDBC driver: com.oracle.database.jdbc:ojdbc11:21.9.0.0
Our Java software is running on Java version 17 against an Oracle 19c Database.