Discussions

General J2EE: org.springframework.jdbc.UncategorizedSQLException:

  1. I am simultaneously inserting data into informix database using hibernate3 and spring 1.2.3 framework, but it is throwing following exception. Please provide me the solution how to resolve this. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: table error code [-271]; Could not insert new row into the table.; nested exception is java.sql.SQLException: Could not insert new row into the table. java.sql.SQLException: Could not insert new row into the table. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:349) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3043) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3353) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2254) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2174) at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:718) at com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:305) at com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.java:850) at com.informix.jdbc.IfxPreparedStatement.executeUpdate(IfxPreparedStatement.java:281) at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:48) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:711) at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:895) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:885) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:834) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)

    Threaded Messages (1)

  2. Informix error[ Go to top ]

    Hibernate has encountered a SQLException from the database. Spring has been unable to categorize this exception. The error code (-271) is the most important piece of information. Seems like a low level error. From Informix documentation:
    -271 Could not insert new row into the table. This problem has many possible causes, including a locked table or a full disk. Check the accompanying ISAM error code for more information.
    Rgds Rod Johnson Interface21 - Spring from the Source