We have developed a gwt-hibernate multi database application which is running on Glassfish and using Oracle datatabase. After a connection to a default database which is addressed by a default persistence unit like the following:
<persistence-unit name="DefaultDBConnection" transaction-type="RESOURCE_LOCAL"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle8iDialect" /> <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" /> <property name="hibernate.connection.username" value="user" /> <property name="hibernate.connection.password" value="******************" /> <!-- <property name="hibernate.hbm2ddl.auto" value="update" /> --> <property name="hibernate.connection.url" value="jdbc:oracle:thin:@server:1521:orcl" /> <property name="hibernate.show_sql" value="true" /> <!-- <property name="hibernate.format_sql" value="true"/> --> <property name="hibernate.max_fetch_depth" value="3" /> <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider" /> <property name="hibernate.query.plan_cache_max_strong_references" value="8" /> <property name="hibernate.query.plan_cache_max_soft_references" value="16" /> <property name="connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider" /> <property name="hibernate.c3p0.min_size" value="5" /> <property name="hibernate.c3p0.max_size" value="200" /> <property name="hibernate.c3p0.timeout" value="300" /> <property name="hibernate.c3p0.max_statements" value="50" /> <property name="hibernate.c3p0.idle_test_period" value="3000" /> <property name="hibernate.generate_statistics" value="true" /> </properties> </persistence-unit> the database selection is done by the user login through our HibernateGwt class which connects to the proper database through a different persistence unit. The EntityManager to interact with the proper database is then opened-taken by the following instructions in the gwt RemoteServiceServlet: EntityManager session = getSession(); where private javax.persistence.EntityManager getSession() { return HibernateGwt.getInstance().getEntityManager(this); } and "this" is a com.google.gwt.user.server.rpc.RemoteServiceServlet, while private static HibernateGwt singleton = new HibernateGwt(); private HashMap<String,javax.persistence.EntityManagerFactory> factoryCollection = new HashMap<String,javax.persistence.EntityManagerFactory>(); private ThreadLocalUtil entityManagerCollection = new ThreadLocalUtil(); public javax.persistence.EntityManager getEntityManager(Object service) { ThreadLocal myTdl; javax.persistence.EntityManager entityManager; //to get the right persistence name from the user logged in which is stored as a session variable String persistenceUnit = getPersistenceUnit(service); entityManager = (EntityManager) entityManagerCollection.getThreadVariable(persistenceUnit); if (entityManager == null || !entityManager.isOpen()) { entityManager = getFactory(persistenceUnit).createEntityManager(); entityManagerCollection.setThreadVariable(persistenceUnit, entityManager); } return entityManager; } At user logout we close the connection as follow: HibernateGwt.getInstance().close(null); where public void close(String persistenceUnit) { if (persistenceUnit == null) persistenceUnit = getPersistenceUnit(); closeEntityManager(persistenceUnit); if (factoryCollection.containsKey(persistenceUnit)){ javax.persistence.EntityManagerFactory factory = factoryCollection.get(persistenceUnit); if (factory != null) { factory.close(); factory = null; } factoryCollection.remove(persistenceUnit); } } and public void closeEntityManager(String persistenceUnit) { javax.persistence.EntityManager entityManager; if (persistenceUnit == null) persistenceUnit = getPersistenceUnit(); entityManager = (EntityManager) entityManagerCollection.getThreadVariable(persistenceUnit); if (entityManager != null && entityManager.isOpen()) { entityManager.close(); } entityManagerCollection.setThreadVariable(persistenceUnit, null); } Please, can someone help us understand what we are doing wrong to not let Glassfish release resources and fall into a degrade of performace until we restart it? -- You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-web-toolkit+unsubscr...@googlegroups.com. To post to this group, send email to google-web-toolkit@googlegroups.com. Visit this group at http://groups.google.com/group/google-web-toolkit. For more options, visit https://groups.google.com/groups/opt_out.