[#HB-1049] Oracl9i-Dialect translates to DATE, should be TIMESTAMP

Hibernate2

Oracl9i-Dialect translates to DATE, should be TIMESTAMP

Created: 25/Jun/04 03:18 PM Updated: 20/Sep/04 03:17 AM

Component/s:

core

Affects Version/s:

2.1, 2.1.1, 2.1.2, 2.1.3, 2.1.4

Fix Version/s:

3.0 alpha

Time Tracking:

Not Specified

File Attachments:

Oracle9Dialect.patch (0.8 kB)

Environment:

We are using realase Hibernate-2.1.4

Issue Links:

Relates

This issue relates to:

~~HB-545~~ oracle 9 dialect - change of timestamp mapping

This issue relates to:

~~HB-545~~ oracle 9 dialect - change of timestamp mapping

Description

« Hide

Bug was already reported and declared fixed in 2.1.3, but Oracle9iDialect.java still maps Type.TIMESTAMP to DATE. It should be TIMESTAMP, because of its greater precision.

All

Comments

Work Log

Change History

Sort Order:

[ Permalink | « Hide ]

Lutz Zimmermann added a comment - 25/Jun/04 03:18 PM

Bug was not fixed in release >=2.1.3

[ Permalink | « Hide ]

Lutz Zimmermann added a comment - 25/Jun/04 03:19 PM

Was declared fixed, but isn't.

[ Permalink | « Hide ]

Lutz Zimmermann added a comment - 25/Jun/04 04:08 PM

This patch changes mapping for Types.TIMESTAMP from DATE to TIMESTAMP

[ Permalink | « Hide ]

Gavin King added a comment - 26/Jun/04 09:44 AM

Fixed in Hibernate3 branch (not in Hibernate 2.1, since it could potentially break existing stuff).

[ Permalink | « Hide ]

Lutz Zimmermann added a comment - 26/Jun/04 10:12 AM

Thanks Gavin, didn't think about that.
But really gave me good insight on Hibernate's "bowels" and my Colleagues Tefan & Methin some cosy hours in our customer's office (lights were out due to cost-containment) ;-)

[ Permalink | « Hide ]

Raimund added a comment - 13/Aug/04 11:41 AM

>> Gavin wrote: not in Hibernate 2.1, since it could potentially break existing stuff

Gavin, would you please elaborate on the "stuff" it could break? Is the workaround to simply define your Oracle columns as timestamp versus changing Oracle9Dialect.java?

[ Permalink | « Hide ]

Gavin King added a comment - 13/Aug/04 06:08 PM

You can always customize the generated DDL by using <column sql-type="TIMESTAMP"/>.

I mean, it will change people's existing Oracle schemas, which is unacceptable in a point release.

[ Permalink | « Hide ]

redmark added a comment - 20/Sep/04 03:17 AM

i can use custom column in property, but i can't do it version because version has not <column> tag