I couldn't find data source configuration in data services. Where is it?
________________________________
From: Anjana Fernando <anj...@wso2.com>
To: metin d <met...@yahoo.com>
Cc: "carbon-dev@wso2.org" <carbon-dev@wso2.org>
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 <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/
>>>
>>>
>>>email: azeez@wso2.comcell: +94 77 3320919
>>>blog: http://blog.afkham.org
>>>twitter: 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
