Urgent help required.

Shirish · **Posted:** Wed Jan 03, 2007 3:58 am

Hi,
I have Oracle driver 8.1.7 installed on my machine.My database server is Oracle 10g. I am using an Nhibernate query which is like:
"select p.objectID, p.TimeIn from PrimeObject as p" . Here TimeIn is a property of PrimeObject class which maps to Time_In column of Database which is of type TimeStamp.

Since Oracle 8.1.7 doesnt support TimeStamp dataType, the HQL is failing. Can something be done in Hibernate mapping file to take care of this.

Pls suggest..

-Shirish

batmat · **Posted:** Wed Jan 03, 2007 5:19 am

Please note I'm a Hibernate user, not NHibernate, but some concepts are similar, so let's try :-).

Maybe try writing a custom UserType? Then add type="yourUserType" to the corresponding property.

But why can't you just update the driver and maybe also the dialect for Oracle 10G?

Shirish · **Posted:** Wed Jan 03, 2007 5:26 am

Thnks Baptiste..
However I cant update driver to Oracle 10G, since this is one of the constraint for us.

Can u elaborate on using custom datatypes and how can I use it to get rid of timestamp datatype in Oracle 10g which is creating a problem.

Awaiting reply.

Thnks again..

- Shirish

batmat · **Posted:** Wed Jan 03, 2007 5:41 am

You've got some examples for NHibernate linked from the Hibernate site:
http://www.hibernate.org/100.html

More can be found here: http://www.hibernate.org/37.html#A7

HTH