-
1. Re: JBoss restart after DB restart needed?
schrouf Mar 29, 2005 8:51 AM (in response to e9725082)After database restart all JBoss cached db connections are invalid ! Therefore you have to flush the database connection pool, that is 'internally' used by your CMP entity beans (most probably DefaultDS) via JMX console. Have a look at the "jboss.jca" service section to find the correct connection pool mbean entry.
Additionally you should also include an appropriate exception sorter entry in combination with a validconnectionsql entry into you datasource -ds.xml configuration, so JBoss removes dead connections from the pool by itself on SQL.
sample:
<new-connection-sql>set lock mode to wait</new-connection-sql>
<valid-connection-sql>set lock mode to wait</valid-connection-sql>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
Regards
Ulf -
2. Re: JBoss restart after DB restart needed?
riank Sep 19, 2005 4:12 AM (in response to e9725082)Hi e9725082
Did this fix work for you?