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

Oracle Community | 408063 | 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

    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 | 1 decade ago | 533926
    java.sql.SQLException: ORA-01722: invalid number

  1. rp 1 times, last 5 months ago
27 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