jdbc - Glassfish 2.1 never reuses statements with Postgresql and Eclipselink? -
we using glassfish server 2.1 eclipselink jpa 2.1 , connect postgresql database 8.4.8. problem in log file of postgres see prepare of statements created em.createquery or em.createnamedquery. seems no statement has been prepared reused. therefore performance bad. i tried setting default jdbc setting preparethreshold 5 1. changed unnamed statements named. still not reused. i tried several settings connection pooling prepared statements connection dependent returned default org.postgresql.ds.pgsimpledatasource , javax.sql.datasouce. i enabled statement caching in persistence.xml: <property name="eclipselink.jdbc.cache-statements" value="true"/> does glassfish 2.1 support statement caching? , if settings missed? any hints appreciated. considering this: http://www.youtube.com/watch?v=hfx_m0p0kom seems 2.1 not support statement caching.