
jdbc
kyle凯尔
妈咪妈咪哄
展开
-
JDBC各个数据库 连接字符串
1. MySQL(http://www.mysql.com) mysql-connector-java-2.0.14-bin.jar ; Class.forName( "org.gjt.mm.mysql.Driver" ); com.mysql.jdbc.Driver cn = DriverManager.getConnection( "jdbc:mysql://MyDbCompute...原创 2012-04-11 17:19:44 · 131 阅读 · 0 评论 -
Can't start a cloned connection while in manual transaction mode
Can't start a cloned connection while in manual transaction mode 为了保证多个sql全部执行成功后再提交,执行以下语句 conn.setAutoCommit(false); 然后执行多个执行语句后 conn.commit(); 出现Can't start a cloned connection while i...原创 2012-04-17 17:20:28 · 128 阅读 · 0 评论 -
处理超出打开游标的最大数异常(ORA-01000: maximum open cursors exceeded)
在执行如下代码时,经常会出现ora-01000: maximum open cursors exceeded异常for(int i=0;i<balancelist.size();i++){ prepstmt = conn.prepareStatement(sql[i]); prepstmt.setBigDecimal(1,nb.getRealCost()); pr...原创 2012-10-11 19:43:08 · 170 阅读 · 0 评论