I added this params into tomee.xml to resource datasource.
testOnReturn = true
testWhileIdle = true
timeBetweenEvictionRunsMillis = 2
initialSize = 2
minIdle = 2
validationQuery = select 1
But not works
Il Mer 24 Nov 2021, 19:42 Matthew Broadhead
<[email protected]> ha scritto:
> 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
> >
>
>
