Hi Xue-Feng, Since you are trying to run ShoppingCart sample, I think you have an easier solution. ShoppingCart sample is one of the samples ships with WSO2 Data Services Server. Therefore you can follow the sample guide in your Data Services server installation[2]. It provides a way to run the sample in the manner you need without worrying about other configuration details.
[2]. http://wso2.org/project/solutions/data-services/java/2.5.0/docs/samples/deploying_samples.html Thanks and Regards, Harshana On Sun, Feb 13, 2011 at 10:29 AM, Harshana Martin <[email protected]> wrote: > 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 > > -- 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
