java.lang.Long TO NUMBER(20,4) ? I used oracle 10g
I used this:

<property name="macThreshold" type="java.lang.Long">
<column name="MAC_THRESHOLD" precision="20" scale="5" />
</property>

It doesn't work. I get column MAC_THRESHOLD in table, but it is NUMBER(19), NOT NUMBER(20,5).

I used this:

<property name="macThreshold" type="java.lang.Long">
<column name="MAC_THRESHOLD" sql-type="NUMBER(20,5)" />
</property>

It works. I get column MAC_THRESHOLD in table is NUMBER(20,5), but this way isn't portable.

Any comments would be appreciate.

NUMBER(20,5) in Oracle seems to be a 20-digits number with up to 5 of these 20 being a fractional part.

Having fractional part in DB how do you plan to map it to Long?

So the first thing is to change java.lang.Long to Float or BigDecimal (if you really want the scale part).

I didn't have time (sorry) to check this by running, but my first guess is that not all built-in types support precision and scale attributes, and changing to appropriate java type will fix the situation.

Looking at hibernate's sources might also help - there's a lot of stuff that I failed to find in docs and had to dig from the sources (they are pretty easy to read, thankfully).

BTW, which Dialect are you using fpr oracle 10g?

I used this dialect:

<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>

Is it correct? Thanks again.

Try changing your java type to BigDecimal (leaving presicion and scale in your mapping file) and dialect to Oracle9Dialect.

I don't have Oracle10 dialect in my hibernate package, may be it is already updated on the site.

But why I cannot mapping double type like this?

I don't know why exactly. My best guess is that the Dialect class is written this way.

BigDecimal generates number(x,y) ok. I've just checked.