java.sql.SQLException: Invalid column type

Oracle Community | 3004 | 1 decade ago
  1. 0

    Mapping util.Date to Oracle timestamp

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Invalid column type
  2. 0

    'Invalid column type' when setting null CLOB columns with metadata type

    Oracle Community | 1 decade ago | 45826
    java.sql.SQLException: Invalid column type
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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

      Invalid column type

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      2. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      3. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
      3 frames
    3. Oracle jdbc
      OraclePreparedStatement.setNull
      1. oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:6164)
      2. oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:1316)
      2 frames
    4. com.solarmetric.jdbc
      DelegatingPreparedStatement.setNull
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:369)
      2. com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.setNull(PoolConnection.java:406)
      3. com.solarmetric.jdbc.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:369)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:369)
      5. com.solarmetric.jdbc.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:369)
      6. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.setNull(LoggingConnectionDecorator.java:792)
      7. com.solarmetric.jdbc.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:369)
      7 frames
    5. kodo.jdbc.sql
      RowImpl.flush
      1. kodo.jdbc.sql.DBDictionary.setNull(DBDictionary.java:950)
      2. kodo.jdbc.sql.OracleDictionary.setNull(OracleDictionary.java:450)
      3. kodo.jdbc.sql.RowImpl.toSQL(RowImpl.java:828)
      4. kodo.jdbc.sql.RowImpl.flush(RowImpl.java:1039)
      5. kodo.jdbc.sql.RowImpl.flush(RowImpl.java:975)
      5 frames
    6. kodo.jdbc.runtime
      JDBCStoreManager.flush
      1. kodo.jdbc.runtime.PreparedStatementManager.flushInternal(PreparedStatementManager.java:160)
      2. kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:84)
      3. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:445)
      4. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:193)
      5. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:95)
      6. kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:609)
      6 frames
    7. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.DelegatingStoreManager.flush(DelegatingStoreManager.java:153)
      2. kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:1122)
      3. kodo.runtime.PersistenceManagerImpl.flushSafe(PersistenceManagerImpl.java:1005)
      4. kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:932)
      5. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
      6. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:592)
      6 frames
    8. com.ysoft.jdo
      Library.main
      1. com.ysoft.jdo.book.library.LibraryHandler.commitTransaction(LibraryHandler.java:175)
      2. com.ysoft.jdo.book.library.client.CommitTransaction.execute(Library.java:279)
      3. com.ysoft.jdo.book.common.console.UserInterface.execute(UserInterface.java:196)
      4. com.ysoft.jdo.book.common.console.UserInterface.pumpCommands(UserInterface.java:186)
      5. com.ysoft.jdo.book.library.client.Library.run(Library.java:139)
      6. com.ysoft.jdo.book.library.client.Library.main(Library.java:104)
      6 frames