Hi All,

I am using Hibernate 3.0, I have created a session and in the same session when I am executing 'session.createQuery(...' third time it is producing an error 'Could not execute JDBC batch update'. but first two times it executes successfully.

The code is:

[code]List list = session.createQuery("from "+Sequence.class.getName()+" where sequenceID=:sequenceID")
.setString("sequenceID",sequenceID)
.list();

Your reply will be highly appreciated.

Thanks in advance.
Hemant.

Are you sure you are executing this query only and this query is causing the exception?

message

Hi littypreethkr,

Yes, the scenario is like

HibernateUtil.getSessionFactory BugTrackerConstants.FILE_BUGTRACKER);
Session session = HibernateUtil.currentSession();
transaction=session.beginTransaction();
........
session.createQuery(....//same Query
........
session.save(a)
.........
session.createQuery(.... //same Query --OK
........
session.save(b)
.........
session.createQuery(.... //Same Query --OK
........
session.save(c)
.........
session.createQuery(....//Same Query -- Problem/error
........
session.save(d)
.........
transaction.commit();
HibernateUtil.closeSession();

Oh I see.... Your are querying, making some changes and saving.... Well there could be some issue with the update which is violating something... Can you post the actions you are doing and the stack trace?