Re: Error using JDBC2 postgres driver and - Mailing list pgsql-jdbc

>The driver is expecting the table type to be all upper case,
Changed:
String [] tableTypes = { "Table" };
To:
String [] tableTypes = { "TABLE" };

Still got the same error message and log entry as previously posted.

>If you use the dev driver it will also accept null for all the args
I tried the dev driver with all null values and got the log file entry
posted below. I snipped out the lenghty parse trees. I can provide those
too if it would help.

Note: The dev driver I am referring to is the 7.3dev driver located at
      http://jdbc.postgresql.org/dowload/devpgjdbc2.jar dated 2002-07-16.

//----- BEGIN LOG FILE -----//

2002-08-19 22:15:57 [2327]   DEBUG:  child process (pid 2621) exited with
exit code 0
2002-08-19 22:20:15 [2327]   DEBUG:  BackendStartup: forked pid=2728
socket=8
2002-08-19 22:20:15 [2728]   DEBUG:  connection: host=127.0.0.1 user=bmadmin
database=bmstore
/usr/bin/postmaster child[2728]: starting with (postgres -d4 -v131072 -p
bmstore )
2002-08-19 22:20:15 [2728]   DEBUG:  InitPostgres
2002-08-19 22:20:15 [2728]   DEBUG:  StartTransactionCommand
2002-08-19 22:20:15 [2728]   DEBUG:  query: set datestyle to 'ISO'; select
version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN'
else getdatabaseencoding() end;
2002-08-19 22:20:15 [2728]   DEBUG:  parse tree:

[snip parse tree]

2002-08-19 22:20:15 [2728]   DEBUG:  rewritten parse tree:

[snip rewritten parse tree]

2002-08-19 22:20:15 [2728]   DEBUG:  ProcessUtility: set datestyle to 'ISO';
select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then
'UNKNOWN' else getdatabaseencoding() end;
2002-08-19 22:20:15 [2728]   DEBUG:  parse tree:

[snip parse tree]

2002-08-19 22:20:15 [2728]   DEBUG:  rewritten parse tree:

[snip rewritten parse tree]

2002-08-19 22:20:15 [2728]   DEBUG:  ProcessQuery
2002-08-19 22:20:15 [2728]   DEBUG:  CommitTransactionCommand
2002-08-19 22:20:15 [2728]   DEBUG:  StartTransactionCommand
2002-08-19 22:20:15 [2728]   DEBUG:  query: select relname,oid,relkind from
pg_class where () and relname like '%' order by relkind, relname
2002-08-19 22:20:15 [2728]   ERROR:  parser: parse error at or near ")"
2002-08-19 22:20:15 [2728]   DEBUG:  AbortCurrentTransaction
2002-08-19 22:20:15 [2728]   DEBUG:  pq_recvbuf: unexpected EOF on client
connection
2002-08-19 22:20:15 [2728]   DEBUG:  proc_exit(0)
2002-08-19 22:20:15 [2728]   DEBUG:  shmem_exit(0)
2002-08-19 22:20:15 [2728]   DEBUG:  exit(0)
2002-08-19 22:20:15 [2327]   DEBUG:  reaping dead processes
2002-08-19 22:20:15 [2327]   DEBUG:  child process (pid 2728) exited with
exit code 0
2002-08-19 22:20:57 [2734]   DEBUG:  proc_exit(0)
2002-08-19 22:20:57 [2734]   DEBUG:  shmem_exit(0)
2002-08-19 22:20:57 [2734]   DEBUG:  exit(0)
2002-08-19 22:20:57 [2327]   DEBUG:  reaping dead processes
2002-08-19 22:20:57 [2327]   DEBUG:  child process (pid 2734) exited with
exit code 0

//----- END LOG FILE -----//

Thanks,
Andrew Lee
alee585@hotmail.com
Software Engineer
Bensoft, Inc.


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx