【兼容性】jdbc调用存储过程注册出参为double，但数据库返回类型为NUMERIC，出现报错

【标题描述】:
【兼容性】jdbc调用存储过程注册出参为Types.DOUBLE，但数据库返回类型为Types.NUMERIC时，实际的数据库字段类型为Number(19，3)，出现了error报错。
![输入图片说明](https://foruda.gitee.com/images/1699932018192531981/a57d7406_9807173.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1699932052065466730/cc843a33_9807173.png "屏幕截图")

具体测试用例：

```
    @Test
    public void testSpOutDouble() throws SQLException {
        Statement stmt = null;
        CallableStatement cmt = null;
        try {
            // create sp
            String procedureSql = "create or replace procedure test_sp_out_double(\n" +
                    "\t pa in int4,\n" +
                    "\t pb out numeric,\n" +
                    "\t pc out int8)\n" +
                    "IS \n" +
                    "begin \n" +
                    "pb := 2.22; \n" +
                    "pc := pa + 1024; \n" +
                    "end;";
            stmt = con.createStatement();
            stmt.execute(procedureSql);

// execute sp
            String commandText = "{call test_sp_out_double(?, ?, ?)}";
            cmt = con.prepareCall(commandText);
            cmt.setInt(1, 1024);
            cmt.registerOutParameter(2, Types.DOUBLE);
            cmt.registerOutParameter(3, Types.BIGINT);
            cmt.execute();

// get result set
            Object pa = cmt.getObject(1);
            double pb = cmt.getDouble(2);
            long pc = cmt.getLong(3);
            assertEquals(null, pa);
            assertEquals(2.22d, pb, 0.0001d);
            assertEquals(2048, pc);
        } finally {
            TestUtil.closeQuietly(stmt);
            TestUtil.closeQuietly(cmt);
        }
    }
```

openGauss/openGauss-connector-jdbc

内容风险标识

评论 (4)

openGauss/openGauss-connector-jdbc .gitee-modal { width: 500px !important; }

内容风险标识