Win a copy of TDD for a Shopping Website LiveProject this week in the Testing 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
  • Piet Souris
  • Himai Minh

JBoss 6.2 EAP connection retry issue after DB restart

Ranch Hand
Posts: 45
Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are you sure your code isn't holding on to an old/stale connection?
These are not the droids you are looking for. Perhaps I can interest you in a tiny ad?
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
    Bookmark Topic Watch Topic
  • New Topic