Hibernate Type for Orace Long Type?

mohitgupta_india · **Posted:** Wed Mar 03, 2004 3:22 am

We want to map one of our bean property with Oracle Long type, but could not find any compatible Hibernate type for it to mention in Hibernate Mapping File.

We also go through the class docmentation of Hibernate for various types, but there is no type mapped with Oracle.Long.

Please tell what type should be used for this requirement? It is urgent.

michael · **Posted:** Wed Mar 03, 2004 5:12 am

type="java.lang.Long" ?

mohitgupta_india · **Posted:** Wed Mar 03, 2004 5:17 am

Michael, if we use type = long in mapping file then Hibernate creates a number type of column in oracle db, but we want Long type column. like:

<property name="definition_Long" column="definition" type="long"/>

Now hibernate schema export tool will create a column of type Number. So what type should we give here to map it with DB. Long?

michael · **Posted:** Wed Mar 03, 2004 5:23 am

Try working with the sql-type attribute, see here http://www.hibernate.org/hib_docs/reference/html/toolsetguide.html#toolsetguide-s1-2 - never used Oracle so I can't tell you the exact solution, probably someone else?

mohitgupta_india · **Posted:** Wed Mar 03, 2004 5:48 am

Thanks Michael. I got the solution from link given by you. sql-type tag is working.

michael · **Posted:** Wed Mar 03, 2004 5:53 am

What is the solution? :)

mohitgupta_india · **Posted:** Thu Mar 04, 2004 3:42 am

Michael, soln is :

<property name="definition_long" type="long">
<column name="definition" sql-type="long"/>
</property>

It created Long column in database.