注册

求解。报错无效的游标名[DM7CUR0]

奋斗的小淼 2024/11/27 306 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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();
        }
    }

image.png

回答 0
暂无回答
扫一扫
联系客服