Hibernate Mapping Types.

[Gundum Hoi]

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

        
<id name="id" column="ID">
    <generator class="native"/> 
</id>

the generated SQL is :

   
`ID` int(11) NOT NULL auto_increment

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

  
integer, long, short, float, double, character, byte, boolean, yes_no, true_false
Type mappings from Java primitives or wrapper classes to appropriate (vendor-specific) SQL column
types. boolean, yes_no and true_false are all alternative encodings for a Java boolean or
java.lang.Boolean.
  

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


DB : MySQL



Thank you.

[Arun Kumarr]

try using short.

<id name="id" column="ID" type="java.lang.Short" >
  <generator class="native" />
</id>