Sumedha, would the following use case be correct regarding the use of h2 console?
A user manages his own databases, and for that purpose the user can use the component being done by Prabath A. A user can create new databases, view his created databases, and add users to those databases. In the same UI, there are options to create datasources for accessing the created databases as well as to implement user's data model on his created databases using H2 console. As in the Stratos, we knows the mapping of the tenant -> databases, It would be useful if the Data source component and the H2 console are aware of that mapping. For instance, when a user accesses the H2 console component's UI, he can select a URL of his databases and then can connect to the selected one for further processing such as adding tables, etc. ~ Indika On Thu, Mar 10, 2011 at 7:17 PM, Sumedha Rubasinghe <[email protected]>wrote: > > > On Thu, Mar 10, 2011 at 8:11 AM, Paul Fremantle <[email protected]> wrote: > >> WIll this be tied into the Data Sources component? How hard is that to do? > > > Paul, > There are two things being discussed here. > My configuration explanation to Samisa is on something we have already. > This allows you to view existing Registry & UM databases using the browser. > On any Carbon based product released so far would have this. > > Kalpanie is trying to make this a Carbon component, so that it will be > available as a generic component to be used in Data Sources Component, Data > Services & our Stratos Data Story. I believe we are one week away from > having this as a fully completed component. > > /sumedha > >> >> Paul >> >> On 10 March 2011 12:57, Sumedha Rubasinghe <[email protected]> wrote: >> >>> >>> >>> On Thu, Mar 10, 2011 at 7:50 AM, Samisa Abeysinghe <[email protected]>wrote: >>> >>>> What products will ship this? >>> >>> >>> All the products on Carbon :-) >>> /sumedha >>> >>> >>>> >>>> >>>> On Thu, Mar 10, 2011 at 6:02 PM, Sumedha Rubasinghe >>>> <[email protected]>wrote: >>>> >>>>> On Thu, Mar 10, 2011 at 7:29 AM, Samisa Abeysinghe <[email protected]>wrote: >>>>> >>>>>> Can we use this to monitor the running instance of the registry H2 >>>>>> DB? >>>>> >>>>> >>>>> Yeap.. We do that already.. >>>>> >>>>> 1. Add following to end of your carbon.xml >>>>> >>>>> <H2DatabaseConfiguration> >>>>> <property name="web" /> >>>>> <property name="webPort">8082</property> >>>>> </H2DatabaseConfiguration> >>>>> >>>>> 2. Open up a browser & point into http://localhost:8082 >>>>> 3. Accept the default values & use 'wso2carbon' as the password. >>>>> >>>>> >>>>> But Kalpanie is trying to make this a generic component to monitor any >>>>> database. >>>>> /sumedha >>>>> >>>>> >>>>> >>>>> >>>>>> >>>>>> >>>>>> On Thu, Mar 10, 2011 at 5:56 PM, Sumedha Rubasinghe <[email protected] >>>>>> > wrote: >>>>>> >>>>>>> >>>>>>> >>>>>>> On Thu, Mar 10, 2011 at 7:21 AM, Samisa Abeysinghe >>>>>>> <[email protected]>wrote: >>>>>>> >>>>>>>> Does this work on Windows for H2? >>>>>>> >>>>>>> >>>>>>> Yes. Basically H2 uses a generic JDBC database explorer. They just >>>>>>> set in some parameters @ the start up telling the default database is >>>>>>> H2. >>>>>>> But we can unset those & make this a generic addition. >>>>>>> >>>>>>> /sumedha >>>>>>> >>>>>>> >>>>>>>> >>>>>>>> On Thu, Mar 10, 2011 at 1:16 PM, Nuwan Bandara <[email protected]>wrote: >>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Thu, Mar 10, 2011 at 9:27 AM, Kalpanie Wanigaratne < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Thu, Mar 10, 2011 at 8:42 AM, Nuwan Bandara <[email protected]>wrote: >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Wed, Mar 9, 2011 at 7:48 PM, Senaka Fernando <[email protected] >>>>>>>>>>> > wrote: >>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Wed, Mar 9, 2011 at 12:27 PM, Afkham Azeez >>>>>>>>>>>> <[email protected]>wrote: >>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Wed, Mar 9, 2011 at 11:49 AM, Sameera Jayasoma < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Wed, Mar 9, 2011 at 5:36 AM, Kalpanie Wanigaratne < >>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I'm going to do the $subject and in order to do it, it needs >>>>>>>>>>>>>>> to add the following configuration to the web.xml. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> <servlet> >>>>>>>>>>>>>>> <servlet-name>H2Console</servlet-name> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> <servlet-class>org.h2.server.web.WebServlet</servlet-class> >>>>>>>>>>>>>>> <load-on-startup>1</load-on-startup> >>>>>>>>>>>>>>> </servlet> >>>>>>>>>>>>>>> <servlet-mapping> >>>>>>>>>>>>>>> <servlet-name>H2Console</servlet-name> >>>>>>>>>>>>>>> <url-pattern>/console/*</url-pattern> >>>>>>>>>>>>>>> </servlet-mapping> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> For the moment i have included this in the >>>>>>>>>>>>>>> product/lib/core/WEB-INF/web.xml and i created a UI component >>>>>>>>>>>>>>> by pointing >>>>>>>>>>>>>>> the link in component.xml to h2console. But then the console >>>>>>>>>>>>>>> opens in a >>>>>>>>>>>>>>> separate page. (It does not open the page, inside our normal >>>>>>>>>>>>>>> web page). >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Also when considering this as a component, this approach is >>>>>>>>>>>>>>> wrong because the web.xml entry resides inside the product. I >>>>>>>>>>>>>>> don't have any >>>>>>>>>>>>>>> clue, where to put the servlet entry inside the component. Can >>>>>>>>>>>>>>> any one >>>>>>>>>>>>>>> please give an idea to do this? >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> So you register this console as a separate servlet right? >>>>>>>>>>>>>> Then I don't think you can open this console within the carbon >>>>>>>>>>>>>> ui framework. >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> Grab the OSGi HTTPService and register your servlet into that >>>>>>>>>>>>> service. >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> +1. We've done that for the Atom/jUDDI servlets etc in G-Reg. >>>>>>>>>>>> >>>>>>>>>>>> Thanks, >>>>>>>>>>>> Senaka. >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Yap, we are doing the same thing when registering shindig >>>>>>>>>>> servlets. Also feel this is quite a useful feature, is there a >>>>>>>>>>> possibility >>>>>>>>>>> that we can plug a common database explorer (not specific to H2), >>>>>>>>>>> so any of >>>>>>>>>>> the connected databases can be explored within our mgt console. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> Thanks every one. Yes nuwan, H2 console is a common database >>>>>>>>>> explorer, where it supports to connect not only to H2 database, but >>>>>>>>>> also to >>>>>>>>>> many databases. >>>>>>>>>> >>>>>>>>> >>>>>>>>> ah thats great :) >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> /Nuwan >>>>>>>>> >>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> Regards, >>>>>>>>>>> /Nuwan >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Is there any possibility to register this console servlet >>>>>>>>>>>>>> inside the OSGi framework using the OSGi http service. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks >>>>>>>>>>>>>> Sameera >>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thanks. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Kalpanie >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> Sameera Jayasoma >>>>>>>>>>>>>> Technical Lead and Product Manager, WSO2 Carbon >>>>>>>>>>>>>> >>>>>>>>>>>>>> WSO2, Inc. (http://wso2.com) >>>>>>>>>>>>>> email: [email protected] >>>>>>>>>>>>>> blog: http://tech.jayasoma.org >>>>>>>>>>>>>> >>>>>>>>>>>>>> Lean . Enterprise . Middleware >>>>>>>>>>>>>> >>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> *Afkham Azeez* >>>>>>>>>>>>> Senior Software Architect & Senior Manager; 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 >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Senaka Fernando* >>>>>>>>>>>> Product Manager - WSO2 Governance Registry; >>>>>>>>>>>> Associate Technical Lead; WSO2, Inc.; http://wso2.com* >>>>>>>>>>>> Member; Apache Software Foundation; http://apache.org >>>>>>>>>>>> >>>>>>>>>>>> E-mail: senaka AT wso2.com >>>>>>>>>>>> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >>>>>>>>>>>> Linked-In: http://www.linkedin.com/in/senakafernando >>>>>>>>>>>> >>>>>>>>>>>> *Lean . Enterprise . Middleware >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>> [email protected] >>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Thanks & Regards, >>>>>>>>>>> >>>>>>>>>>> Nuwan Bandara >>>>>>>>>>> Software Engineer >>>>>>>>>>> >>>>>>>>>>> WSO2 Inc. | http://wso2.com >>>>>>>>>>> lean . enterprise . middleware >>>>>>>>>>> >>>>>>>>>>> http://www.nuwanbando.com >>>>>>>>>>> >>>>>>>>>>> <http://www.nuwanbando.com/> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>> [email protected] >>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Thanks & Regards, >>>>>>>>> >>>>>>>>> Nuwan Bandara >>>>>>>>> Software Engineer >>>>>>>>> WSO2 Inc. | http://wso2.com >>>>>>>>> lean . enterprise . middleware >>>>>>>>> >>>>>>>>> http://www.nuwanbando.com >>>>>>>>> >>>>>>>>> <http://www.nuwanbando.com/> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Carbon-dev mailing list >>>>>>>>> [email protected] >>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>> Samisa... >>>>>>>> >>>>>>>> Samisa Abeysinghe >>>>>>>> VP Engineering >>>>>>>> WSO2 Inc. >>>>>>>> http://wso2.com >>>>>>>> http://wso2.org >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Carbon-dev mailing list >>>>>>>> [email protected] >>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>> >>>>>>>> >>>>>>> Thanks, >>>>>> Samisa... >>>>>> >>>>>> Samisa Abeysinghe >>>>>> VP Engineering >>>>>> WSO2 Inc. >>>>>> http://wso2.com >>>>>> http://wso2.org >>>>>> >>>>>> >>>>>> >>>>>> >>>>> Thanks, >>>> Samisa... >>>> >>>> Samisa Abeysinghe >>>> VP Engineering >>>> WSO2 Inc. >>>> http://wso2.com >>>> http://wso2.org >>>> >>>> >>>> >>>> >>> >>> _______________________________________________ >>> Carbon-dev mailing list >>> [email protected] >>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>> >>> >> >> >> -- >> Paul Fremantle >> CTO and Co-Founder, WSO2 >> OASIS WS-RX TC Co-chair, VP, Apache Synapse >> >> Office: +44 844 484 8143 >> Cell: +44 798 447 4618 >> >> blog: http://pzf.fremantle.org >> twitter.com/pzfreo >> [email protected] >> >> wso2.com Lean Enterprise Middleware >> >> Disclaimer: This communication may contain privileged or other >> confidential information and is intended exclusively for the addressee/s. If >> you are not the intended recipient/s, or believe that you may have received >> this communication in error, please reply to the sender indicating that fact >> and delete the copy you received and in addition, you should not print, >> copy, retransmit, disseminate, or otherwise use the information contained in >> this communication. Internet communications cannot be guaranteed to be >> timely, secure, error or virus-free. The sender does not accept liability >> for any errors or omissions. >> > > > _______________________________________________ > Carbon-dev mailing list > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > >
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
