Hello,

I want to map bean's string proeperty to db long column. Use case is:

We have large data as string property in a java bean. And we want to save it in a long column in database.

This can be achieved using clob type. But our existing system has support for long data type in db using JDBC, so we want to support the existing schema. This can be achieved using JDBC, by using statement.setCharacterStream, we can save string data as Long in oracle db.

But I am not getting the way to implement this using Hibernate. As I am finding no way to convert string to long, so that can map it with long type of db.

waiting for suggestion, it is urgent.

Thanks

Use a custom UserType. There are various examples for mapping blobs in the wiki area.

Or just use type="text" for the property.

Thanks Michael, but this would need clob type field in database to map this property using "text". But our requirement is that we want to maintain "Long" field in database and want to map it with String property.
Like:

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

As I wrote earlier, that this can be achieved using JDBC statement interface, now need help to implement it using Hibernate.

I don't get what your problem is. I think "type=text" is exactly what you should use. Otherwise, use a custom UserType, you can do pretty much anything there. Take a look at the wiki area and the sources in net.sf.hibernate.type