Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Dali » Wrong MySQL Data types mappings
Wrong MySQL Data types mappings [message #434046] Sat, 28 October 2006 10:33 Go to next message
Hasan Ceylan is currently offline 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
Re: Wrong MySQL Data types mappings [message #434047 is a reply to message #434046] Mon, 30 October 2006 23:32 Go to previous messageGo to next message
Neil Hauge is currently offline Neil Hauge
Messages: 469
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
Re: Wrong MySQL Data types mappings [message #434275 is a reply to message #434047] Wed, 01 November 2006 09:38 Go to previous message
Hasan Ceylan is currently offline 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
>
>
Re: Wrong MySQL Data types mappings [message #589374 is a reply to message #434046] Mon, 30 October 2006 23:32 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 469
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
Re: Wrong MySQL Data types mappings [message #590957 is a reply to message #434047] Wed, 01 November 2006 09:38 Go to previous message
Hasan Ceylan is currently offline 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
>
>
Previous Topic:Testing Strategy
Next Topic:Dali Disappeared?
Goto Forum:
  


Current Time: Thu Oct 23 08:47:46 GMT 2014

Powered by FUDForum. Page generated in 0.02294 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software