Does anyone know what the oracle Oracle 10g type-mapping for CLOB would be .reveng.xml or at least tell me how I can figure it out?

TIA,

find out what the type code is when returned from the jdbc metadata and use that number in the sql-type field.

Hi max, thanks for your quick reply. But I'm a bit green still and would not know how to:



...to give you a bit more info. i'm trying to use hibernate-tools to run the hbm2java ant task and i'm getting the "java.lang.Object spans multiple columns" exception and I think its because of a CLOB field I'm using. So I think if I could find the correct



line it will resolve the issue. But this is my first step in using hibernate to do anything substantial. So could you please give me a bit more detail or point me in the right direction? Your help is much appreciated.

TIA,
[/quote]

I would put BLOB or CLOB in the sql-type and text/binary or whatever you want it mapped to (read about that in the hibernate docs)

If it doesn't fit then you will need to find out which java.sql.Types constant it is actually mapped to ?

/max