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 <[email protected]>: > 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. >
