| 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 12.2.1.2 to 12.2.1.3. Our application worked with 12.2.1.2 but when we upgrade to 12.2.1.3 our application gives "invalid sql type 2012" error when we call stored procedure. https://discourse.hibernate.org/t/java-sql-sqlexception-invalid-column-type-2012-when-using-hibernate-and-oracle-stored-procedure-with-ref-cursor/129/1 has similar issue . 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: jdbcServices.getExtractedMetaDataSupport().supportsRefCursors()
'
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. |
