I want my schema to have Integer fields but I get "number(10,0)" instead.
I'm using Oracle9Dialect.

Thank you.

Hibernate version:2.1

Mapping documents:
<hibernate-mapping>
<class name="foo" table="foo">

<id name="id" column="id"type="java.lang.Integer" >
<generator class="increment"> </generator>
</id>

<property name="matchingEventId" type="java.lang.Integer"
update="true" insert="true"
access="property" column="matchingEventId" />
</class>

</hibernate-mapping>


I get this in my schema_export.sql:

create table foo (
id NUMBER(10,0) not null,
matchingEventId NUMBER(10,0),
)

All Oracle integer fields are described as number( x ) in the db where x is the number of digits required by the type.

Integer is number( 10 )
Long is number( 19 )

The second optional number is the number of decimal places the number has which is zero for ints/longs etc.