oracle ora 02290,存储JSON的WebLogic CLOB列-错误ORA-02290

我们正在尝试将JSON字符串保存到定义为CLOB的数据库列中。我们得到以下错误:

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02290: check constraint (MYSCHEMA.MY_JSON_CHK) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)

at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)

版本:

网络逻辑12.2.1.2

在此列的应用程序ORM层上尝试了两种数据类型

java.sql.clob&oracle.jbo.domain.clob domain

通过SQL直接更新很好

启用和禁用

wrapping of datatype

在WebLogic中

JDBC数据源。