Hi!
I have defined some domains in my postgre database and use them in different columns as datatypes.

In the hibernate-configurations-view in eclipse these columns have set "DISTINCT" as a datatype. (So I think the hibernate-tools can't recognize the column-types correctly)

When I try to reverse engineer the database, the corresponding fields for the columns in the java-files are of type serializable.

My Problem is that these fields should be of the type String or Date,...

I tried to configure the sql-type mappings with a reveng.xml but when I define:

but the problem is that every (domain) field has "String" as datatype, but I use different types for my domains...

has anyone a sollution?

Hibernate version: 3.2.6ga or 3.3.0 CR1

hibernate-tools 3.2.2 Beta1

Postgre SQL 8.2.7


I don't want to define the sql/hibernate-types manually for the columns because there are over 100 Tables in this database...

Thanx in advance!

so you would have to depend on db specific type name I guess....that is not yet implemented though ;(

the idea is for users to be able to specify a native-type next to the jdbc-type which would match on the database specific type name column.

patches welcome!

I 've no deleted my domains and set the datatypes manually like



now reverse engineering works for this type and uses in java files String as datatype.

but when I use Date or Timestamp as Type in my Columns the java types are Serializeable.

and when I open my database in the hibernat-configurations-view to see the tables, columns with these types are showing "DISTINCT" as Datatype...

I 've tested this with different jdbc drivers for postgre,... always the same.[/code]

sounds like postgressql db or driver is not very focused on returning quality metadata ;(