On Wednesday 16 June 2004 01:05, Dan Wilson wrote:

Hi,

> I am far from a relational database expert, but some of the
> things the ofbiz people have done in designing their data model seem like
> very poor decisions to this feeble brain. Specifically, they make use of
> multiple, 255-byte varchar fields as components of primary keys (i.e., a
> primary key might consist of field1(varchar 255), field2(varchar 255),
> field3(varchar 255), and field4(varchar 255)).

I agree, that is just poor design.

> I will continue to explore this issue, but for now, we appear to be out of
> luck using Firebird with ofbiz.

We would likley be using it with Oracle as well, and I know our Oracle DBA's
would not be keen on PK's as described.

Maybe it would be worth posting a feature request to their issue tracker for
PK's that are either INT64, GUID or UUID?

Phil



--
Discover a lost art - play Marbles
May 2004
www.marillion.com
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | pjshrimpton@...