起各位大哥指教一下我在mysql里建了两个表stock和stocktype,并且键了外健关联CONSTRAINT `stock_ibfk_1` FOREIGN KEY (`typeId`) REFERENCES `stocktype` (`id`) ON DELETE CASCADE ON UPDATE CASCADEmysql是不是有外健关联的表就不能够用下面的写法
conn.setAutoCommit(false);
Statement pstm = conn.createStatement();
pstm.addBatch("delete from stocktype where id = 3");
pstm.addBatch("delete from stocktype where id = 4");
pstm.executeBatch();
conn.commit();
conn.setAutoCommit(true);
报错
java.sql.SQLException: Not implemented
at org.gjt.mm.mysql.Statement.addBatch(Statement.java:849)
at cn.ben.ado.stock.stockTypeAdo.deleteType(stockTypeAdo.java:200)
at cn.ben.ado.stock.stockTypeAdo.main(stockTypeAdo.java:236)
conn.setAutoCommit(false);
Statement pstm = conn.createStatement();
pstm.addBatch("delete from stocktype where id = 3");
pstm.addBatch("delete from stocktype where id = 4");
pstm.executeBatch();
conn.commit();
conn.setAutoCommit(true);
报错
java.sql.SQLException: Not implemented
at org.gjt.mm.mysql.Statement.addBatch(Statement.java:849)
at cn.ben.ado.stock.stockTypeAdo.deleteType(stockTypeAdo.java:200)
at cn.ben.ado.stock.stockTypeAdo.main(stockTypeAdo.java:236)
解决方案 »
- SSH中如何处理事务回滚的问题。
- 从另一个网页向百度文本框传值!
- spring Quartz定时调度问题?
- 关于安装TOMCAT6.0,菜鸟求教,大家一定要帮我
- jasperreport 打印打及印预览功能如何实现???
- 高手来救命!配置虚拟主机
- jsp如何将表单数据数据保存成本地.txt和excel文件.
- 作程序员真不容易啊!!
- 大家进来讨论下都是怎么保存本机代码版本的用VSS还是winCVS呢,虚心向大家学习
- 救命呀,救命啊,快死了大侠快进来呀~~~~~~~~~~~
- 急!100分求:点击radio button将按钮后面的数据传到目的地网页。等回复
- 用JXL包读出了Excel文件的内容了,如何放到数据库???
驱动太老了。好像不支持批处理吧。
那两个表我是做了级联删除更新的“ON DELETE CASCADE ON UPDATE CASCADE”
它就是不能用addBatch很奇怪!另外问多一个问题我的mysql是版本是4.0.18我使用语句:
SELECT * FROM cx_msg WHERE id IN (SELECT id FROM jb_msg);
报错是我的mysql版本问题吗???
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM jb_msg)' at line 1