Обсуждение: PostgreSQL 7.1.3 - JDBC driver

Поиск
Список
Период
Сортировка

PostgreSQL 7.1.3 - JDBC driver

От
Daniele Arduini
Дата:
Your name               : Daniele Arduini
Your email address      : darduini@cinetica.it

System Configuration
---------------------
   Architecture (example: Intel Pentium)         : Any

   Operating System (example: Linux 2.0.26 ELF)  : Any

   PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3

   Compiler used (example:  gcc 2.95.2)          :

Ant version 1.4 compiled on September 3 2001
java version "1.3.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_01)
Java HotSpot(TM) Client VM (build 1.3.1_01, mixed mode)


Please enter a FULL description of your problem:
------------------------------------------------

Calling

org/postgresql/jdbc2/PreparedStatement.java:setBigDecimal(int parameterIndex, BigDecimal x)

with x == null a "java.lang.NullPointerException" is throw instead of setting the field
to NULL.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

diff -urN jdbc.orig/org/postgresql/jdbc2/PreparedStatement.java
jdbc/org/postgresql/jdbc2/PreparedStatement.java
--- jdbc.orig/org/postgresql/jdbc2/PreparedStatement.java       Fri Feb 16 17:45:00 2001
+++ jdbc/org/postgresql/jdbc2/PreparedStatement.java    Tue Nov 20 12:16:53 2001
@@ -259,7 +259,11 @@
          */
         public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
         {
+           if (x != null) {
                 set(parameterIndex, x.toString());
+           } else {
+               set(parameterIndex, "null");
+           }
         }

         /**



--
Ing. Daniele Arduini <darduini@cinetica.it>
CINETICA - via III settembre, 11 - 47891 Dogana (San Marino)
TEL: (+39) 0549 970848 - FAX: (+39) 0549 970849

Re: PostgreSQL 7.1.3 - JDBC driver

От
Bruce Momjian
Дата:
This is corrected in current sources.  See beta3 or snapshot for the new
code.


---------------------------------------------------------------------------

> Your name               : Daniele Arduini
> Your email address      : darduini@cinetica.it
>
> System Configuration
> ---------------------
>    Architecture (example: Intel Pentium)         : Any
>
>    Operating System (example: Linux 2.0.26 ELF)  : Any
>
>    PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3
>
>    Compiler used (example:  gcc 2.95.2)          :
>
> Ant version 1.4 compiled on September 3 2001
> java version "1.3.1_01"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_01)
> Java HotSpot(TM) Client VM (build 1.3.1_01, mixed mode)
>
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> Calling
>
> org/postgresql/jdbc2/PreparedStatement.java:setBigDecimal(int parameterIndex, BigDecimal x)
>
> with x == null a "java.lang.NullPointerException" is throw instead of setting the field
> to NULL.
>
>
> Please describe a way to repeat the problem.   Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
>
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
> diff -urN jdbc.orig/org/postgresql/jdbc2/PreparedStatement.java
> jdbc/org/postgresql/jdbc2/PreparedStatement.java
> --- jdbc.orig/org/postgresql/jdbc2/PreparedStatement.java       Fri Feb 16 17:45:00 2001
> +++ jdbc/org/postgresql/jdbc2/PreparedStatement.java    Tue Nov 20 12:16:53 2001
> @@ -259,7 +259,11 @@
>           */
>          public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
>          {
> +           if (x != null) {
>                  set(parameterIndex, x.toString());
> +           } else {
> +               set(parameterIndex, "null");
> +           }
>          }
>
>          /**
>
>
>
> --
> Ing. Daniele Arduini <darduini@cinetica.it>
> CINETICA - via III settembre, 11 - 47891 Dogana (San Marino)
> TEL: (+39) 0549 970848 - FAX: (+39) 0549 970849
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026