3:09 p.m.
OracleDialect with oracle 11g
-----------------------------
Key: HHH-3682
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3682
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.2.5
Environment: Oracle 10.2, weblogic 10.3 , java 1.6 , spring 2.0
Reporter: akash
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 ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:05 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-3682) OracleDialect with oracle 11g
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3682?page=c...
]
Gail Badner resolved HHH-3682.
------------------------------
Assignee: Gail Badner
Resolution: Duplicate
OracleDialect with oracle 11g
-----------------------------
Key: HHH-3682
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3682
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.2.5
Environment: Oracle 10.2, weblogic 10.3 , java 1.6 , spring 2.0
Reporter: akash
Assignee: Gail Badner
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 ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:06 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3682) OracleDialect with oracle 11g
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3682?page=c...
]
Richard Marriott commented on HHH-3682:
---------------------------------------
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)
OracleDialect with oracle 11g
-----------------------------
Key: HHH-3682
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3682
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.2.5
Environment: Oracle 10.2, weblogic 10.3 , java 1.6 , spring 2.0
Reporter: akash
Assignee: Gail Badner
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 ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5215
days inactive
5652
days old
hibernate-issues@lists.jboss.org
2 comments
3 participants
participants (3)
-
akash (JIRA) -
Gail Badner (JIRA)
-
Richard Marriott (JIRA)