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

Hibernate JIRA | Mathias Bogaert | 1 decade ago
  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

    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