Maybe QueryExecutor is barfing at the double quote...
What is the table definition?
David Hooker wrote:
>
> 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 -
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster