I've forgot to show that after the sessions timeout (30 min), the webapp stops responding and we see the log grows up: [code] 10-Jan-2024 09:35:06.478 ADVERTÊNCIA [http-nio-8080-exec-1] org.apache.tomcat.jdbc.pool.PooledConnection.clearWarnings Unable to clear Warnings, connection will be closed. org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:782) at org.postgresql.jdbc.PgConnection.clearWarnings(PgConnection.java:694) at org.apache.tomcat.jdbc.pool.PooledConnection.clearWarnings(PooledConnection.java:875) at org.apache.tomcat.jdbc.pool.ConnectionPool.returnConnection(ConnectionPool.java:1019) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:103) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:69) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) at com.sun.proxy.$Proxy200.close(Unknown Source) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeDatasourceConnection(DatabaseAccessor.java:502) at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.closeConnection(DatasourceAccessor.java:524) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeConnection(DatabaseAccessor.java:527) at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.decrementCallCount(DatasourceAccessor.java:293) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeStatement(DatabaseAccessor.java:410) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:686) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2099) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:265) [/code]
Eric, the data-source definition using web module descriptor is in the Java EE 7 and 8 spec in section: EE.5.18.3 DataSource Resource Definition. Regards, Gilberto Em ter., 9 de jan. de 2024 às 15:49, Gilberto <gilbert...@gmail.com> escreveu: > Hello all! Happy new year! > > Guys, this app is working and now we needed to move it out of the VLAN of > the postgresql database. > So, we adjusts some database parameters in web.xml data-source descriptor: > [code] > <data-source> > <name>java:app/gaceDS</name> > <class-name>org.postgresql.Driver</class-name> > <url>jdbc:postgresql://srv-banco-prod:5433/empreendedor</url> > <user>gace_user</user> > <password>gace_user</password> > <property> > <name>validationQuery</name> > <value>select 1;</value> > </property> > <transactional>true</transactional> > <isolation-level>TRANSACTION_READ_COMMITTED</isolation-level> > <initial-pool-size>6</initial-pool-size> > <max-pool-size>20</max-pool-size> > <min-pool-size>10</min-pool-size> > <max-idle-time>1800</max-idle-time> > <max-statements>0</max-statements> > </data-source> > </web-app> > [/code] > > But, we note that these parameters are not taken into account at the > startup, see: > [code] > openejb.config.ConfigurationFactory.configureService Configuring > Service(id=gace/app/gaceDS, type=Resource, provider-id=Default JDBC > Database) > openejb.assembler.classic.Assembler.createRecipe Creating > Resource(id=gace/app/gaceDS) > openejb.assembler.classic.Assembler.unusedProperty unused property > 'initialPoolSize' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property > 'MaxStatements' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property > 'DefaultIsolationLevel' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property > 'maxIdleTime' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property > 'minPoolSize' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property > 'isolationLevel' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property > 'maxPoolSize' for resource 'gace/app/gaceDS' > openejb.assembler.classic.Assembler.unusedProperty unused property 'user' > for resource 'gace/app/gaceDS' > openejb.config.ConfigurationFactory.configureService Configuring > Service(id=Default Stateless Container, type=Container, provider-id=Default > Stateless Container) > openejb.config.AutoConfig.createContainer Auto-creating a container for > bean EventoService: Container(type=STATELESS, id=Default Stateless > Container) > openejb.assembler.classic.Assembler.createRecipe Creating > Container(id=Default Stateless Container) > openejb.config.AutoConfig.processResourceRef Auto-linking resource-ref > 'java:app/gaceDS' in bean EventoService to Resource(id=gace/app/gaceDS) > [/code] > Has anyone seen this behavior? > > Regards, > > Gilberto > >
