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 <danush...@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 > > 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 <danush...@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.prad...@adnatesolutions.com> wrote: >>> >>>> User related data.. >>>> >>>> On Thu, Jun 29, 2017 at 11:23 AM, Danushka Fernando <danush...@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.prad...@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 >>>>>> >>>>>> >>>>> >>>> >>> >> >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
