为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:windows 10
【CPU】:
【问题描述】*:
驱动执行报错,但是DmManager执行语句,正常修改不报错
@Test
public void testModifyEMPLOYEE() throws SQLException {
Connection conn = driverDynamicManager.getConnection(connectId);
Assert.assertNotNull("连接为空", conn);
String sql = "select * from (SELECT \"EMPLOYEE_ID\",\"EMPLOYEE_NAME\",\"IDENTITY_CARD\",\"EMAIL\",\"PHONE_NUM\",\"HIRE_DATE\",\"JOB_ID\",\"SALARY\",\"COMMISSION_PCT\",\"MANAGER_ID\",\"DEPARTMENT_ID\" FROM \"DMHR\".\"EMPLOYEE\") aa where EMPLOYEE_ID=1001 ";
PreparedStatement statement =null;
try {
statement = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
statement.setMaxRows(100);
ResultSet resultSet = statement.executeQuery();
resultSet.absolute(1);
resultSet.updateObject(2, "马学铭1");
resultSet.updateRow();
} catch (SQLException e) {
e.printStackTrace();
}finally {
statement.close();
}
}
后面 , ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE 去掉还会报错不
用的是数据库自带的驱动吗?数据库自带的驱动在软件安装目录./dmdbms/driver下面