How to specify SQL column type for a specific database in hibernate mapping file

Question

Is it possible to set multiple SQL column types for an hibernate property depending on the dialect used ? If yes how ?

For example, if i have a column of type char[], I would like to create a CLOB type for Oracle and a Text type in SQL Server.

ChssPly76 · Accepted Answer · 2011-05-11 17:58:13Z

1

The short answer is "no, it's not possible".

The long answer is "kind of, but you probably don't want to do that":

Hibernate would do that automatically to a certain extent - that is, when you define (implicitly or explicitly) a property of certain Hibernate type, it will translate that type to appropriate RDBMS-specific SQL type. Dialect and its descendants are responsible for that translation.

You could influence how that translation occurs - again, to a certain extent - by extending the dialect(s) you're working with (like Oracle or SQL Server) and registering your own column types. You're likely better off relying on default Hibernate type mappings, though.

answered May 11, 2011 at 17:58

ChssPly76

101k25 gold badges210 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Denis R. Over a year ago

Thanks, in fact I am trying to modify code that I have not written and the types in hbm.xml files are specified as java type instead of hibernate types and I did not know the difference.

Collectives™ on Stack Overflow

How to specify SQL column type for a specific database in hibernate mapping file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related