Re: Error using JDBC2 postgres driver and DatabaseMetaData.getTables()

> > java.sql.SQLException: ERROR: parser: parse error at or near ")"
>
>It's hard to tell from this exactly what the parser is complaining
>about. I'd suggest turning on query logging (debug_print_query) and
>then a look in the postmaster log should show the exact text of the
>query the parser is unhappy with. If that doesn't yield immediate
>enlightenment, send it along and we'll see what we can do.

I turned on all of the logging that I could find. Here is the excerpt
from my postgresql.conf file:

//----- BEGIN CONF FILE -----//
debug_level = 4 # range 0-16

debug_print_query = true
debug_print_parse = true
debug_print_rewritten = true
debug_print_plan = true
debug_pretty_print = true
//---- END CONF FILE -----//

Running the same program again under the exact same conditions yielded
the same error and the following entry in the file I directed the startup
script to log to:

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

postmaster successfully started
/usr/bin/postmaster: PostmasterMain: initial environ dump:
-----------------------------------------
PWD=/var/lib/pgsql
XAUTHORITY=/root/.xauth45pP3j
HOSTNAME=localhost.localdomain
QTDIR=/usr/lib/qt3-gcc2.96
LESSOPEN=|/usr/bin/lesspipe.sh %s
USER=postgres

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;
32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zi
p=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xb
m=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/postgres
INPUTRC=/etc/inputrc
LANG=en_US
DISPLAY=:0.0
LOGNAME=postgres
SHLVL=2
SHELL=/bin/sh
HISTSIZE=1000
TERM=xterm
HOME=/var/lib/pgsql
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
PGDATA=/var/lib/pgsql/data
PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin
_=/usr/bin/postmaster
-----------------------------------------
FindExec: found "/usr/bin/postgres" using argv[0]
invoking IpcMemoryCreate(size=1417216)
FindExec: found "/usr/bin/postmaster" using argv[0]
2002-08-19 21:35:57 [2331] DEBUG: database system was shut down at
2002-08-19 00:51:35 CDT
2002-08-19 21:35:57 [2331] DEBUG: checkpoint record is at 0/402372C
2002-08-19 21:35:57 [2331] DEBUG: redo record is at 0/402372C; undo
record is at 0/0; shutdown TRUE
2002-08-19 21:35:57 [2331] DEBUG: next transaction id: 51691; next oid:
66197
2002-08-19 21:35:57 [2331] DEBUG: database system is ready
2002-08-19 21:35:57 [2331] DEBUG: proc_exit(0)
2002-08-19 21:35:57 [2331] DEBUG: shmem_exit(0)
2002-08-19 21:35:57 [2331] DEBUG: exit(0)
2002-08-19 21:35:57 [2327] DEBUG: reaping dead processes
2002-08-19 21:36:19 [2327] DEBUG: BackendStartup: forked pid=2349
socket=8
2002-08-19 21:36:19 [2349] DEBUG: connection: host=127.0.0.1 user=bmadmin
database=bmstore
/usr/bin/postmaster child[2349]: starting with (postgres -d4 -v131072 -p
bmstore )
2002-08-19 21:36:19 [2349] DEBUG: InitPostgres
2002-08-19 21:36:19 [2349] DEBUG: StartTransactionCommand
2002-08-19 21:36:19 [2349] 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 21:36:19 [2349] DEBUG: parse tree:
{ QUERY

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

This doesn't really mean much to me. I hope this helps.

Let me know if I need to tweak the debug settings.

Thanks,
Andrew Lee
alee585(at)hotmail(dot)com
Software Engineer
Bensoft, Inc

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com