Losing connection to database. Postgress, Glassfish

0

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.
    
asked by anonymous 05.09.2016 / 23:35

0 answers