Win a copy of Event Streams in Action this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

JBoss 6.2 EAP connection retry issue after DB restart

Ranch Hand
Posts: 45
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
On DB Crash and restart the JBoss 6.2 EAP server is not able to reconnect to the MySQL database with the connections from the connection pool. I get Broken Pipe error after adding the autoReconnect connection property. Only after the restart of the JBoss application server it works fine.


Caused by: org.hibernate.TransactionException: rollback failed
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(
at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(
... 72 more
Caused by: org.hibernate.TransactionException: unable to rollback against JDBC connection
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(
... 73 more
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

MESSAGE: Broken pipe

STACKTRACE: Broken pipe
at Method)
at Source)
at Source)
at Source)

----skipped lines----

at Source)
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.MysqlIO.send(
at com.mysql.jdbc.MysqlIO.sendCommand(
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
at com.mysql.jdbc.Connection.execSQL(
at com.mysql.jdbc.Connection.setAutoCommit(
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(

Posts: 10445
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure your code isn't holding on to an old/stale connection?
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!