Hi ppl !

This is a old issue but i couldn't solve yet. I'm using Hibernate 3 and connecting to an Oracle version 8i.
Now the problem: I have a DATE type field. (Not TIMESTAMP, this type doesn't exist in this version)
I'm trying to map this field to an java.util.Date class. But it only retrieves the date and ignore the time part when i map it using the type="date".
If I use the type="time" it retrieves only the time and but this time i don't have the date.
Mapping with a type="timestamp" i got an exception. And if i don't define any type i get an exception: "time stamp expected".
Mapping to a calendar java type and a java.sql.Date was unsuccesful too.
I used in my experiments the ojdbc14.jar driver version 8 and 10.
I can't update or change the version of the Oracle server. And i don't think i have to create a user defined type to map a so usual field type.
Have anybody solved this issue before? Please i need some light on it.

Thanks in advance

you should remove type. type is not required.

Yeah, as i said I have read about don't mentioning the type. But it's not working for me. When i don't put the type i get an "Exception: timestamp expected for column ..."
When you don't put a especific type, hibernate chooses the best type for you. But in my case, hibernate is choosing the timestamp type which is incompatible with the DATE type field in Oracle 8i. I know this works for Oracle 9i and more recent versions.

I hope somebody have a solution for this problem, but thanks for giving your suggestion