Re: Error using JDBC2 postgres driver and DatabaseMetaData.getTables() - Mailing list pgsql-jdbc

> > 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@hotmail.com
Software Engineer
Bensoft, Inc

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