CLOB : ORA-01461: can bind a LONG value only for insert into a LONG column

Question

I am getting this error for Clob datatype in table. The String content I am trying to store as clob is more than 4K for sure (around 190KB). I am using JPA in spring app.

Consider responseObj is a JSONObject with 190K of data.

Clob errorResponse = new javax.sql.rowset.serial.SerialClob(responseObj.toString().toCharArray());                 
errorResponse.setString(1L,responseObj.toString());

int rowsInserted = errorRepository.insertEfileErrorLogRequest(responseObj.getString("key"), Short.parseShort(year), errorResponse);

ErrorRepository.insertErrorLogRequest()

    @Modifying
@Query(value="INSERT INTO ERRORLOG " +
        "(KEY,YEAR,ERROR_CLOB,TIMESTAMP) " +
        "VALUES " +
        "(?1,?2,
        "TO_CLOB(?3),SYSTIMESTAMP)",nativeQuery = true)
int insertErrorLogRequest(String key, short year, Clob errorResponse) throws SQLException, DataAccessException;

There is no long column in the database table. I am getting ORA-01461: can bind a LONG value only for insert into a LONG column

I am using Oracle 11g & ojdbc14 maven dependency

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc14</artifactId>
    <version>10.2.0.4.0</version>
</dependency>

Possible duplicate to https://stackoverflow.com/questions/9156019/ora-01461-can-bind-a-long-value-only-for-insert-into-a-long-column-occurs-when — Marmite Bomber, Feb 26 '18 at 20:47
Pls show the DDL of the `ERRORLOG` table. What ist the DATATYPE of `ERROR_CLOB`? — Marmite Bomber, Feb 26 '18 at 20:50
@JeandeLavarene : I have upgraded the driver to ojdbc6 11.1.0.7.0 But still same error. — Jaivik, Feb 27 '18 at 14:23
This would have worked with Oracle 12c where the limit of a VARCHAR is 32k and the driver would have been able to send your error message as a VARCHAR directly. In your case the driver is trying to send the data as a LONG because it's larger than 4k. A simple option is to use the LONG type instead of CLOB for your ERROR_CLOB column. — Jean de Lavarene, Feb 27 '18 at 17:26

CLOB : ORA-01461: can bind a LONG value only for insert into a LONG column

0 Answers0