Hi,

I have a web application and the database is Oracle 9i.
This is the pseudo code of the requests:

Database db = jdo.getDatabase();
db.begin();
String id = request.getParameter("ID");
OQLQuery qry = db.getOQLQuery("SELECT h FROM "
+HazardAssessmentModel2.class.getName()+" h " +
                               "WHERE h.ID = $1 ");
qry.bind(id);
QueryResults r = qry.execute();
ModelInterface model = (ModelInterface)r.next();
model.setName(request.getParameter("name"));
db.commit();

When a lunch the request the first time every goes well.
When I launch it a second time, I get:
"org.exolab.castor.jdo.ObjectModifiedException: Transaction aborted: Object
of ty
pe com.datachest.worksafe.model.HazardAssessmentModel2 with identity 11,998
has
been modified by a concurrent transaction".

If I do a reload on my browser, the modification is accepted.
Since all my databases are commited, why do I still get
a lock on them?

Thanks for your help.

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to