Hi, On Thu, Jan 19, 2012 at 12:59 PM, metin d <[email protected]> wrote:
> Although I changed the data source configuration, I'm still getting > timeout error. What can else it cause to this problem? > That should have fixed it. You may want to do a bit of debugging by, using the log4jdbc driver and logging the JDBC operations. From that, you can check whether the initial validationQuery is executed initially before the other actual query is executed. Cheers, Anjana. > > ------------------------------ > *From:* Anjana Fernando <[email protected]> > *To:* metin d <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, January 5, 2012 11:57 AM > > *Subject:* Re: [Carbon-dev] First Request Fails Between Carbon Servers > > On Thu, Jan 5, 2012 at 3:19 PM, metin d <[email protected]> wrote: > > I couldn't find data source configuration in data services. Where is it? > > > Check the data services wizard's, data source configuration page. > > Cheers, > Anjana. > > > > ------------------------------ > *From:* Anjana Fernando <[email protected]> > *To:* metin d <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, January 5, 2012 9:04 AM > > *Subject:* Re: [Carbon-dev] First Request Fails Between Carbon Servers > > 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 <[email protected]> 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 <[email protected]> > *To:* [email protected] > *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 <[email protected]>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 <[email protected]> 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 <[email protected]> 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 > [email protected] > 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: **[email protected]* <[email protected]>* 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 > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > > > -- > Hiranya Jayathilaka > Associate Technical Lead; > WSO2 Inc.; http://wso2.org > E-mail: [email protected]; Mobile: +94 77 633 3491 > Blog: http://techfeast-hiranya.blogspot.com > > _______________________________________________ > Carbon-dev mailing list > [email protected] > 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 > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > > > > -- > *Anjana Fernando* > Senior Software Engineer > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware > > > > > > -- > *Anjana Fernando* > Senior Software Engineer > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware > > > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
