java.sql.SQLException: Invalid column type: 2012 when using Hibernate and Oracle stored procedure with REF_CURSOR

Description

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.

Environment

hibernate-core-5.2.12.jar, hibernate-jpa-2.1-api.jar, java 8,
Database
==============
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

JDBC
==============
Oracle JDBC driver: 12.2.0.1.0(ojdbc8.jar)

Status

Assignee

Unassigned

Reporter

Archana

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.2.12

Priority

Critical
Configure