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. Main thing is to know exactly what the database is presented after a GUI click. Very likely that this is more of a Hibernate question but I assume the same desire has been satisfied in some way by this audience. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match