getNextException SQLGrammarException

[nimo frey]

How can I get the nextException from a SQLGrammarException?

I use Hibernate and want to store a record and get the following exception:

08:01:25,733 WARN  [JDBCExceptionReporter] SQL Error: -99999, SQLState: null
08:01:25,733 ERROR [JDBCExceptionReporter] Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
08:01:25,733 WARN  [JDBCExceptionReporter] SQL Error: -301, SQLState: 07006
08:01:25,733 ERROR [JDBCExceptionReporter] Error for batch element #0: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 10
08:01:25,733 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
...
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
 
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
... 149 more
Caused by: com.ibm.db2.jcc.a.ge: Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
at com.ibm.db2.jcc.a.j.a(j.java:397)
at com.ibm.db2.jcc.a.id.b(id.java:2935)
at com.ibm.db2.jcc.a.id.a(id.java:2704)
at com.ibm.db2.jcc.a.id.executeBatch(id.java:2516)
at com.ibm.db2.jcc.a.id.executeBatch(id.java:1348)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519)

Now, I want the to "Use getNextException() to retrieve the exceptions for specific batched elements". But this does not print the nextException to my console:

class SessionEJB implements SessionEJBLocal {
try {
 
// persist a record
}
 
catch (org.hibernate.exception.SQLGrammarException e)
{
e.getSQL();
log.debug("e.getSQL() " + e.getSQL());
e.getSQLException();
log.debug("e.getSQLException()" + e.getSQLException());
      e.getSQLException().getNextException().getStackTrace();
e.printStackTrace();
}

But this does not work..I guess. I cannot get the next SQL Exception. The stacktrace is the same as above, even I catch and want to get the nextException.

Use getNextException() to retrieve the exceptions for specific batched elements

Yes, but how???

[Marcella Spiropulos]

Hey Folks,

I know this topic a little old, but I'm facing the same issue. I'll appreciate if someone could help me to understand this exception.

Best Regads,
Marcy