Re: [Carbon-dev] Database reconnect and validation query

2011-03-13 Thread Hodchenkov, Paul
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 releas

Re: [Carbon-dev] Database reconnect and validation query

2011-03-13 Thread Hiranya Jayathilaka
On Sun, Mar 13, 2011 at 9:06 PM, Anjana Fernando wrote: > Hi, > > On Sun, Mar 13, 2011 at 11:43 AM, Hiranya Jayathilaka > 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 > > w

Re: [Carbon-dev] Database reconnect and validation query

2011-03-13 Thread Anjana Fernando
Hi, On Sun, Mar 13, 2011 at 11:43 AM, Hiranya Jayathilaka 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 > param

Re: [Carbon-dev] Database reconnect and validation query

2011-03-12 Thread Hiranya Jayathilaka
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. Thanks, Hiranya On Fri, Mar 11, 2011 at 5:52 PM, H

Re: [Carbon-dev] Database reconnect and validation query

2011-03-12 Thread Hodchenkov, Paul
based strategy??? From: carbon-dev-boun...@wso2.org [mailto:carbon-dev-boun...@wso2.org] On Behalf Of Hodchenkov, Paul Sent: Friday, March 11, 2011 2:22 PM To: carbon-dev@wso2.org Subject: [Carbon-dev] Database reconnect and validation query Hi folks, I am using MS SQL database for registry. I am

[Carbon-dev] Database reconnect and validation query

2011-03-11 Thread Hodchenkov, Paul
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 The problem is

[Carbon-dev] Database reconnect and validation query

2011-03-11 Thread Hodchenkov, Paul
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 The problem is