Hibernate version:
2.1.2


Oracle 8.1.5 does not provide a means to store and retrieve timestamps that have precision to microseconds. To solve this problem we have added micros columns to store this data. In DB2 and Oracle 9 and 10, the precision is there and the extra columns have been removed.

I can not change the tables to add or remove these columns, but I would like to have one code set that can access either databases. In our C++ code we handle these differences at the db layer. Any suggestions on how to do this with Hibernate?

Just to clarify this code is written to access tables that are primarly used by a C++ application.


Thanks for any information.

Travis Zimmerman

Write a Type (NOT a UserType), that implements VersionType.

I stepped through the TimestampType. At the point that get() is called the ResultSet is already created and did not contain the Micros column in the statement, so it would not be available to retrieve data from.

I am comming at this as having a micr column is the exception not the rule. I have getters and setters for these columns but they are not in the mapping file.

Am I missing something here?