You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomee.apache.org by Gilberto <gi...@gmail.com> on 2024/01/09 18:49:45 UTC

Tomee 8 and 7 not taking account Datasource properties in web.xml

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

Re: Tomee 8 and 7 not taking account Datasource properties in web.xml

Posted by Gilberto <gi...@gmail.com>.
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 <gi...@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
>
>

RE: EXT :Tomee 8 and 7 not taking account Datasource properties in web.xml

Posted by "Hamilton, Eric J [US] (DS)" <er...@ngc.com>.
Gilberto,
I’m am not familiar with the web.xml <data-source> configuration, but you may need to explicitly set the factory, if it allows it, such as:
<factory>org.apache.tomcat.jdbc.pool.DataSourceFactory</factory>
I believe most of those properties are for the pool implementation.

Eric

From: Gilberto <gi...@gmail.com>
Sent: Tuesday, January 9, 2024 1:50 PM
To: dev@tomee.apache.org
Subject: EXT :Tomee 8 and 7 not taking account Datasource properties in web.xml

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