Hibernate version: 2.1.6
Oracle 9.1

Hello, I need to save a type that maps to a table where one of the columns is using an Oracle Timezone with Timestamp type so my question is for the above setup, what should the .hbm file declare for this property and what should the user type have for the Java type.

My latest attempt was

<property
name="timestamp"
type="java.util.Calendar"
column="TIMESTAMP"
/>

And working with a Calendar in Java which results in...

java.sql.BatchUpdateException: ORA-01401: inserted value too large for column

...when saving the type.
The code is translating an xs:datTime to this column, but I have that under control, and am having a problem with the Hibernate mapping and JDBC acceptance of whatever Hibernate is doing under the hood.

This is a standard Oracle type and so someone must have the working combination for this.

Thanks in advance.