Re: Small bug in Entity Engine

Posted by flj on Sep 14, 2006; 9:49am
URL: http://ofbiz.116.s1.nabble.com/Small-bug-in-Entity-Engine-tp141811p141814.html

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