Why after long idle time, the first message fails during DB connection ?
Issue
- In my
Fuseapplication, I am connection toPostgreSQLusingjdbctemplate. ThePostgreSQLDB is in a separateUnixbox. 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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
