postgresql « Connection « JPA Q&A

1. how to close hibernate tools db connections

When developing a new project I often want to re-create the schema to apply any new entities or relationships created. I like using hibernate tools in eclipse, but it's a pain ...

2. Postgresql + Hibernate3 + C3p0 = not closing connections

This only happens until peak load of the system. Hibernate exception:

org.hibernate.exception.JDBCConnectionException: could not execute query
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. Stream closed
postgresql log entry: 2011-08-10 05:27:35 UTC LOG: ...