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.