URGENT: Help with exception

Поиск
Список
Период
Сортировка
От David Hooker
Тема URGENT: Help with exception
Дата
Msg-id 000b01c27937$802696d0$6901a8c0@dhooker
обсуждение исходный текст
Список pgsql-jdbc
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 -



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Florian Wunderlich
Дата:
Сообщение: AbstractJdbc1DatabaseMetaData.getColumns doesn't set DECIMAL_DIGITS
Следующее
От: "Fernando Papa"
Дата:
Сообщение: how to catch returned refcursor from a fuction