URGENT: Help with exception - Mailing list pgsql-jdbc

From David Hooker
Subject URGENT: Help with exception
Date
Msg-id 000b01c27937$802696d0$6901a8c0@dhooker
Whole thread Raw
List pgsql-jdbc
Hi all-

I'm seeing an un-explainable exception.  I've been trying to track this
down for 4 days with no results.  The exception I see is:

java.lang.NullPointerException

        at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
        at org.postgresql.Connection.ExecSQL(Connection.java:398)

        at org.postgresql.jdbc2.Statement.execute(Statement.java:130)

        (... More stuff ...)


My code looks like this:
            String sql = "INSERT INTO " + tableName + " values('" + name
+ "', '" + context +
                        "', '" + docFile.toURI().toString() +
                         "', '" + event.getBoundary() + "', '" +
System.currentTimeMillis() + "', false);";
            logger.finest("SQL: " + sql);
            Statement stmt = conn.createStatement();
            stmt.execute(sql);
            stmt.close();

The string that is logged looks like this:
SQL: INSERT INTO lfs_mappings values('1587313:4', 'Delivery',
'file:/home/dhooker/andrew/tests/btradeTrial/bin/DeliveryDocs/LFS57787.D
AT', '"----=_Part_1_14115383.1035227913496"', '1035227913542', false);


There are no error messages on the backend when I run it with -d 3 or -d
4.

I'm using PostgreSQL 7.1.3 as the server, and the latest pgjdbc2.jar
file from the website downloads area.  I'm running Java:
  java version "1.4.0"
  Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.0-b92)
  Java HotSpot(TM) Server VM (build 1.4.0-b92, mixed mode)

...on RedHat Linux 7.2, kernel 2.4.7-10.

ANY and ALL insight, tips, hints, and guesses are appreciated!!!

Also, if someone can tell me how to get the source code that corresponds
to the jar file, that would be nice.  Thanks.

- David Hooker -
- Sr. Software Architect -
- A4 Networks Corp. -
- dhooker at a4networks.com -



pgsql-jdbc by date:

Previous
From: Florian Wunderlich
Date:
Subject: AbstractJdbc1DatabaseMetaData.getColumns doesn't set DECIMAL_DIGITS
Next
From: "Fernando Papa"
Date:
Subject: how to catch returned refcursor from a fuction