All,
We have an ORCL database table with 2 VARCHAR2(2500) columns. These columns are mapped to "String" in hibernate cfg xml. We use Oracle 10g driver.

When we insert a row with the value for BOTH columns containing more than 1000 characters, we get the following exception :
ORA-01461: can bind a LONG value only for insert into a LONG column

However, if the row contains only one column data with value more than 1000 characters, the insert succeeds.

Does Hibernate map to ORCL LONG for VARCHAR2 columns when data > 1000 characters ?
Seems like when Hibernate maps to LONG for both columns, it hits the ORCL limitation that only one LONG col is allowed per row.

Has anybody encountered this issue ?

If so, what are the suggested fixes ?

Thanks !