Why after long idle time, the first message fails during DB connection ?
Issue
- In my
Fuse
application, I am connection toPostgreSQL
usingjdbctemplate
. ThePostgreSQL
DB is in a separateUnix
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, tools, and much more.