Skip site navigation (1) Skip section navigation (2)

PostgreSQL 7.1.3 - JDBC driver

From: Daniele Arduini <darduini(at)cinetica(dot)it>
To: pgsql-bugs(at)PostgreSQL(dot)org
Subject: PostgreSQL 7.1.3 - JDBC driver
Date: 2001-11-26 15:11:19
Message-ID: 3C025B97.9090308@cinetica.it (view raw or flat)
Thread:
Lists: pgsql-bugs
Your name               : Daniele Arduini
Your email address      : darduini(at)cinetica(dot)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(at)cinetica(dot)it>
CINETICA - via III settembre, 11 - 47891 Dogana (San Marino)
TEL: (+39) 0549 970848 - FAX: (+39) 0549 970849


Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2001-11-26 15:42:14
Subject: Re: Vá: [BUGS] Bug #519: Bug in order b
Previous:From: Tom LaneDate: 2001-11-26 14:52:00
Subject: Re: Vá: [BUGS] Bug #519: Bug in order by clausule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group