i always set datasources in tomee.xml so i don't know about
WEB-INF/resources.xml. here is an examples of what i use. i have never
had any connection issues
<Resource id="books" type="javax.sql.DataSource">
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://localhost:3306/books
UserName bookuser
Password **********
testOnReturn = true
testWhileIdle = true
timeBetweenEvictionRunsMillis = 2
initialSize = 2
minIdle = 2
validationQuery = select 1
</Resource>
On 24/11/2021 19:06, Mauro Chi wrote:
https://tomee.apache.org/datasource-config.html
please you know what properties i have to set into resource.xml for the
datasouce for have app all times some connection into pool available?
With my simple configuration already setted for username password , driver
and url i get after some time the web app not respond because connection
from pooli i think is not available.
I have to go into manager app and reload the application for get working.
So i Think i have to set some properties into declaration of datasource
like explained from
Tomee datadource configiration .
But i non know what propertie use for have connection available all times
someone connect to my web app
Thank you into Advance.
Mauro
