OFBiz and Firebird DB

[Sam Carleton]

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

[Jacques Le Roux]

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" <[hidden email]>

>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
>

[Paul Foxworthy]

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" <[hidden email]>
>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
>

[Sam Carleton-2]

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" &lt;
>
> > scarleton@
>
> > &gt;
> >>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

[Jacques Le Roux]

Hi Sam,

Thanks for you interest in contributing
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices

Jacques

From: "Sam Carleton" <[hidden email]>

> 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" &lt;
>>
>> > scarleton@
>>
>> > &gt;
>> >>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
>

[Paul Foxworthy]

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

[varun]

CONTENTS DELETED

The author has deleted this message.