From: <glassfish_at_javadesktop.org>
Date: Wed, 11 Feb 2009 03:09:06 PST

To know about ping-connection-pool :
You can refer GlassFish asadmin commands reference manual :
http://docs.sun.com/app/docs/doc/819-3675/6n5slue6r?a=expand

You can do :
asadmin> ping-connection-pool post-gre-sql_catalog_postgresPool

and see the exceptions in server.log if it fails.

For log levels, you can refer :
http://docs.sun.com/app/docs/doc/819-4733/abluj?l=en&q=setting+log+levels&a=view

To set log-levels,
* access admin console (localhost:4848)
* LHS > Application Server
* RHS > Logging > LogLevels
and set appropriate log-level for the modules (connector) in question



org.postgresql.util.PSQLException: ERROR: syntax error at or near "null"

is the exception seen which is from Postgres Server. Probably your SQL syntax is incorrect.
[Message sent by forum member 'jr158900' (jr158900)]

http://forums.java.net/jive/thread.jspa?messageID=331245