Re: URGENT: Help with exception

Which jdbc version?
If 7.2.1, looks like the connection has been closed or garbage
collected...

David Hooker wrote:
>
> 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(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Jean-Luc Lachance
> Sent: Monday, October 21, 2002 3:54 PM
> To: David Hooker
> Cc: pgsql-jdbc(at)postgresql(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)