[prev in list] [next in list] [prev in thread] [next in thread]
List: wsas-java-dev
Subject: Re: [Dev] Multiple DataBases
From: Lipsa Pradhan <lipsa.pradhan () adnatesolutions ! com>
Date: 2017-06-30 5:54:25
Message-ID: CANFJchoRLFvC+rWzB0fkXD9dVA9uA6dQQyyChgSwTunSzSXgUA () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thank you so much, its done now...
On Thu, Jun 29, 2017 at 2:07 PM, Danushka Fernando <danushkaf@wso2.com>
wrote:
> Hi Lipsa
> Can you attach the secondary user store configuration you tried with.
>
> Thanks & Regards
> Danushka Fernando
> Associate Tech Lead
> WSO2 inc. http://wso2.com/
> Mobile : +94716332729
>
> On Thu, Jun 29, 2017 at 2:05 PM, Lipsa Pradhan <lipsa.pradhan@
> adnatesolutions.com> wrote:
>
>> I had tried doing this but I didn't get any positive result.
>>
>> I had added mysqlconnector to the lib folder but still, I didn't get any
>> healthy connection on the server when I added Mysql RDBMS as external
>> datasource. Then I switch the master datasource to MySQL and then it worked
>> properly.
>>
>> On Thu, Jun 29, 2017 at 1:55 PM, Danushka Fernando <danushkaf@wso2.com>
>> wrote:
>>
>>> Hi Lipsa
>>> Please use reply all option when you reply.
>>> For JDBC secondary userstores you dont need to add anything to master
>>> datasources. You can configure connection details in carbon UI itself.
>>> Which will not need any restart or anything. BTW you will need to add the
>>> driver jar file to repository/components/lib and restart.
>>>
>>> Thanks & Regards
>>> Danushka Fernando
>>> Associate Tech Lead
>>> WSO2 inc. http://wso2.com/
>>> Mobile : +94716332729 <+94%2071%20633%202729>
>>>
>>> On Thu, Jun 29, 2017 at 1:21 PM, Lipsa Pradhan <
>>> lipsa.pradhan@adnatesolutions.com> wrote:
>>>
>>>> I have tried this one also nut the issue is:
>>>> If I want to add a database of MySQL, I have to switch the master
>>>> datasource to MySQL as well. But I don't want this.
>>>>
>>>> I want to know if I can fetch data from MySQL and Oracle without switch
>>>> the master datasource from H2 database.
>>>>
>>>> On Thu, Jun 29, 2017 at 11:43 AM, Danushka Fernando <danushkaf@wso2.com
>>>> > wrote:
>>>>
>>>>> I think you are looking for [1]. You can configure multiple secondary
>>>>> userstores.
>>>>>
>>>>> [1] https://docs.wso2.com/display/ADMIN44x/Configuring+Secon
>>>>> dary+User+Stores
>>>>>
>>>>> Thanks & Regards
>>>>> Danushka Fernando
>>>>> Associate Tech Lead
>>>>> WSO2 inc. http://wso2.com/
>>>>> Mobile : +94716332729 <+94%2071%20633%202729>
>>>>>
>>>>> On Thu, Jun 29, 2017 at 11:39 AM, Lipsa Pradhan <
>>>>> lipsa.pradhan@adnatesolutions.com> wrote:
>>>>>
>>>>>> User related data..
>>>>>>
>>>>>> On Thu, Jun 29, 2017 at 11:23 AM, Danushka Fernando <
>>>>>> danushkaf@wso2.com> wrote:
>>>>>>
>>>>>>> Hi Lipsa
>>>>>>> What kind of data you want to fetch from those dbs? Do you want to
>>>>>>> expose data as service or do you want to fetch some user related data from
>>>>>>> those dbs?
>>>>>>>
>>>>>>> Thanks & Regards
>>>>>>> Danushka Fernando
>>>>>>> Associate Tech Lead
>>>>>>> WSO2 inc. http://wso2.com/
>>>>>>> Mobile : +94716332729 <+94%2071%20633%202729>
>>>>>>>
>>>>>>> On Thu, Jun 29, 2017 at 11:15 AM, Lipsa Pradhan <
>>>>>>> lipsa.pradhan@adnatesolutions.com> wrote:
>>>>>>>
>>>>>>>> Hello All,
>>>>>>>>
>>>>>>>> Can we connect different databases to EI server?
>>>>>>>>
>>>>>>>> Actually, I want to fetch data from different DB such as some from
>>>>>>>> MySQL, some from Oracle and so on.
>>>>>>>>
>>>>>>>> And one more thing, I don't want to change the default DB i.e, the
>>>>>>>> H2 DB and want to fetch data from different DBs (maybe as external DB , if
>>>>>>>> possible).
>>>>>>>>
>>>>>>>> Regards
>>>>>>>> Lipsa Pradhan
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Dev mailing list
>>>>>>>> Dev@wso2.org
>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
[Attachment #5 (text/html)]
<div dir="ltr">Thank you so much, its done now...</div><div \
class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 29, 2017 at 2:07 PM, \
Danushka Fernando <span dir="ltr"><<a href="mailto:danushkaf@wso2.com" \
target="_blank">danushkaf@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Hi Lipsa<div>Can you attach the secondary user \
store configuration you tried with.</div></div><div class="gmail_extra"><span \
class=""><br clear="all"><div><div class="m_-1107637672050432856gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr">Thanks & Regards<div>Danushka Fernando</div><div>Associate Tech \
Lead</div><div>WSO2 inc. <a href="http://wso2.com/" \
target="_blank">http://wso2.com/</a></div><div>Mobile : \
+94716332729</div></div></div></div></div></div></div></div> <br></span><div><div \
class="h5"><div class="gmail_quote">On Thu, Jun 29, 2017 at 2:05 PM, Lipsa Pradhan \
<span dir="ltr"><<a href="mailto:lipsa.pradhan@adnatesolutions.com" \
target="_blank">lipsa.pradhan@<wbr>adnatesolutions.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr">I had tried doing this but I didn't \
get any positive result.<div><br></div><div>I had added mysqlconnector to the lib \
folder but still, I didn't get any healthy connection on the server when I added \
Mysql RDBMS as external datasource. Then I switch the master datasource to MySQL and \
then it worked properly. </div></div><div class="m_-1107637672050432856HOEnZb"><div \
class="m_-1107637672050432856h5"><div class="gmail_extra"><br><div \
class="gmail_quote">On Thu, Jun 29, 2017 at 1:55 PM, Danushka Fernando <span \
dir="ltr"><<a href="mailto:danushkaf@wso2.com" \
target="_blank">danushkaf@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Hi Lipsa <div>Please use reply all option \
when you reply. </div><div>For JDBC secondary userstores you dont need to add \
anything to master datasources. You can configure connection details in carbon UI \
itself. Which will not need any restart or anything. BTW you will need to add the \
driver jar file to repository/components/lib and restart.</div></div><div \
class="gmail_extra"><span><br clear="all"><div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr">Thanks & Regards<div>Danushka Fernando</div><div>Associate Tech \
Lead</div><div>WSO2 inc. <a href="http://wso2.com/" \
target="_blank">http://wso2.com/</a></div><div>Mobile : <a \
href="tel:+94%2071%20633%202729" value="+94716332729" \
target="_blank">+94716332729</a></div></div></div></div></div></div></div></div> \
<br></span><div><div class="m_-1107637672050432856m_2611928266694291142h5"><div \
class="gmail_quote">On Thu, Jun 29, 2017 at 1:21 PM, Lipsa Pradhan <span \
dir="ltr"><<a href="mailto:lipsa.pradhan@adnatesolutions.com" \
target="_blank">lipsa.pradhan@adnatesolutions<wbr>.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr">I have tried this one also nut the issue \
is: <br>If I want to add a database of MySQL, I have to switch the master datasource \
to MySQL as well. But I don't want this.<div><br></div><div>I want to know if I \
can fetch data from MySQL and Oracle without switch the master datasource from H2 \
database.</div></div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466HOEnZb"><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466h5"><div \
class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 29, 2017 at 11:43 AM, \
Danushka Fernando <span dir="ltr"><<a href="mailto:danushkaf@wso2.com" \
target="_blank">danushkaf@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">I think you are looking for [1]. You can \
configure multiple secondary userstores.<div><br></div><div>[1] <a \
href="https://docs.wso2.com/display/ADMIN44x/Configuring+Secondary+User+Stores" \
target="_blank">https://docs.wso2.com/disp<wbr>lay/ADMIN44x/Configuring+Secon<wbr>dary+User+Stores</a></div></div><div \
class="gmail_extra"><span><br clear="all"><div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_6066218891980446817m_7069717386721687590gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr">Thanks & Regards<div>Danushka Fernando</div><div>Associate Tech \
Lead</div><div>WSO2 inc. <a href="http://wso2.com/" \
target="_blank">http://wso2.com/</a></div><div>Mobile : <a \
href="tel:+94%2071%20633%202729" value="+94716332729" \
target="_blank">+94716332729</a></div></div></div></div></div></div></div></div> \
<br></span><div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_6066218891980446817h5"><div \
class="gmail_quote">On Thu, Jun 29, 2017 at 11:39 AM, Lipsa Pradhan <span \
dir="ltr"><<a href="mailto:lipsa.pradhan@adnatesolutions.com" \
target="_blank">lipsa.pradhan@adnatesolutions<wbr>.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr">User related data..</div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_6066218891980446817m_7069717386721687590HOEnZb"><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_6066218891980446817m_7069717386721687590h5"><div \
class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 29, 2017 at 11:23 AM, \
Danushka Fernando <span dir="ltr"><<a href="mailto:danushkaf@wso2.com" \
target="_blank">danushkaf@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Hi Lipsa<div>What kind of data you want to \
fetch from those dbs? Do you want to expose data as service or do you want to fetch \
some user related data from those dbs?</div></div><div class="gmail_extra"><br \
clear="all"><div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_606621889198 \
0446817m_7069717386721687590m_-2985041105194760754m_5040995260039138164gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr">Thanks & Regards<div>Danushka Fernando</div><div>Associate Tech \
Lead</div><div>WSO2 inc. <a href="http://wso2.com/" \
target="_blank">http://wso2.com/</a></div><div>Mobile : <a \
href="tel:+94%2071%20633%202729" value="+94716332729" \
target="_blank">+94716332729</a></div></div></div></div></div></div></div></div> \
<br><div class="gmail_quote"><div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_6066218891980446817m_7069717386721687590m_-2985041105194760754h5">On \
Thu, Jun 29, 2017 at 11:15 AM, Lipsa Pradhan <span dir="ltr"><<a \
href="mailto:lipsa.pradhan@adnatesolutions.com" \
target="_blank">lipsa.pradhan@adnatesolutions<wbr>.com</a>></span> \
wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_6066218891980446817m_7069717386721687590m_-2985041105194760754h5"><div \
dir="ltr">Hello All,<div><br></div><div>Can we connect different databases to EI \
server? </div><div><br></div><div>Actually, I want to fetch data from different DB \
such as some from MySQL, some from Oracle and so on. </div><div><br></div><div>And \
one more thing, I don't want to change the default DB i.e, the H2 DB and want to \
fetch data from different DBs (maybe as external DB , if \
possible).</div><div><br></div><div>Regards </div><span \
class="m_-1107637672050432856m_2611928266694291142m_-2615522456087695466m_606621889198 \
0446817m_7069717386721687590m_-2985041105194760754m_5040995260039138164HOEnZb"><font \
color="#888888"><div>Lipsa Pradhan</div></font></span></div> \
<br></div></div>______________________________<wbr>_________________<br> Dev mailing \
list<br> <a href="mailto:Dev@wso2.org" target="_blank">Dev@wso2.org</a><br>
<a href="http://wso2.org/cgi-bin/mailman/listinfo/dev" rel="noreferrer" \
target="_blank">http://wso2.org/cgi-bin/mailma<wbr>n/listinfo/dev</a><br> \
<br></blockquote></div><br></div> </blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic