After about 15 minutes my system stops communicating with the database.
Log Entry Detail Close
Timestamp 05/09/2016 21: 22: 30,287 Log Level ERROR Logger org.hibernate.engine.jdbc.spi.SqlExceptionHelper Name-Value Pairs {levelValue = 1000, timeMillis = 1473110550287} Record Number 2130 Message ID Complete Message This connection has been closed.
Local problem does not happen. After setting up remote bank problem it already starts. Researching, I discovered that it is necessary to create the connection pool when working with glassfish, I tried to create but not to ping with my bank.
I'm working with jpa, glassfish 4.1
<persistence-unit name="meusistema" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="javax.persistence.jdbc.url" value="jdbc:postgresql://...:5432/..."/>
<property name="javax.persistence.jdbc.user" value="postgres"/>
<property name="javax.persistence.jdbc.password" value="root"/>
<property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver"/>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
</properties>
Error occurred in pool creation
Ping Connection Pool failed for juridicoPool. Class name is wrong or classpath is not set for : org.postgresql.ds.PGConnectionPoolDataSource Please check the server.log for more details.