hi all,

I want to map sql datetime to java.util.Date using hibernate tools i have put this <sql-type hibernate-type="java.util.Date" jdbc-type="DATE" /> entry in the reveng.xml. but still it is mapping to timestamp type. i tried with this
<sql-type hibernate-type="java.util.Date" jdbc-type="datetime" /> entry then it is showing an error. Can any body tell me which type has to be used to map sql datetime to java.util.Date

Thanks,
Joseph.C

what is the error ? something like jdbc-type not found in Types ? then either use a real name from java.sql.Types or use the numerical value returned for your db for such columns.

<property name="createdOn" type="timestamp">
<column name="CREATED_ON" length="23" />

this is what is generated from the hibernate console. even if i gave the sql type as"DATE" .I am using ms-sql server.

OR

which template file should i modify to change the default from timestamp to java.utill.Date

Joseph C

sorry, but your questions are inconsistent.

in the first part you say there is an error, in the second you say it generates but with something you don't like.

And there is no template to change, you need to fix the type mapping.

by error i meant was that:

if i gave jdbc type as "datetime" and java type as " java.util.Date" then it generated an error "not a valid sql type"

the other scinario is:

If i gave jdbc type as "DATE" and java type as " java.util.Date" then it generates the type as "timestamp" instead of java.util.Date

this is what i meant

Regards,

Joseph.C

yes and datetime is not a valid sql type (e.g. it is not listed in java.sql.Types)

as I said before, then use whatever numerical value your db driver returns for whatever you call datetime.

or override the hibernate type specifically for each relevant column.