From: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
---|---|
To: | David Hooker <dhooker(at)a4networks(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: URGENT: Help with exception |
Date: | 2002-10-21 20:54:08 |
Message-ID: | 3DB46970.ECE9F243@nsd.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Hooker | 2002-10-21 20:54:09 | Re: URGENT: Help with exception |
Previous Message | Fernando Papa | 2002-10-21 19:43:12 | how to catch returned refcursor from a fuction |