Hi Sam, Generators aren't unique to Firebird. They are a standard SQL 2003 feature, only in SQL they are called sequences, not generators. From Firebird 2 on, it's recommended to use the "sequence" word. Postgres, for example, also provides sequences.
http://www.firebirdsql.org/refdocs/langrefupd25-ddl-sequence.html OFBiz generates its own sequence numbers rather than relying on the underlying database. See https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/src/org/ofbiz/entity/util/SequenceUtil.java?hb=true Cheers Paul Foxworthy Jacques Le Roux wrote > 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" < > scarleton@ > > >>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 >> ----- -- Coherent Software Australia Pty Ltd http://www.coherentsoftware.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-and-Firebird-DB-tp4641532p4641560.html Sent from the OFBiz - User mailing list archive at Nabble.com.
