Eclipse Community Forums: Dali » Wrong MySQL Data types mappings

Help

Home

Home » Eclipse Projects » Dali » Wrong MySQL Data types mappings

Show: Today's Messages :: Show Polls :: Message Navigator

Wrong MySQL Data types mappings [message #434046]

Sat, 28 October 2006 10:33

Hasan Ceylan

Messages: 54
Registered: July 2009

Member

Hello,

I was trying the "Create entities..." option of DALI. Database was
created in MYSQL 5.0.22.

I noticed that the Integer fields and tinyint(1) fields were mapped to
Object where as they should be mapped to Integer and boolean respectively.

Is this something that I can work around or is it a bug in DALI?

Regards,
Hasan Ceylan

Report message to a moderator

Re: Wrong MySQL Data types mappings [message #434047 is a reply to message #434046]

Mon, 30 October 2006 23:32

Neil Hauge

Messages: 475
Registered: July 2009

Senior Member

For Dali 0.5, the mapping from DB type to Java type is handled by the WTP
RDB component. There are XMI files that are defined for the various DB's
that can be configured by the user if necessary. The XMI files are in
this general area - org.eclipse.wst.rdb.dbdefinition.

For Dali 1.0, the DTP will handle this mapping in a similar fashion.

So for Dali 0.5, you should be able to alter the MySQL_4.1.xmi file to map
the way you want it to. This file is located in your plugins directory -
org.eclipse.wst.rdb.dbdefinition.mysql*.jar.

The other thing you can do is request support of your DB version in DTP
for the future.

Hope this helps.

Neil

Hasan Ceylan wrote:

> Hello,

> I was trying the "Create entities..." option of DALI. Database was
> created in MYSQL 5.0.22.

> I noticed that the Integer fields and tinyint(1) fields were mapped to
> Object where as they should be mapped to Integer and boolean respectively.

> Is this something that I can work around or is it a bug in DALI?

> Regards,
> Hasan Ceylan

Report message to a moderator

Re: Wrong MySQL Data types mappings [message #434275 is a reply to message #434047]

Wed, 01 November 2006 09:38

Hasan Ceylan

Messages: 54
Registered: July 2009

Member

Hello Neil,

Thanks for the reply. It definitly helps.

Hasan
Neil Hauge wrote:
> For Dali 0.5, the mapping from DB type to Java type is handled by the
> WTP RDB component. There are XMI files that are defined for the various
> DB's that can be configured by the user if necessary. The XMI files are
> in this general area - org.eclipse.wst.rdb.dbdefinition.
>
> For Dali 1.0, the DTP will handle this mapping in a similar fashion.
> So for Dali 0.5, you should be able to alter the MySQL_4.1.xmi file to
> map the way you want it to. This file is located in your plugins
> directory - org.eclipse.wst.rdb.dbdefinition.mysql*.jar.
> The other thing you can do is request support of your DB version in DTP
> for the future.
>
> Hope this helps.
> Neil
>
>
>
> Hasan Ceylan wrote:
>
>> Hello,
>
>> I was trying the "Create entities..." option of DALI. Database was
>> created in MYSQL 5.0.22.
>
>> I noticed that the Integer fields and tinyint(1) fields were mapped to
>> Object where as they should be mapped to Integer and boolean
>> respectively.
>
>> Is this something that I can work around or is it a bug in DALI?
>
>> Regards,
>> Hasan Ceylan
>
>

Report message to a moderator