we are using hibenrate and hibernate jpa to call stored procedures. we are using weblogic application server and Oracle database.
we would like to upgrade weblogic from 126.96.36.199 to 188.8.131.52. Our application worked with 184.108.40.206 but when we upgrade to 220.127.116.11 our application gives "invalid sql type 2012" error when we call stored procedure.
above post at the bottom says 'The StandardRefCursorSupport decides whether to use the JDBC 4.2 REF_CURSOR or the DB-specific one based on:
I see that when we debug our code above method call returns true with jdbc8 and we are using the correct jdbc driver but it still does not work.
I see from above posting that hibernate tested their code with jdbc7.jar.
Can you please test the storeprocedurecall code with jdbc8.jar and see if it works. Please provide us suggestion on how we can fix this issue in our environment.
hibernate-core-5.2.12.jar, hibernate-jpa-2.1-api.jar, java 8,
Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Oracle JDBC driver: 22.214.171.124.0(ojdbc8.jar)
also the same problem here
oracle database 126.96.36.199.0
weblogic 188.8.131.52.0 - everything working fine
weblogic 184.108.40.206, with driver ojdbc8.jar, not working
JdbcEnvironmentInitiator - retrieving DatabaseMetaData - in the first case jdbcServices.getExtractedMetaDataSupport().supportsRefCursors() returns false, so Oracle10gDialect.registerResultSetOutParameter is applied (-10 int value)
second case returns true (2012 int value is applied)