Re: Small bug in Entity Engine

Posted by Andrew Sykes on Sep 13, 2006; 5:30pm
URL: http://ofbiz.116.s1.nabble.com/Small-bug-in-Entity-Engine-tp141811p141813.html

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
>

--
Kind Regards
Andrew Sykes <[hidden email]>
Sykes Development Ltd
http://www.sykesdevelopment.com