Why after long idle time, the first message fails during DB connection ?

Solution Verified - Updated -

Issue

  • In my Fuse application, I am connection to PostgreSQL using jdbctemplate. The PostgreSQL DB is in a separate Unix box. After the application being idle for long time, the first message send is getting error. The subsequent messages are successfully processed after this initial error.
  • Is it because the DB connection is somehow terminated and Fuse without recognizing this trying to use the same connection ? Can you please guide me on how to rectify if this issue ?
  • DB version used is postgresql.version:9.1-901.jdbc4.
  • This issue is happening only if the application is idle for long time.

Environment

  • Red Hat JBoss Fuse
    • 6.1.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.