Quarkus中的Oracle数据库响应返回一串数字

Question

606578838769828362103232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232326065788783698295838465848583627975604765788783698295838465848583621032323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323260657883876982839583698462103232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323260657883876982476210323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232604765788387698283958369846210323232323232323232323232323232323232323232323232323232323232323232323232323232323232323260476578838769828362

起初，我假设每个字符代码是两个数字长。然而，其他回复也包含字符代码超过100的字母。

使用2字符代码的假设，我可以解析上述响应：

<ANSWERS>
                                                <ANWSER_STATUS>OK</ANWSER_STATUS>
                                                <ANSWERS_SET>
                                                    <ANSWER/>
                                                </ANSWERS_SET>
                                            </ANSWERS>

quarkus.datasource.db-kind=oracle
quarkus.datasource.username=${DB_USERNAME:username}
quarkus.datasource.password=${DB_PASSWORD:password}
quarkus.datasource.jdbc.url=jdbc:oracle:thin:@//${DB_HOST:dbhost}:${DB_PORT:1521}/${DB_NAME:dbname}

@Singleton
public class DatabaseCommunicator {

    @Inject
    AgroalDataSource dataSource;

    private static final String QUERY = "{ ? = call abc.SOME_WORDS.STORED_PROCEDURE_NAME(?) }";
    
    public Object getDetails(String objectId) {
        String resultString;

        try (Connection connection = dataSource.getConnection(); CallableStatement statement = connection.prepareCall(QUERY)) {
            String queryBody = "<objectId>" + objectId + "</objectId>";

            statement.setString(2, queryBody);
            statement.registerOutParameter(1, Types.CLOB);

            statement.execute();

            Clob resultClob = statement.getClob(1);
            resultString = readClob(resultClob); // Value of this String is the long number string.
        } catch (SQLException | IOException ex) {
            throw new DatabaseException("Exception while communicating with database", ex);
        }

        return resultString;
    }

    private String readClob(Clob input) throws IOException, SQLException {
        InputStream stream = input.getAsciiStream();

        StringBuilder buffer = new StringBuilder();
        int character = stream.read();

        while (character != -1) {
            buffer.append(character);
            character = stream.read();
        }

        return buffer.toString();
    }
}

[...]
    <dependency>
      <groupId>io.quarkus</groupId>
      <artifactId>quarkus-agroal</artifactId>
    </dependency>
    <dependency>
      <groupId>io.quarkus</groupId>
      <artifactId>quarkus-jdbc-oracle</artifactId>
    </dependency>
    <dependency>
      <groupId>com.oracle.database.nls</groupId>
      <artifactId>orai18n</artifactId>
    </dependency>
    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc11</artifactId>
    </dependency>
[...]

Answer 1

我希望JDBC驱动程序能够自动解码来自数据库的响应。然而，事实证明这并没有发生。

相反，我在JDBC驱动程序中找到了相关代码，帮助我自己解码它。为此，我使用了作为Quarkus BOM一部分的quarkus-jdbc-oracle依赖项：

    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc11</artifactId>
    </dependency>

然后，我使用驱动程序中已经存在的内置解码逻辑将数字字符串转换为我可以使用的内容：

import static oracle.sql.CharacterSet.WE8ISO8859P15_CHARSET;

import oracle.sql.converter.CharacterConverterFactoryJDBC;
import oracle.sql.converter.JdbcCharacterConverters;


class Example {
    private String readClob(Clob input) throws IOException, SQLException {
        InputStream stream = input.getAsciiStream();

        CharacterConverterFactoryJDBC converter = new CharacterConverterFactoryJDBC();
        JdbcCharacterConverters converters = converter.make(WE8ISO8859P15_CHARSET);

        byte[] bytes = stream.readAllBytes();
        return converters.toUnicodeString(bytes, 0, bytes.length);
    }
}