is there any troubles with mapping types in Oracle 10?

nattaly · **Joined:** Tue Mar 20, 2007 9:37 pm **Posts:** 1

Hello People:

I need some help with mapping hibernate types in Oracle 10. I have problems with Long and Blob types.

Thanks for your help.
Regards

dharmendra.pandey · **Posted:** Wed Mar 21, 2007 2:37 am

Hi nattaly,

You could map Long with long in HBM .I didn't find any problem in 10 g for long.For Blob i am not sure.Send us Exception what you are getting might help us.

smlghst · **Joined:** Sat Mar 03, 2007 3:14 am **Posts:** 16

I'dont now how to map a simple Float java field into Oracle Number or BinaryFloat.
Exmaple:
<c;lass>..
.. . ..
<property name="floatnumber" type="float">
<column name="FLOATNUMBER" />
</property>
. .. ..
</class>
the following error throw while SessionFactory is create:

Wrong column type: FLOATNUMBER, expected: float

Please maybe it was a stupid question, but now i dont now the answer ..
Thanks ..
Bye

ryang5 · **Posted:** Wed Mar 21, 2007 10:01 pm

I have a similar problem. My oracle datatype is Number (4,1) but I want to map it to double type in java.

<property name="OneDoubleProperty" type="double">
<column name="OneDoubleProperty" sql-type="Number(4,1)" />
</property>

It gave me an error.
I also tried <column name="OneDoubleProperty" sql-type="Number" precision="4" scale="1" />
It does not work either.

Help please.

Thanks.

dharmendra.pandey · **Posted:** Wed Mar 21, 2007 11:34 pm

Hi ryang5,

Try

<property name="OneDoubleProperty" type="double" column="OneDoubleProperty" />

that might work,not sure.