I have hibernate annotations in my code, and use hbm2ddl to generate schema for a couple of different hibernate dialects. I have some fields annotated as

/**
* End time of the task
* @return
*/
@Temporal(TemporalType.TIMESTAMP)
public Date getEndTime() {
return endTime_;
}

I would expect this to map to the oracle TIMESTAMP, but I get
create table ... ( ... startTime date, ...

This code generates a "timestamp" for hsqldb and a "datetime" for ms-sql.

I'm using the hibernate-tools.jar from
hibernate-tools/plugins/org.hibernate.eclipse_3.2.0.beta9a

Is this a bug or am I misinterpreting something? Is there a newer release of the tools?

My guess is that you are using OracleDialect instead of Oracle9Dialect.

Oracle9Dialect has the following:
registerColumnType( Types.TIMESTAMP, "timestamp" );

where as OracleDialect has:
// Oracle8 and previous define only a "DATE" type which
// is used to represent all aspects of date/time
registerColumnType( Types.TIMESTAMP, "date" );

Oooh. Thank you.

I didn't know or didn't notice or forgot that there was another oracle dialect. It works as expected with Oracle9Dialect.