Thanks for response, Not all drivers support auto reconnect, so pool should handle this and invalidate broken connections. Validation query works fine with db mediators and data services, the issue only with registry and user management in esb 3.0.1. Do you have any beta build of next esb release? I want to verify how this handled in 3.1.0
Sent from my iPad On 13.03.2011, at 17:41, "Hiranya Jayathilaka" <[email protected]<mailto:[email protected]>> wrote: On Sun, Mar 13, 2011 at 9:06 PM, Anjana Fernando <<mailto:[email protected]>[email protected]<mailto:[email protected]>> wrote: Hi, On Sun, Mar 13, 2011 at 11:43 AM, Hiranya Jayathilaka <<mailto:[email protected]>[email protected]<mailto:[email protected]>> wrote: > I think we have experienced this behavior before with MSSQL, when using DB > mediators etc. I think it's some issue with the driver. However there is a > workaround. Anjana should be able to provide exact details about the > parameters you need to add. Honestly, I can't remember which workaround you're talking about :) .. But yeah, this is a simple case of a connections being stale. And yeah, as I remember the user-mgt code didn't have the validationQuery functionality even when the registry had it, but now it does. Yeah this is exactly the fix I was talking about :) Didn't know that old releases of Carbon do not support this parameter. Thanks, Hiranya Cheers, Anjana. > Thanks, > Hiranya > > On Fri, Mar 11, 2011 at 5:52 PM, Hodchenkov, Paul > <<mailto:[email protected]>[email protected]<mailto:[email protected]>> > wrote: >> >> Hi folks, >> >> I am using MS SQL database for registry. I am trying to figure out why esb >> 3.0.1 does not reconnect successfully to db when MSSQL was restarted. >> >> I had created test resource in registry which is accessible by >> <http://localhost:9763/registry/resource/_system/governance/test> >> http://localhost:9763/registry/resource/_system/governance/test >> >> The problem is that ESB 3.0.1(governance folder is mounted using JDBC >> model) can access this resource only after 4-5 attempt after database is >> restarted. However GREG 3.6.0 (using the same MSSQL database at the same >> time) can access this resource successfully from first attempt after >> database restart. It seems that ESB 3.0.1 does not respect validationQuery >> property in registry.xml . As I remember I had the same issue with GREG >> 3.5.1, however in 3.6.0 it was fixed. Does ESB 3.0.1 share the source code >> for embedded registry from GREG 3.5.1 which prevents graceful reconnect? If >> yes, should I switch to ATOM based model at ESB to workaround this(however >> in this case I will have single point of failure)? >> >> Also why user-mgt.xml does not support validationQuery property? I looked >> to sources of JDBCUserStoreManager and it does not use validationQuery >> property. >> >> >> >> >> >> Best Regards, >> Paul Hodchenkov >> Java developer, Oxagile >> Skype: paul.hodchenkov >> Email: >> mailto:<mailto:[email protected]>[email protected]<mailto:[email protected]> >> >> >> >> _______________________________________________ >> Carbon-dev mailing list >> <mailto:[email protected]> [email protected]<mailto:[email protected]> >> <http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev> >> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> > > > > -- > Hiranya Jayathilaka > Senior Software Engineer; > WSO2 Inc.; <http://wso2.org> http://wso2.org > E-mail: <mailto:[email protected]> [email protected]<mailto:[email protected]>; > Mobile: +94 77 633 3491<tel:%2B94%2077%20633%203491> > Blog: <http://techfeast-hiranya.blogspot.com> > http://techfeast-hiranya.blogspot.com > > _______________________________________________ > Carbon-dev mailing list > <mailto:[email protected]> [email protected]<mailto:[email protected]> > <http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev> > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- Anjana Fernando Software Engineer WSO2, Inc.; <http://wso2.com> http://wso2.com lean.enterprise.middleware -- Hiranya Jayathilaka Senior Software Engineer; WSO2 Inc.; <http://wso2.org> http://wso2.org E-mail: <mailto:[email protected]> [email protected]<mailto:[email protected]>; Mobile: +94 77 633 3491 Blog: <http://techfeast-hiranya.blogspot.com> http://techfeast-hiranya.blogspot.com _______________________________________________ Carbon-dev mailing list [email protected]<mailto:[email protected]> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
