We are using a three-tier application with J2EE, JBoss, Hibernate and
a Postgres database.
It would be a nice thing to monitor or trace the actual SQL statements
processed by the DB. I do not really need the result set as I can get
this - if required - using SQL against the DB through the Pgsql
interface.
You can configure Postgres to give you this information in the
logfiles, or before you execute any queries on your connection.
The configuration option in postgresql.conf is, I believe,
log_statement.
Alternatively, you can run SET log_statement to 'all'; on your JDBC
connection before your application begins to query the database.
http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html
Hope that helps.
Aurynn Shaw
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly