Hi, Did you add it to the data source configuration in data services? ..
Cheers, Anjana. On Thu, Jan 5, 2012 at 12:26 PM, metin d <met...@yahoo.com> wrote: > I added validationQuery to places you mentioned, but still experience > same problem. > > egistry.xml > Database configuration. E.g., > </dbConfig> > > <dbConfig name="WSO2Registry"> > > <url>jdbc:mysql://db.example.com:3306/registry_db?autoReconnect=true</url> > <userName>user</userName> > <password>password</password> > <driverName>com.mysql.jdbc.Driver</driverName> > <maxActive>50</maxActive> > <maxWait>60000</maxWait> > <minIdle>5</minIdle> > <validationQuery>SELECT 1</validationQuery> > </dbConfig> > > user-mgt.xml > Configure user store. E.g., > > <Property > name="url">jdbc:mysql://db.example.com:3306/userstore_db?autoReconnect=true</Property> > <Property name="userName">user</Property> > <Property name="password">password</Property> > <Property name="driverName">com.mysql.jdbc.Driver</Property> > <Property name="maxActive">50</Property> > <Property name="maxWait">60000</Property> > <Property name="minIdle">5</Property> > <Property > name="MultiTenantRealmConfigBuilder">org.wso2.carbon.user.core.config.multitenancy.SimpleRealmConfigBuilder</Property> > <Property name="validationQuery">SELECT 1</Property> > > > > > ------------------------------ > *From:* Anjana Fernando <anj...@wso2.com> > *To:* carbon-dev@wso2.org > *Sent:* Wednesday, January 4, 2012 11:35 AM > *Subject:* Re: [Carbon-dev] First Request Fails Between Carbon Servers > > Hi, > > Yeah, as Hiranya mentioned, since we pool database connections, the > connections that are kept will become stale after a long time of > inactivity, so the solution would be to test the connection before actually > using it, and re-create the connections if required. So for this, you > simply have to provide the validation query in the data service in the data > source configuration. The same have to be done in user-mgt.xml and also > possibly in registry.xml for registry database configuration. The property > name in user mgt would be "validationQuery", and also there have to be an > element named "validationQuery" in registry.xml. > > Cheers, > Anjana. > > On Wed, Jan 4, 2012 at 2:34 PM, Hiranya Jayathilaka <hira...@wso2.com>wrote: > > I think DB connections are becoming stale due to lack of activity. This > can be avoided by specifying a validation query for the data sources. > Anjana should know more details. > > Thanks, > Hiranya > > > On Wed, Jan 4, 2012 at 2:32 PM, Afkham Azeez <az...@wso2.com> wrote: > > Did you host the webapp into the super-tenant? Please post the error. > > On Wed, Jan 4, 2012 at 2:25 PM, metin d <met...@yahoo.com> wrote: > > We deployed a web application on AS, in some parts of web application > there are calls to .dbs on DSS. If we don't use web application a while, > then try to use it, first request to .dbs on DSS fails, but second and > consecutive attempts work without any problem. We observe same situation > during our requests to AuthenticationAdmin service . > > Do you have any idea about the source of this problem? > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > > > -- > *Afkham Azeez* > Director of Architecture; WSO2, Inc.; http://wso2.com > Member; Apache Software Foundation; http://www.apache.org/ > * <http://www.apache.org/>** > email: **az...@wso2.com* <az...@wso2.com>* cell: +94 77 3320919 > blog: **http://blog.afkham.org* <http://blog.afkham.org>* > twitter: **http://twitter.com/afkham_azeez*<http://twitter.com/afkham_azeez> > * > linked-in: **http://lk.linkedin.com/in/afkhamazeez* > * > * > *Lean . Enterprise . Middleware* > > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > > > -- > Hiranya Jayathilaka > Associate Technical Lead; > WSO2 Inc.; http://wso2.org > E-mail: hira...@wso2.com; Mobile: +94 77 633 3491 > Blog: http://techfeast-hiranya.blogspot.com > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > > > -- > *Anjana Fernando* > Senior Software Engineer > WSO2 Inc. | http://wso2.com/ > lean . enterprise . middleware > > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
