Eclipse Community Forums: EMF » [Teneo] Recommended way to override Java to DB Type Mapping for various databases

Home » Modeling » EMF » [Teneo] Recommended way to override Java to DB Type Mapping for various databases( Recommended way to override Java to DB Type Mapping for various databases)

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

Tue, 18 September 2012 11:15

Josh A

Messages: 13
Registered: September 2012

Junior Member

Hi,

For various DB Dialects(DB2,Oracle,MS-SQL & Postgres are the ones i am most interested in), Is there a way to influence Java type to DB Type mapping in Teneo?

For example, is there a way to indicate to teneo to map a given EAttribute to a 'datetime2' type column in MS-SQL?

I came across the following Hibernate annotation which looked promising @Type(type="timestamp"). However, i am not sure what is the equivalent for timestamp2 in this annotation?

I guess the other option is to create a new hibernate UserType and map it via @Type(type="org.example.test.annotations.TimeStamp2Type")?

Thanks for your help,
Josh

Report message to a moderator

Re: [Teneo] Recommended way to override Java to DB Type Mapping for various databases [message #916346 is a reply to message #915989]

Tue, 18 September 2012 22:46

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Josh,
If you want different mappings for different databases then I would create your own Dialect variant, overriding the
standard ones provided by Hibernate.

Check the Dialect implementation to see what to override (for example registerColumnType).

On 09/18/2012 01:15 PM, Josh A wrote:
> Hi,
>
> For various DB Dialects(DB2,Oracle,MS-SQL & Postgres are the ones i am most interested in), Is there a way to influence
> Java type to DB Type mapping in Teneo?
> For example, is there a way to indicate to teneo to map a given EAttribute to a 'datetime2' type column in MS-SQL?
>
> I came across the following Hibernate annotation which looked promising @Type(type="timestamp"). However, i am not sure
> what is the equivalent for timestamp2 in this annotation?
>
> I guess the other option is to create a new hibernate UserType and map it via
> @Type(type="org.example.test.annotations.TimeStamp2Type")?
> Thanks for your help,
> Josh

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org

Report message to a moderator