tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romain Manni-Bucau <rmannibu...@gmail.com>
Subject Re: Transaction Manager Failure
Date Wed, 21 May 2014 06:36:50 GMT
Hi

is it a typo or is validationQuery empty?

value should be for mysql "select 1"



Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau


2014-05-21 8:30 GMT+02:00 Chris Rohr <ch.rohr@gmx.de>:

> Thank you for the advice. Now I have changed the configuration as the
> following:
>
> <Resource id=[Name] type="javax.sql.DataSource">
>             jdbcDriver = com.mysql.jdbc.Driver
>             jdbcUrl = jdbc:mysql://localhost:3306/[Databasename]
>             jtaManaged = true
>             password = [Password]
>             username = [Username]
>             defaultAutoCommit = false
>             testOnReturn = true
>             testWhileIdle = true
>             timeBetweenEvictionRunsMillis = 2
>             initialSize = 2
>             minIdle = 2
>             validationQuery
> </Resource>
>
> But I get the same failur after a period of 12-24 hours. Maybe you a one
> more advice or is a Setting wrong? After I have restart TomEE I have see in
> the Logs because of Warnings and found no warning of a new Parameter in
> tomee.xml
>
>
> Thank you.
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Transaction-Manager-Failure-tp4669403p4669474.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message