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

Oracle Community | 735362 | 6 years 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

    OIM-OIA Integration : Import Accounts

    Oracle Community | 6 years ago | 735362
    java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  2. 0

    Error while update Child Form

    Oracle Community | 7 years ago | 670947
    java.sql.SQLSyntaxErrorException: ORA-00904: "ORC_KEY": invalid identifier
  3. 0

    jtrac with oracle 10g problem

    j-trac | 8 years ago | silviog
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: parola chiave FROM non trovata dove prevista )
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RE: SQOOP export to Oracle failing

    sqoop-user | 1 year ago | David Robson
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00904: "Y": invalid identifier
  6. 0

    RE: SQOOP export to Oracle failing

    sqoop-user | 1 year ago | Ramya Vasudevan
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00904: "Y": invalid identifier
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.SQLSyntaxErrorException

    ORA-01722: invalid number

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
    9. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
    12 frames
  3. JBoss Application Server Connector
    WrappedStatement.executeQuery
    1. org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)
    1 frame
  4. com.thortech.xl
    tcITResourceInstanceOperationsSession.findITResourceInstances
    1. com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
    4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    5. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    8. com.thortech.xl.ejb.beansimpl.tcITResourceInstanceOperationsBean.findITResourceInstances(Unknown Source)
    9. com.thortech.xl.ejb.beansimpl.tcITResourceInstanceOperationsBean.findITResourceInstances(Unknown Source)
    10. com.thortech.xl.ejb.beans.tcITResourceInstanceOperationsSession.findITResourceInstances(Unknown Source)
    10 frames
  5. 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:597)
    4 frames
  6. JBoss Application Server Server
    StatelessSessionContainer$ContainerInterceptor.invoke
    1. org.jboss.invocation.Invocation.performCall(Invocation.java:359)
    2. org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
    2 frames
  7. JBoss Application Server Connector
    CachedConnectionInterceptor.invoke
    1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
    1 frame
  8. JBoss Application Server Server
    Container.invoke
    1. org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
    2. org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
    3. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
    4. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
    5. org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
    6. org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
    7. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
    8. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
    9. org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
    10. org.jboss.ejb.Container.invoke(Container.java:960)
    10 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  10. org.jboss.mx
    ReflectedDispatcher.invoke
    1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    1 frame
  11. JBoss Application Server J2SE
    MBeanServerImpl.invoke
    1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    2. org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    4 frames
  12. JBoss Application Server Server
    UnifiedInvoker.invoke
    1. org.jboss.invocation.unified.server.UnifiedInvoker.invoke(UnifiedInvoker.java:231)
    1 frame
  13. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  14. org.jboss.mx
    ReflectedDispatcher.invoke
    1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    1 frame
  15. JBoss Application Server J2SE
    MBeanServerImpl.invoke
    1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    2. org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    4 frames
  16. Java RT
    MBeanServerInvocationHandler.invoke
    1. javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288)
    1 frame
  17. Unknown
    $Proxy14.invoke
    1. $Proxy14.invoke(Unknown Source)
    1 frame
  18. org.jboss.remoting
    ServerThread.run
    1. org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809)
    2. org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:608)
    3. org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:420)
    4. org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:173)
    4 frames