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 <gilbert...@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
