OracleDialect with oracle 11g

Description

We are calling sql procedures using Hiberante and I have used OracleDialect9 as my hiberante dialect.

These configuration is working fine in weblogic 8.1 but it's failing in weblogic 10.3 with exception "Caused by: java.lang.IllegalAccessException: Class org.hibernate.dialect.Oracle9Dialect can not access a member of class oracle.jdbc.driver.OracleTypes with modifiers ""
" .

I went through the dialect code and found that here is one line "Class types = ReflectHelper.classForName("oracle.jdbc.driver.OracleTypes");" to load OracleTypes where in oracle 11g they have depricated oracle.jdbc.driver package. Now since weblogic 10.3 internally comes with oracle 11g thin driver, hibernate is not able to find OracleTypes class.

So what do u think what i should do to make this work ? Is there any dialect available which can support oracle 11g and solve this problem ? So should i created my own dialect and handle this issue ?

Environment

Oracle 10.2, weblogic 10.3 , java 1.6 , spring 2.0

Activity

Show:
Richard Marriott
March 18, 2010, 12:05 PM

As far as I can tell, the problem is still there with hibernate 3.3.2.GA:

As far as I can tell this is still a problem. I am using Hibernate 3.3.2.GA with WebLogicServer 10.3 - this is an upgrade from a working Hibernate environment in WLS 8.1

The SQL and HQL procedures still work, but trying to call an Oracle stored procedure or function which returns a sys_refcursor fails, whatever the Dialect setting in the hibernate cfg file:

This is causing real grief - is there a fix?

7672 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG jdbc.AbstractBatcher - 2010-03-15 21:18:08,192 about to o
pen PreparedStatement (open PreparedStatements: 0, globally: 0)
7694 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG hibernate.SQL - 2010-03-15 21:18:08,214 { ? = call ninjad evmain.reference_tables.get_error_codes() }
7995 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG jdbc.AbstractBatcher - 2010-03-15 21:18:08,515 about to c
lose PreparedStatement (open PreparedStatements: 1, globally: 1)
8011 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG util.JDBCExceptionReporter - 2010-03-15 21:18:08,531 coul
d not execute query [{ ? = call ninjadevmain.reference_tables.get_error_codes() }]
java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 18:
PLS-00382: expression is of wrong type
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
at org.hibernate.dialect.Oracle8iDialect.getResultSet(Oracle8iDialect.java:437)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:215)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1809)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at no.netcom.ninja.core.system.persistence.QueryNinja.fullQuery(QueryNinja.java:1504)

Steve Ebersole
March 21, 2011, 7:08 PM

Bulk closing stale resolved issues

Duplicate

Assignee

Gail Badner

Reporter

akash

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major