NutzCN Logo
问答 新增Blob字段报错
发布于 2793天前 作者 qq_f9f492da 1851 次浏览 复制 上一个帖子 下一个帖子
标签:

org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO T_CRAWLER_Article(articleId,title,url,content,publicTime,getTime,author,moduleId,flag) VALUES(?,?,?,?,?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
|---|-----------------|----------------------------------------------------------|-------------------------|---------------------|---------------------|------|---|---|
| 7 | 一所农民工子弟学校的“足球梦” | http://edu.ts.cn/content/2016-08/03/content_12208961.htm | Blob(hascode=989124275) | 2016-08-03 10:33:26 | 2016-08-04 15:28:42 | 海口日报 | 1 | 0 |
For example:> "INSERT INTO T_CRAWLER_Article(articleId,title,url,content,publicTime,getTime,author,moduleId,flag) VALUES(7,'一所农民工子弟学校的“足球梦”','http://edu.ts.cn/content/2016-08/03/content_12208961.htm','Blob(989124275)','2016-08-03 10:33:26','2016-08-04 15:28:42','海口日报',1,0) "'
PreparedStatement:
'INSERT INTO T_CRAWLER_Article(articleId,title,url,content,publicTime,getTime,author,moduleId,flag) VALUES(?,?,?,?,?,?,?,?,?) '
CaseMessage=Error
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)
at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
at org.nutz.trans.Trans.exec(Trans.java:174)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
at com.carwler.main.FetchProcTrigger.execHttps(FetchProcTrigger.java:84)
at com.carwler.main.FetchProcTrigger.ThreadRun(FetchProcTrigger.java:27)
at com.carwler.tool.ProcTrigger.run(ProcTrigger.java:19)
Caused by: java.sql.SQLException: Error
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1180)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:127)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:68)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setBinaryStream(DruidPooledPreparedStatement.java:816)
at org.nutz.dao.impl.jdbc.BlobValueAdaptor2.set(BlobValueAdaptor2.java:21)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:266)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:82)
... 11 more
Caused by: java.lang.AbstractMethodError: oracle.jdbc.driver.OraclePreparedStatementWrapper.setBinaryStream(ILjava/io/InputStream;J)V
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setBinaryStream(DruidPooledPreparedStatement.java:814)
... 14 more

3 回复

求大神指点问题

@qq_f9f492da 驱动版本太低

来自炫酷的 NutzCN

问题解决了,原来是驱动是5,换成6就可以了

添加回复
请先登陆
回到顶部