When I do a insert in oracle with the properties in the hibernate-mapping
that doesnt have the same order as the fields of the table in the DB and there are date fields with time, it inserts wrong data in some fields

example of inserts
properties in the same order as database
35 35 1 'X' 'Fri Apr 16 10:52:53 GMT-03:00 2004' 'Marcel' '16/4/2004 10:52:53' '16/4/2004 10:52:53' '16/4/2004 10:52:53'
properties in another other different than database
31 31 1 '

sorry, the version of hibernate I'm using is 2.1.2

Can anyone help me?

I am currently experiencing similar problems with Oracle 8.1.6.
The problem does not occur with in Oracle9. Never tried with 8.1.7...
(I am using hibernate 2.1 and ojdbc14.jar - thin mode)

I notice that writing into fields of type DATE in Oracle 8.1.6
leads to the introduction of very strange chars in other columns...
When commenting the date column in the mapping file, the insert is OK.

I tried without success to force the type (e.g: <column type="x" where x = date, timestamp, java.util.Date, java.sql.Date, java.sql.Timestamp, etc...) of my date column in the mapping file, but it does not work
with any of the type listed above :-(

Probably a bug in Oracle 8.1.6...