Hi Sam, OFBiz does not use auto-sequence attribute. Since 9th July 2011 https://issues.apache.org/jira/browse/OFBIZ-2353 version above (included) R10.04 use SELECT FOR UPDATE This works well with other DBs
HTH Jacques From: "Sam Carleton" <[email protected]> >I would like to use the Firebird DB with ofbiz. I configured it to use > Firebird and when I ran the load-demo, a lot of errors flashed across the > screen, but still many things were created in the DB. When I go to run it > and connect for the first time, I get the following error in the browser: > > HTTP Status 500 - Could not get next sequenced ID for sequence name: Visitor > > I have worked with Firebird for many years now and this isn't a > huge surprise to me. Unlike the other databases I have encountered, > Firebird does *NOT* have the concept of an auto-sequence attribute for a > column. If that is a desired feature (when isn't it?) you have to use > triggers and a unique Firebird feature called a generator. > > I am wondering if there are more details out there on how to get ofbiz to > work with Firebird. > > Sam >
