Hi Xue-Feng, On Sun, Feb 13, 2011 at 11:16 AM, Xue-Feng Yang <[email protected]> wrote:
> Hi Harshana, > > More confusions are here. > > As the doc suggested, I put ShoppingCartDS with dataservice server, which I > found there are many db's in the directory > > > C:\testcenter\release\wso2\wso2dataservices-2.5.1\repository\database\WSO2CARBON_DB.lobs.db > > I used > jdbc:h2:/testcenter/release/wso2/wso2dataservices-2.5.1/repository/database/WSO2CARBON_DB, > regadmin(userId) and regadmin(password), and I used > jdbc:h2:/testcenter/release/wso2/wso2dataservices-2.5.1/repository/lib/h2-1.1.112.jar > with eclipse QuntumDB. I got user name and password error[8004-112]. > > I don't know if WSO2CARBON_DB.lobs.db are h2 db's. If it is, the is t an > embeded db? > > I checked > > C:\testcenter\release\wso2\wso2appserver-4.0.0\repository\database > > I found WSO2CARBON_DB.h2.db. This db is h2 from its name, but > WSO2CARBON_DB.lobs.db doesn't show us anything on its db type. > The DBs you have mentioned are the ones that are shipped with DS Server by default. I think I understand your question more clearly now. I'll sort it out and provide the way of doing it. > > Thanks anyway, I need to go to bed now. > no problem. Thanks and Regards, Harshana > > Xue-Feng > > > > ------------------------------ > *From:* Harshana Martin <[email protected]> > *To:* [email protected] > *Sent:* Sun, February 13, 2011 12:59:23 PM > > *Subject:* Re: [Carbon-dev] tryIt error for ShoppingCartDS in Carbon > Stadio > > Hi Xue-Feng, > > On Sun, Feb 13, 2011 at 10:00 AM, Xue-Feng Yang <[email protected]>wrote: > >> Hi Harshana, >> >> It is very funny for me to install h2 as an embedded database. It's not >> difficult to install h2 and other database. The problem is for an embedded >> database, it should have its own datasource name, jdbc url, username, >> password, and so on. The link you gave is about h2 general configuration, >> but not the configuration for WSO2 datasource. >> > > In that case, I think you can use the following article [1]. It explains > how to install a H2 as an embedded instance for the WSO2 governance > registry, > >> >> I don't know if you understand my question. >> > > Yes. Now I do know what do you mean :). > > [1]. > https://www.wso2.org/project/registry/3.0.0/docs/installation_guide/db_h2.html#embedded > > Thanks and Regards, > Harshana > >> >> Thanks, >> >> Xue-Feng >> >> >> >> ------------------------------ >> *From:* Harshana Martin <[email protected]> >> >> *To:* [email protected] >> *Sent:* Sun, February 13, 2011 12:17:35 PM >> >> *Subject:* Re: [Carbon-dev] tryIt error for ShoppingCartDS in Carbon >> Stadio >> >> Hi Xue-Feng, >> >> On Sun, Feb 13, 2011 at 9:42 AM, Xue-Feng Yang <[email protected]>wrote: >> >>> Hi Chathuri, >>> >>> Where can I find the details of the configuration information for the >>> embedded database h2? >>> >> >> I think this is what you are looking for [0]. >> >> [0]. http://wso2.org/blog/sumedha/3734 >> >> Thanks and Regards, >> Harshana >> >>> >>> Thanks, >>> >>> Xue-Feng >>> >>> ------------------------------ >>> *From:* Xue-Feng Yang <[email protected]> >>> >>> *To:* [email protected] >>> *Sent:* Sun, February 13, 2011 10:32:39 AM >>> >>> *Subject:* Re: [Carbon-dev] tryIt error for ShoppingCartDS in Carbon >>> Stadio >>> >>> Hi Chathuri, >>> >>> No. Since I used embedded database h2, I supposed not to do anything on >>> it. Is there any document I can use for the embedded database h2? >>> >>> Thanks, >>> >>> Xue-Feng >>> >>> ------------------------------ >>> *From:* Chathuri Wimalasena <[email protected]> >>> *To:* [email protected] >>> *Sent:* Sun, February 13, 2011 10:08:47 AM >>> *Subject:* Re: [Carbon-dev] tryIt error for ShoppingCartDS in Carbon >>> Stadio >>> >>> Hi Xue-Feng, >>> >>> Have you created legacy database by running with the SQL scripts >>> available under *shopping-cart/data-service/sql/h2 *?* *Error occurred since >>> the database is not available. Before you try-it the service, make sure that >>> the database is available. >>> >>> Regards, >>> Chathuri >>> >>> On Sun, Feb 13, 2011 at 6:36 AM, Xue-Feng Yang <[email protected]>wrote: >>> >>>> Hi All: >>>> >>>> I am testing the Shopping Cart sample in Carbon Stadio 1.0.3. I started >>>> dataservice from server for ShoppingCartDS. When I used tryIt for >>>> getAllCustomers, I have the following error message: >>>> >>>> Fault: DS Fault Message: Error in pre-fetching data Nested Exception:- >>>> javax.xml.stream.XMLStreamException: DS Fault Message: Error in >>>> 'createProcessedPreparedStatement' Source Data Service:- Name: >>>> ShoppingCartDS >>>> Location: >>>> >>>> C:\testcenter\release\wso2\wso2dataservices-2.5.1\repository\deployment\server\dataservices\ShoppingCartDS.dbs >>>> Description: N/A Default Namespace: com.acme.shoppingcart Current >>>> Request Name: >>>> getAllCustomers Current Params: {} Nested Exception:- >>>> org.h2.jdbc.JdbcSQLException: Table CUSTOMER not found; SQL statement: >>>> SELECT >>>> >>>> customerEmail,customerName,phone,addressLine1,addressLine2,city,state,postalCode,country >>>> FROM Customer [42102-112] [detail] >>>> <soapenv:Detail> >>>> <axis2ns1:DataServiceFault> >>>> >>>> DS Fault Message: Error in pre-fetching data >>>> Nested Exception:- >>>> javax.xml.stream.XMLStreamException: DS Fault Message: Error in >>>> 'createProcessedPreparedStatement' >>>> Source Data Service:- >>>> Name: ShoppingCartDS >>>> Location: >>>> >>>> C:\testcenter\release\wso2\wso2dataservices-2.5.1\repository\deployment\server\dataservices\ShoppingCartDS.dbs >>>> >>>> Description: N/A >>>> Default Namespace: com.acme.shoppingcart >>>> Current Request Name: getAllCustomers >>>> Current Params: {} >>>> Nested Exception:- >>>> org.h2.jdbc.JdbcSQLException: Table CUSTOMER not found; SQL statement: >>>> SELECT >>>> >>>> customerEmail,customerName,phone,addressLine1,addressLine2,city,state,postalCode,country >>>> FROM Customer [42102-112] >>>> >>>> >>>> </axis2ns1:DataServiceFault> >>>> </soapenv:Detail> >>>> >>>> >>>> >>>> _______________________________________________ >>>> 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 >>> >>> >> >> >> -- >> Harshana Martin >> Software Engineer >> WSO2 Inc. >> Web:http://wso2.com >> http://wso2.org >> >> Mobile: +94 716062650 >> Blog: http://harshana05.blogspot.com >> Profile: https://www.google.com/profiles/harshana05 >> Twitter: http://twitter.com/harshana05 >> >> >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> > > > -- > Harshana Martin > Software Engineer > WSO2 Inc. > Web:http://wso2.com > http://wso2.org > > Mobile: +94 716062650 > Blog: http://harshana05.blogspot.com > Profile: https://www.google.com/profiles/harshana05 > Twitter: http://twitter.com/harshana05 > > > > _______________________________________________ > Carbon-dev mailing list > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- Harshana Martin Software Engineer WSO2 Inc. Web:http://wso2.com http://wso2.org Mobile: +94 716062650 Blog: http://harshana05.blogspot.com Profile: https://www.google.com/profiles/harshana05 Twitter: http://twitter.com/harshana05
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
