java.sql.SQLException: ORA-01722: invalid number

Hibernate JIRA | Mathias Bogaert | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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)

    Hibernate JIRA | 1 decade ago | Mathias Bogaert
    java.sql.SQLException: ORA-01722: invalid number
  2. 0

    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)

    Hibernate JIRA | 1 decade ago | Mathias Bogaert
    java.sql.SQLException: ORA-01722: invalid number
  3. 0

    java.sql.SQLException: ORA-01002: fetch out of sequence

    Stack Overflow | 5 years ago | chetan
    java.sql.SQLException: ORA-01002: fetch out of sequence
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    CLOB/BLOB

    Google Groups | 2 decades ago | Dung Nguyen
    java.sql.SQLException: ORA-01002: fetch out of sequence
  6. 0

    Help, the VO Exception I don`t know how to do

    Oracle Community | 1 decade ago | 493846
    java.sql.SQLException: ORA-01861: literal does not match format string

  1. rp 1 times, last 2 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01722: invalid number

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.fetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1892)
    4. oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2504)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2832)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
    4 frames
  5. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
    1 frame
  6. net.sf.hibernate
    CriteriaImpl.list
    1. net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:71)
    2. net.sf.hibernate.loader.Loader.getResultSet(Loader.java:551)
    3. net.sf.hibernate.loader.Loader.doFind(Loader.java:140)
    4. net.sf.hibernate.loader.Loader.find(Loader.java:620)
    5. net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:81)
    6. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3157)
    7. net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:65)
    7 frames
  7. com.intrasoft.persistence
    HibernatePersistenceService.findAll
    1. com.intrasoft.persistence.hibernate.HibernatePersistenceService.findAll(HibernatePersistenceService.java:146)
    1 frame
  8. com.intrasoft.sysaudit
    DefaultReferenceManager.getUnits
    1. com.intrasoft.sysaudit.reference.DefaultReferenceManager.getUnits(DefaultReferenceManager.java:90)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  10. OGNL - Object Graph Navigation Library
    Ognl.getValue
    1. ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:255)
    2. ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:654)
    3. ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:54)
    4. ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:122)
    5. ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1219)
    6. ognl.ASTProperty.getValueBody(ASTProperty.java:108)
    7. ognl.SimpleNode.getValue(SimpleNode.java:129)
    8. ognl.ASTChain.getValueBody(ASTChain.java:57)
    9. ognl.SimpleNode.getValue(SimpleNode.java:129)
    10. ognl.Ognl.getValue(Ognl.java:335)
    11. ognl.Ognl.getValue(Ognl.java:310)
    11 frames
  11. XWork Tiger Extensions
    OgnlValueStack.findValue
    1. com.opensymphony.xwork.util.OgnlValueStack.findValue(OgnlValueStack.java:74)
    1 frame
  12. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:324)
    3 frames
  13. Apache Velocity
    Template.merge
    1. org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:305)
    2. org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)
    3. org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:213)
    4. org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:365)
    5. org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:90)
    6. org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:133)
    7. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:269)
    8. org.apache.velocity.Template.merge(Template.java:294)
    8 frames
  14. WebWork
    AbstractUITag.doEndTag
    1. com.opensymphony.webwork.views.jsp.ui.AbstractUITag.mergeTemplate(AbstractUITag.java:511)
    2. com.opensymphony.webwork.views.jsp.ui.AbstractUITag.doEndTag(AbstractUITag.java:281)
    2 frames
  15. jsp_servlet._views._epm
    __create._jspService
    1. jsp_servlet._views._epm.__create._jspService(__create.java:346)
    1 frame
  16. weblogic.servlet.jsp
    JspBase.service
    1. weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
    1 frame
  17. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
    2. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
    3. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:431)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    5 frames
  18. Sitemesh
    PageFilter.doFilter
    1. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:46)
    1 frame
  19. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  20. com.intrasoft.security
    LoginFilter.doFilter
    1. com.intrasoft.security.filter.LoginFilter.doFilter(LoginFilter.java:130)
    1 frame
  21. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  22. WebWork
    RequestLifecycleFilter.doFilter
    1. com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61)
    1 frame
  23. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  24. com.intrasoft.util
    ProfilingFilter.doFilter
    1. com.intrasoft.util.profiling.filter.ProfilingFilter.doFilter(ProfilingFilter.java:137)
    1 frame
  25. Atmosphere weblogic
    RequestDispatcherImpl$ForwardAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    2. weblogic.servlet.internal.RequestDispatcherImpl$ForwardAction.run(RequestDispatcherImpl.java:345)
    2 frames
  26. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
    1 frame
  27. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
    1 frame
  28. Atmosphere weblogic
    RequestDispatcherImpl.forward
    1. weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:246)
    1 frame
  29. WebWork
    ServletDispatcherResult.execute
    1. com.opensymphony.webwork.dispatcher.ServletDispatcherResult.execute(ServletDispatcherResult.java:61)
    1 frame
  30. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:221)
    2. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:161)
    2 frames
  31. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
    1 frame
  32. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    1 frame
  33. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
    1 frame
  34. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    1 frame
  35. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
    1 frame
  36. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    1 frame
  37. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
    1 frame
  38. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    1 frame
  39. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
    1 frame
  40. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    1 frame
  41. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
    1 frame
  42. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    1 frame
  43. com.intrasoft.util
    ProfilingInterceptor.intercept
    1. com.intrasoft.util.profiling.interceptor.ProfilingInterceptor.intercept(ProfilingInterceptor.java:39)
    1 frame
  44. XWork Tiger Extensions
    DefaultActionProxy.execute
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
    2. com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:121)
    2 frames
  45. WebWork
    ServletDispatcher.service
    1. com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:165)
    1 frame
  46. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    1 frame
  47. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
    2. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
    3. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
    4. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    4 frames
  48. com.intrasoft.security
    MultipleRolesFilter.doFilter
    1. com.intrasoft.security.filter.MultipleRolesFilter.doFilter(MultipleRolesFilter.java:75)
    1 frame
  49. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  50. Sitemesh
    PageFilter.doFilter
    1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129)
    2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
    2 frames
  51. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  52. com.intrasoft.security
    LoginFilter.doFilter
    1. com.intrasoft.security.filter.LoginFilter.doFilter(LoginFilter.java:150)
    1 frame
  53. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  54. WebWork
    RequestLifecycleFilter.doFilter
    1. com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61)
    1 frame
  55. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  56. com.intrasoft.util
    ProfilingFilter.doFilter
    1. com.intrasoft.util.profiling.filter.ProfilingFilter.doFilter(ProfilingFilter.java:137)
    1 frame
  57. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
    2 frames
  58. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
    1 frame
  59. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
    1 frame
  60. Atmosphere weblogic
    ServletRequestImpl.execute
    1. weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
    2. weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
    2 frames
  61. weblogic.kernel
    ExecuteThread.run
    1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
    2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
    2 frames