NullPointerException occurs when executing PreparedStatement execute

[codering]

    // NullPointerException
    @Test
    public void testPrepareStatementQuery() throws SQLException {
        String sql = "SELECT number from numbers(100) where number = ?";
        try(PreparedStatement statement  = conn.prepareStatement(sql)) {
            statement.setInt(1, 1);
            ResultSet r = statement.executeQuery();
            r.next();
            Assertions.assertEquals(1, r.getLong("number"));
        }
    }

     // NullPointerException
    @Test
    public void testPrepareStatementExecute() throws SQLException {
        String sql = "SELECT number from numbers(100) where number = ?";
        try(PreparedStatement statement  = conn.prepareStatement(sql)) {
            statement.setInt(1, 1);
            statement.execute();
            ResultSet r = statement.getResultSet();
            r.next();
            Assertions.assertEquals(1, r.getLong("number"));
        }
    }

     //  Not execute
    @Test
    public void testPrepareStatementExecuteUpdate() throws SQLException {
        String sql = "insert into ta values (?)";
        try(PreparedStatement statement  = conn.prepareStatement(sql)) {
            statement.setInt(1, ThreadLocalRandom.current().nextInt(1, 10));
            int result = statement.executeUpdate();
            Assertions.assertEquals(1, result);
        }
    }

These method implementations should follow the PreparedStatement interface definition.

[hantmac]

Hi @codering , thanks for your issue! I will look into it.