You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Sam Carleton <sc...@gmail.com> on 2013/05/25 02:27:01 UTC
OFBiz and Firebird DB
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
Allow Shipgroup address change from backend
Posted by Varun Kothari <va...@tcs.com>.
Dear All,
Need your views on this, please help.
Shipgroup address / method change is allowed which changes address on
order line item for already shipped items to earlier address
1) For an order with two quantities of an item, one ship group has been
created.
2) From the back-end OMS app, I pack an item using "Pack shipment for ship
group" button on shipgroup
3) Now i am allowed change the address and shipment method on ship group
4) this change in ship group address is maintained on line items as well
as contact information even for item which has been shipped already to
another address
5) Though we could check the packing slip for already packed items to see
their real shipment address
Shall we not allow address change on a ship group, if any one of the item
on it has already been packed / shipped. Please suggest.
regards
Varun Kothari
9810535773
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
Re: OFBiz and Firebird DB
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
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.
Re: OFBiz and Firebird DB
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Sam,
Thanks for you interest in contributing
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices
Jacques
From: "Sam Carleton" <sc...@miltonstreet.com>
> 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
>
Re: OFBiz and Firebird DB
Posted by Sam Carleton <sc...@miltonstreet.com>.
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
Re: OFBiz and Firebird DB
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
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.
Re: OFBiz and Firebird DB
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <sc...@gmail.com>
>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
>