Closed ZoeHuang13 closed 3 years ago
String url = "";
String query = "";
try (Connection conn = DriverManager.getConnection(url)) {
try(Statement stmt = conn.createStatement()) {
stmt.execute("set odps.sql.submit.mode= script");
try (ResultSet rs = stmt.executeQuery(query)) {
while (rs.next()) {
// Handle result set
}
}
}
} catch (SQLException e) {
e.printStackTrace();
}
mybatis,想批量执行sql语句,报错: com.aliyun.odps.OdpsException: Please add put { "odps.sql.submit.mode" : "script"} for multi-statement query in settings. 网络查询看到的都是PyODPS相关的设置,没有看到Java的,请问jdbc连接该如何设置?