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

  1. rp 1 times, last 2 weeks 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