Forgot to add example of my Resource configuration in
[TOMEE_HOME/conf/tomee.xml:
<Resource id="mdWareDS" type="javax.sql.DataSource">
JdbcDriver oracle.jdbc.OracleDriver
JdbcUrl
jdbc:oracle:thin:@oracle.server.com<http://oracle.server.com>:1528:DEV14
UserName MDW_WARE
Password MDW_WARE
connectionProperties = [autoReconnect=true,autoReconnectForPools=true]
JtaManaged true
</Resource>
Miles Poindexter
Service Oriented Architecture
[email protected]<mailto:[email protected]>
347-967-8944 / 212-790-6692
On Feb 7, 2014, at 10:27 AM, "Poindexter, Miles"
<[email protected]<mailto:[email protected]>> wrote:
Hi,
I'm investigating problems with our database connections after upgrading from
TomEE 1.5.2 to 1.6.0
After the upgrade, we starting getting a lot of "Connection to DB closed" type
error messages.
And operations like table truncating are failing.
I have reverted our production platform to 1.5.2 to see if this fixes the
issue, and will let you know if it disappears.
Example log messages:
bombed truncating tables: No operations allowed after connection
closed.Connection was implicitly closed due to underlying exception/error:
bombed truncating table: MAILINGS_DETAIL, No more data to read from socket
I never saw these type of errors before the upgrade. Has anyone else had
problems like this?
This is happening on TomEE 1.6.0 running on Redhat 5.
Problems are happening with both Oracle and MySQL.
Drivers added to [TOMEE_HOME]/lib/:
mysql-connector-java-5.1.6.jar
ojdbc6.jar (for Oracle)
Would a driver update possibly fix this?
miles
Miles Poindexter
Service Oriented Architecture
[email protected]<mailto:[email protected]><mailto:[email protected]>
347-967-8944 / 212-790-6692
