ORA-03001:未实施的功能_zzxiaoma

个人资料

微博

正文字体大小：大中小

ORA-03001:未实施的功能

(2018-08-17 22:18:30)

分类： java

Connection connection = null;

try

{

Class.forName("oracle.jdbc.driver.OracleDriver")

.newInstance();

String url = "jdbc:oracle:thin:@localhost:1521:orcl";

String userName = "sa";

String password = "sa";

connection = DriverManager.getConnection(url, userName,password);

String sql = "insert into a(ids) values ?";

PreparedStatement preparedStatement = connection.prepareStatement(sql);

for (int i = 0; i <105 ; i++) {

preparedStatement.setInt(1, i);

preparedStatement.addBatch();

}

preparedStatement.executeBatch();

} catch (Exception ex)

{

System.out.println(ex.getMessage());

} finally

{

connection.close();

}

一个批量插入提示ORA-03001: 未实施的功能，原来sql有问题，应该是

String sql = "insert into a(ids) values (?)";

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report