topic Re: 'Could not execute JDBC batch update' error in Alfresco Archive

'Could not execute JDBC batch update' error

edgar — Tue, 03 Jul 2007 12:08:18 GMT

When I try to all my changed resources in my Web Project through the default Web Site Submission workflow I get a "Could not execute JDBC batch update" error. From the alfresco.log file:13:54:23,782 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: JDBC exception

Re: 'Could not execute JDBC batch update' error

kevinr — Wed, 04 Jul 2007 09:09:40 GMT

The default HSQL is really on for playing with Alfresco and testing out the features. You should move to MySQL or another DB for any significant work - you won't get these problems then.

Thanks,

Kevin

Re: 'Could not execute JDBC batch update' error

davidc — Wed, 04 Jul 2007 09:39:10 GMT

This bug has now been investigated and oddly enough will be found on most databases except MySQL. A fix will go into HEAD today.

Re: 'Could not execute JDBC batch update' error

kvc — Wed, 04 Jul 2007 15:53:07 GMT

As a quick follow-up on Dave's behalf, who just checked in the fix for this into HEAD. It will be rolled into our updated Community build within the next two weeks.

Fix to fix for JBPM unique constraint issue. SQL should work against all DBs now.
———————————————————————————-

                 Key: CHK-771
                 URL: http://issues.alfresco.com/browse/CHK-771
             Project: Check In
          Issue Type: Check In
      HEAD or Branch: HEAD
          Components: Installation

–Overview–
Fix to fix for JBPM unique constraint issue. SQL should work against all DBs now.

You should no longer get:

15:18:26,524 ERROR [domain.schema.SchemaBootstrap] Statement
execution failed:
    SQL: UPDATE JBPM_PROCESSINSTANCE SET KEY_ = '' || ID_ WHERE KEY_
IS NULL
    Error: Duplicate entry '1-5' for key 2