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
