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 -