PreparedStatement rounds doubles to scale 14 during update

Поиск
Список
Период
Сортировка
От Peter Kovacs
Тема PreparedStatement rounds doubles to scale 14 during update
Дата
Msg-id b6e8f2e80709050227r420d7a3cx751f819fba658854@mail.gmail.com
обсуждение исходный текст
Ответы Re: PreparedStatement rounds doubles to scale 14 during update  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-jdbc
Hi,

I have the following problem with postgresql-8.1-407.jdbc3.jar used
against a 8.1 version backend.

A table "chemterms_cols_test" has a column "logp" defined as:

logp numeric(30,17)

The double value 6.118992224252588 gets rounded to 6.11899222425259000
during updates with PreparedStatements using place-holder. (There is
no rounding with Statement and the value specified in the SQL
literally.) Is this the expected behaviour?

Below is the code that can be used to test this behaviour ("cd_id" is
the primary key):

    public static void main(String[] args) {
        try {
            Connection conn = DBTools.getConnectionHandler().getConnection();
            conn.setAutoCommit(false);

            int cdId = 1;
            double dblValue = 6.118992224252588;

            String sql =
                    "update chemterms_cols_test set logp = ? where cd_id = ?";
            try {
                PreparedStatement pstmt = conn.prepareStatement(sql);
                try {
                    pstmt.setDouble(1, dblValue);
                    pstmt.setInt(2, 1);
                    pstmt.executeUpdate();
                    conn.commit();
                } finally {
                    pstmt.close();
                }

                ResultSet rs = null;
                sql = "select logp from chemterms_cols_test where cd_id = ?";
                pstmt = conn.prepareStatement(sql);
                try {
                    pstmt.setInt(1, 1);
                    rs = pstmt.executeQuery();
                    rs.next();
                    double actual = rs.getDouble(1);
                    System.out.println("actual=" + actual + ", expected="
                            + dblValue + ", equals? : " + (actual == dblValue));

                } finally {
                    try {
                        if (rs != null) {
                            rs.close();
                        }
                    } finally {
                        pstmt.close();
                    }
                }
            } finally {
                conn.close();
            }
        } catch (Throwable tbl) {
            tbl.printStackTrace();
            System.exit(1);
        }
    }

Thanks
Peter

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: [JDBC] Questión of JDBC
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: PreparedStatement rounds doubles to scale 14 during update