URGENT: Help with exception

From: "David Hooker" <dhooker(at)a4networks(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: URGENT: Help with exception
Date: 2002-10-21 19:24:39
Message-ID: 000b01c27937$802696d0$6901a8c0@dhooker
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 -

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message john guthrie 2002-10-21 19:35:07 Re: Trouble connecting
Previous Message Florian Wunderlich 2002-10-21 17:06:30 AbstractJdbc1DatabaseMetaData.getColumns doesn't set DECIMAL_DIGITS