Hi

I apologize if this question has been answered already. I searched through the forums all of yesterday and googled with no luck.

I am running an Oracle 9i database and using a 10G driver - ojdbc14_10-2-0-3.jar (copied to lib folder) , we are upgrading our database to 10G soon.

I'm attempting to reverse gen my schema into model classes. I am also a custom strategy ( copied from a forum post here ) that annotates my version column correctly.

All my tables have timestamp columns for audit.



The generated code maps my timestamp columns to Serializable


I understand this is an Oracle problem, but is there anyone who has a workaround for this ?

If I do change these fields to Date type, I do get the expected results.
My gut tells me that I should change my fields to Date type. The only issue I still see is that even with Date fields, the generated methods are not annotated with @Temporal(TemporalType.TIMESTAMP)


Can anyone offer some advice ?

Thanks
Franco

I modified my fields to Date datatype in Oracle.

After reverse gen this time, I did get @Temporal(TemporalType.DATE) and I changed it to @Temporal(TemporalType.TIMESTAMP)

The problem I encountered then was that Hibernate strips off time after an update.

I then annotated the columns this way
@Column(name = "DATE_MODIFIED", updatable = false, insertable = false)

and wrote a before insert/update trigger to update these datetime values.

The only problem I might encounter in future is when I have to update a datetime field from the UI

Anyone here using an Oracle 9i db and above have any ideas ?

Thanks
Franco