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
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)
Bulk closing stale resolved issues
