Thank you for the info. Didn't know about the change in name or how common they are;)
I have st.arted digging deeper into things, so far I have found that the precision was set too high, was 20,0 for a field when the max is 18. That allowed me to create all the tables. Now I am working on some runtime errors. The only problem is that even though this is at the top of my priority list, I have other lists which must come before mine;). I am hoping to dig more into things next week sometime and I am sure I will have a lot more questions! Thanks for the responses. As I fix things, how do I submit them back to the project? Sam On Monday, May 27, 2013, Paul Foxworthy wrote: > 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. > -- Sent from el iPhone 513.349.5084
