PostgreSQL 7.1.3 - JDBC driver - Mailing list pgsql-bugs

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