1 Reply Latest reply on Sep 8, 2006 10:48 AM by Mark Ricard

    java.sql.SQLException: ORA-01461: can bind a LONG value only

    Sachin Newbie

      We are using JBoss3.2.7, Oracle 9 and OCI Thin Type 4 drivers.

      Any help (ASAP) is WelCome.
      Got the following stack trace:

      Could not create entity
      java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a
      LONG column

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      at
      oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:685)
      at
      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1138)
      at
      oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3018)
      at
      oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3090)
      at
      org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:86)
      at
      org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:335)
      at
      org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.executeInsert(JDBCAbstractCreateCommand.java:349)
      at
      org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:307)
      at
      org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
      at
      org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:572)
      at
      org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:211)