Does Postgres' JDBC driver cache the results of getAutoCommit()?
Per Glassfish 3's docs, I need to know this to determine if I can use auto-commit as my connection-validation-method (versus something else like table and having to pick a table):
Because many JDBC drivers cache the results of auto-commit and meta-data calls, they do not always provide reliable validations. Check with the driver vendor to determine whether these calls are cached or not.
I'm currently using postgresql-9.1-903.jdbc4.jar.