Hi Sam, See https://cwiki.apache.org/OFBADMIN/ofbiz-contributors-best-practices.html for the details of how to submit a patch using the Jira bug tracker.
Cheers Paul Foxworthy Sam Carleton-2 wrote > 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 ----- -- 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-tp4641532p4641566.html Sent from the OFBiz - User mailing list archive at Nabble.com.
