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
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3871889#3871889
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3871889
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
