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

Oracle Community | 408063 | 1 decade ago
  1. 0

    problem of invalid number

    Oracle Community | 1 decade ago | 408063
    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. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    problem with seeded extension example - adding supplier site

    Oracle Community | 1 decade ago | 491697
    java.sql.SQLException: ORA-01722: invalid number
  5. 0

    Lov Crashes even b4 reaching to PR

    Oracle Community | 10 years ago | 533926
    java.sql.SQLException: ORA-01722: invalid number

    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:180)
      1 frame