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 220.127.116.11 to 18.104.22.168. Our application worked with 22.214.171.124 but when we upgrade to 126.96.36.199 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 188.8.131.52.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Oracle JDBC driver: 184.108.40.206.0(ojdbc8.jar)