Hello.
Don't ask for details, it's just a faded memory (I'm not regularly working
with databases), but I seem to remember that some databases always return
column names in upper case when ased about table definitions. In case the
entity engine relies on column names as returned by the database, it might
be a good idea to always enforce all column and table names to be
capitalized.
br,
--
Florin Jurcovici
------------------
Why do psychics have to ask you for your name?
On Wed, 13 Sep 2006 19:30:32 +0300, Andrew Sykes
<[EMAIL PROTECTED]> wrote:
David,
is there any good reason why uppercase should be enforced on user
defined tables?
This can cause problems if for example you are trying to retrospectively
tie the entity engine to a database table...
- Andrew
On Wed, 2006-09-13 at 04:59 -0600, David E Jones wrote:
Hans,
Could you describe the actual problem you're having with this?
Column names in OFBiz entity definitions are generated by default as
upper case and manually defined ones should also be defined this way.
-David
On Sep 13, 2006, at 2:13 AM, Hans Holmlund wrote:
> There is a small bug in Entity Engine DatabaseUtil. When the
> metadata is fetched from the database all column names are
> converted to capital letters (DatabaseUtil.java row 1047). But when
> the entities is checked if they have a corresponding table (and
> column) the column names are not converted to uppercase. Therefore
> row 206 should look like:
> fieldColNames.put(field.getColName
> ().toUpperCase(), field);
>
> / Hans H
