向各位请教一个问题:向oracle的clob中插入大文本的时候,我用preparedStatement的setObject()方法设置要插入的长字符串,报jdbc异常,似乎对长度由限制,数据库是oracle9i,驱动换了很多个试了,仍然有问题,大家遇到类似问题没有?谢谢关注!
- java.sql.SQLException: 数据大小超出此类型的最大值: 5299
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2413)
at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1166)
at oracle.jdbc.driver.OraclePreparedStatement.setCharacterStream(OraclePreparedStatement.java:3752)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setCharacterStream(DelegatingPreparedStatement.java:174)