When I have this in my mapping file (hbm.xml):



the generated SQL is :



But I want SMALLINT and not int(11)

How do I specifically specify the SQL types that I want ? Hibernate generates "approximate" datatypes for both the SQL and Java sides which, to me, is quite annoying. I think I know best which datatype to use ... for example, I want a field in my Java class to be Integer and map it to SMALLINT in the DB.

Also, I tried finding on the net a "mapping table" ... something like this:
Java DataType - Hibernate Mapping Type - MySQL datatype
String - string - varchar
etc etc
...

But, surprisingly I could not find any. Those that I found were very vague ... they go something like :




I need a more "precise" table..showing which exact type map to which.


DB : MySQL

Thank you.

Hi,

you might want to try something like this:


I think that way you should be able to specify any sql-type your database supports.

piet.t, thanks for suggesting that solution. It does give me SMALLINT which I wanted

But with


I get


It is not unsigned. I need the SMALLINT to be unsigned. Hibernate has facility for that ?

Thanks
[/code]