Re: Error using JDBC2 postgres driver and

>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(at)hotmail(dot)com
Software Engineer
Bensoft, Inc.

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