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

【标题描述】:
【兼容性】jdbc调用存储过程注册出参为char，但数据库返回类型为varchar，出现了error报错
![输入图片说明](https://foruda.gitee.com/images/1699931428055827352/3abd93b4_9807173.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1699931463659825650/7e733f2b_9807173.png "屏幕截图")

具体测试用例：

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

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

// get result set
            Object pa = cmt.getObject(1);
            String pb = cmt.getString(2);
            long pc = cmt.getLong(3);
            assertEquals(null, pa);
            assertEquals("out1", pb);
            assertEquals(1020, pc);
        } finally {
            TestUtil.closeQuietly(stmt);
            TestUtil.closeQuietly(cmt);
        }
    }
```

openGauss/openGauss-connector-jdbc

内容风险标识

评论 (4)

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

内容风险标识