Could you please logout from h2 console and try with *jdbc:h2:repository/database/WSO2AM_DB;DB_CLOSE_ON_EXIT=FALSE* as JDBC URL. Then you'd be able to see the tabls in the AM_DB.
Regards, DinushaD On Fri, Jun 8, 2018 at 4:33 PM, shibsankar <src...@gmail.com> wrote: > Okay. Now I have connected H2 database through Web UI. > > But I don't see AM_DB , AM_API table there to verify > CONTEXT_TEMPLATE as per earlier replies. > > How to find that ? > > Please see the screenshot attached. > > > Regards > Shib > > > > > > On Fri, Jun 8, 2018 at 2:49 PM, Dinusha Dissanayake <dinus...@wso2.com> > wrote: > >> Hi Shib, >> >> Yes. By default it is using embedded H2 database even though it is >> commented in carbon.xml. >> To browse though the database, please follow the instructions given in >> above provided document.[1] >> [1] https://docs.wso2.com/display/ADMIN44x/Browsing+the+H2+Database. >> >> Thanks, >> DinushaD >> >> On Fri, Jun 8, 2018 at 2:43 PM, shibsankar <src...@gmail.com> wrote: >> >>> I'm using default installation. I see <H2DatabaseConfiguration> is >>> *commented* in my WSO2/repository/conf/carbon.xml. Does it mean its >>> using embedded H2 DB? >>> >>> carbon.xml attached. >>> >>> Regards >>> Shib >>> >>> On Fri, Jun 8, 2018 at 2:13 PM, Nirothipan Mehalingam < >>> nirothi...@wso2.com> wrote: >>> >>>> Hi Shib, >>>> >>>> If you are using embedded H2 DB you may follow https://docs.wso2.com/d >>>> isplay/ADMIN44x/Browsing+the+H2+Database. >>>> >>>> Thanks >>>> Nirothipan >>>> >>>> On Fri, Jun 8, 2018 at 2:09 PM, shibsankar <src...@gmail.com> wrote: >>>> >>>>> How do I connect to this DB and view the rows of the mentioned table? >>>>> Can it be viewed from API management web-UI? >>>>> >>>>> Regards >>>>> Shib >>>>> >>>>> On Fri, Jun 8, 2018 at 1:50 PM, Dinusha Dissanayake <dinus...@wso2.com >>>>> > wrote: >>>>> >>>>>> Hi Shib, >>>>>> >>>>>> Probably there should be an database entry of the same "context" you >>>>>> are defining here. As above replies explain, this could be due to >>>>>> partially >>>>>> deleted APIs. >>>>>> Could you please check AM_API table in AM_DB and see whether there is >>>>>> a CONTEXT_TEMPLATE with the same context you are trying to define here? >>>>>> >>>>>> Thanks, >>>>>> DinushaD. >>>>>> >>>>>> >>>>>> On Fri, Jun 8, 2018 at 12:50 PM, shibsankar <src...@gmail.com> wrote: >>>>>> >>>>>>> There is no API in publisher application. >>>>>>> >>>>>>> I'm still getting * Duplicate Context Value *when trying to add a >>>>>>> new API in Design page. >>>>>>> >>>>>>> Please see the screenshot attached. >>>>>>> >>>>>>> Regards >>>>>>> Shib >>>>>>> >>>>>>> >>>>>>> On Fri, Jun 8, 2018 at 10:51 AM, Dushani Wellappili < >>>>>>> dusha...@wso2.com> wrote: >>>>>>> >>>>>>>> Hi Shib, >>>>>>>> >>>>>>>> If you have deleted the API from the management console, then it is >>>>>>>> likely you are getting this issue since deleting api in the >>>>>>>> management console does not delete the whole api. It removes the data >>>>>>>> in >>>>>>>> the registry (meta data). To delete api use publisher application. >>>>>>>> >>>>>>>> Thank you. >>>>>>>> >>>>>>>> Regards, >>>>>>>> >>>>>>>> *Dushani Wellappili* >>>>>>>> Software Engineer - WSO2 >>>>>>>> >>>>>>>> Email : dusha...@wso2.com >>>>>>>> Mobile : +94779367571 >>>>>>>> Web : https://wso2.com/ >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Jun 8, 2018 at 10:01 AM Krishan Wijesena <krish...@wso2.com> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar <src...@gmail.com> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> I have *deleted *published API, subscribed API from WSO2. Now >>>>>>>>>> there is no more API in WSO2. >>>>>>>>>> You cannot delete API if active subscriptions exists, which >>>>>>>>>> apporach did you used to delete the API? >>>>>>>>>> >>>>>>>>> because basically this error occur if previous API have same >>>>>>>>> context value and it's partally deleted. >>>>>>>>> >>>>>>>>>> >>>>>>>>>> Restarted the WSO2 server. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Now when I try to add a New API , I'm still getting *Duplicate >>>>>>>>>> context value *in API design page. >>>>>>>>>> >>>>>>>>>> Why is this happening? How to fix this? >>>>>>>>>> >>>>>>>>>> Please see the screenshot attached. >>>>>>>>>> >>>>>>>>>> WSo2 version is 2.1 >>>>>>>>>> >>>>>>>>>> Regards >>>>>>>>>> Shib >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Dev mailing list >>>>>>>>>> Dev@wso2.org >>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>>> *Krishan Wijesena* >>>>>>>>> Software Engineer | WSO2 >>>>>>>>> >>>>>>>>> Email : krish...@wso2.com >>>>>>>>> Mobile : +94776219923 >>>>>>>>> WSO2 Inc : http://wso2.com >>>>>>>>> [image: http://wso2.com/signature] <http://wso2.com/signature> >>>>>>>>> _______________________________________________ >>>>>>>>> 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 >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Dinusha Dissanayake >>>>>> Software Engineer >>>>>> WSO2 Inc >>>>>> Mobile: +94712939439 >>>>>> <https://wso2.com/signature> >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> M.Nirothipan >>>> Software Engineer >>>> WSO2 Inc. http://wso2.com , >>>> *Mobile : +94 77 2172692* >>>> >>>> >>> >> >> >> -- >> Dinusha Dissanayake >> Software Engineer >> WSO2 Inc >> Mobile: +94712939439 >> <https://wso2.com/signature> >> > > -- Dinusha Dissanayake Software Engineer WSO2 Inc Mobile: +94712939439 <https://wso2.com/signature>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev