[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-230) Oracle resultset problem

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Mathias Bogaert
    Created: Tue, 5 Aug 2003 3:25 AM
       Body:
Sorry, I just remembered that I upgraded to Oracle 9.2.0, so maybe that is part of the problem. Runs on WLS 8.1, with older drivers.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-230


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-230
    Summary: Oracle resultset problem
       Type: Bug

     Status: Unassigned
   Priority: Blocker

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1

   Assignee: 
   Reporter: Mathias Bogaert

    Created: Tue, 5 Aug 2003 3:20 AM
    Updated: Tue, 5 Aug 2003 3:20 AM
Environment: 2.0.2

Description:
I'm having a major problem with the Hibernate 2.0.2, it worked fine with Hibernate 2.0.1. Here is the log:

Hibernate: select dg1_.DG_PK as DG_PK0_, dg1_.VERSION as VERSION0_, dg1_.CODE as CODE0_, dg1_.NAME as NAME0_,
dg1_.DESCRIPTION as DESCRIPT5_0_, dg1_.DELETED as DELETED0_, unit0_.UNIT_PK as UNIT_PK1_, unit0_.VERSION as VE
RSION1_, unit0_.CODE as CODE1_, unit0_.NAME as NAME1_, unit0_.DESCRIPTION as DESCRIPT5_1_, unit0_.DELETED as D
ELETED1_, unit0_.DG_FK as DG_FK1_ from AUD_REF_UNITS unit0_, AUD_REF_DGS dg1_ where 1=1 and unit0_.DG_FK=dg1_.
DG_PK(+) and unit0_.deleted='false'
49813 WARN  [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] (hibernate.util.JDBCExceptionReporter:3
8) - SQL Error: 1722, SQLState: 42000
49813 ERROR [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] (hibernate.util.JDBCExceptionReporter:4
6) - ORA-01722: invalid number

49828 ERROR [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] (hibernate.util.JDBCExceptionReporter:3
7) - SQLException occurred
java.sql.SQLException: ORA-01722: invalid number
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1892)
        at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2504)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2832)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
        at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
        at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:71)
        at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:551)
        at net.sf.hibernate.loader.Loader.doFind(Loader.java:140)
        at net.sf.hibernate.loader.Loader.find(Loader.java:620)
        at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:81)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3157)
        at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:65)
        at com.intrasoft.persistence.hibernate.HibernatePersistenceService.findAll(HibernatePersistenceService
.java:146)
        at com.intrasoft.sysaudit.reference.DefaultReferenceManager.getUnits(DefaultReferenceManager.java:90)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:255)
        at ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:654)
        at ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:54)
        at ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:122)
        at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1219)
        at ognl.ASTProperty.getValueBody(ASTProperty.java:108)
        at ognl.SimpleNode.getValue(SimpleNode.java:129)
        at ognl.ASTChain.getValueBody(ASTChain.java:57)
        at ognl.SimpleNode.getValue(SimpleNode.java:129)
        at ognl.Ognl.getValue(Ognl.java:335)
        at ognl.Ognl.getValue(Ognl.java:310)
        at com.opensymphony.xwork.util.OgnlValueStack.findValue(OgnlValueStack.java:74)
        at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:305)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:213)
        at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:365)
        at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:90)
        at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:133)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:269)
        at org.apache.velocity.Template.merge(Template.java:294)
        at com.opensymphony.webwork.views.jsp.ui.AbstractUITag.mergeTemplate(AbstractUITag.java:511)
        at com.opensymphony.webwork.views.jsp.ui.AbstractUITag.doEndTag(AbstractUITag.java:281)
        at jsp_servlet._views._epm.__create._jspService(__create.java:346)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
        at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:431)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:46)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.intrasoft.security.filter.LoginFilter.doFilter(LoginFilter.java:130)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.intrasoft.util.profiling.filter.ProfilingFilter.doFilter(ProfilingFilter.java:137)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at weblogic.servlet.internal.RequestDispatcherImpl$ForwardAction.run(RequestDispatcherImpl.java:345)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
        at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:246)
        at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.execute(ServletDispatcherResult.java:61
)
        at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:221)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:161)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.intrasoft.util.profiling.interceptor.ProfilingInterceptor.intercept(ProfilingInterceptor.java:3
9)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:121)
        at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:165)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.intrasoft.security.filter.MultipleRolesFilter.doFilter(MultipleRolesFilter.java:75)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129)
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.intrasoft.security.filter.LoginFilter.doFilter(LoginFilter.java:150)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.intrasoft.util.profiling.filter.ProfilingFilter.doFilter(ProfilingFilter.java:137)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.jav
a:6297)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
        at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
        at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
        at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)


---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira