Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. SELECT * FROM pg_stat_activity WHERE pid <> pg_backend_pid() ORDER BY backend_start;
  2.  
  3. <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
  4. <non-jta-data-source>java:comp/env/jdbc/source</non-jta-data-source>
  5. <properties>
  6. <property name="hibernate.id.new_generator_mappings" value="true"/>
  7. <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQL94Dialect"/>
  8. <property name="hibernate.connection.release_mode" value="on_close"/>
  9. </properties>
  10.  
  11. <Resource auth="Container"
  12. driverClassName="org.postgresql.Driver"
  13. maxActive="20"
  14. maxIdle="10"
  15. maxWait="-1"
  16. name="jdbc/source"
  17. type="javax.sql.DataSource"
  18. username="postgres" password="postgres"
  19. url="jdbc:postgresql://localhost:5432/source"
  20. removeAbandoned="true"
  21. removeAbandonedTimeout="3"
  22. defaultAutoCommit="true"/>
  23.  
  24. @ManagedBean
  25. @SessionScoped
  26. public class Bean implements Serializable {
  27.  
  28. private EntityManager emRepo;
  29.  
  30. @PreDestroy
  31. public void cleanUp() {
  32.  
  33. emRepo.close();
  34. }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement