Re: URGENT: Help with exception - Mailing list pgsql-jdbc

 stmt.execute("Create table "+ tableName +
              "(name text not null, context text not null, filename text
not null, boundary text, " +
              "insertion_time bigint not null, can_purge boolean,
PRIMARY KEY (name, context));");

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Jean-Luc Lachance
Sent: Monday, October 21, 2002 3:54 PM
To: David Hooker
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] URGENT: Help with exception


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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org