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

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

  1. bpbhat77 1 times, last 6 months ago
8 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.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