oracle clob 报错,使用SerialClob插入oracle超出4000报错

For example:> "INSERT INTO PICTURE_INFO(RECORD_NO,XML_INFO,PARTITION_DATE,REP_FLAG,GUID_REP_ID) VALUES('20180720218479','*Clob(-124089469)','2018-12-27 15:52:02','1','*Blob(hascode=-1038463715)') "

2019-03-06 15:17:52,275 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException

java.sql.SQLException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值

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

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

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

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

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

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

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

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

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

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

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)

at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)

at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:308)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)

at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)

at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)

at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)

at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)

at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:248)

at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)

at org.nutz.dao.impl.NutDao.fastInsert(NutDao.java:189)

at org.nutz.dao.impl.NutDao.insert(NutDao.java:136)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值