Hi Harshana, Sorry for a typo. The correct statement was:
The sample you quoted is not the ShoppingCart sample. ShoppingCart sample I download from SVN repository is not an ant build project, instead it is a maven project. Thanks, Xue-Feng ________________________________ From: Xue-Feng Yang <[email protected]> To: [email protected] Sent: Sun, February 13, 2011 1:31:00 PM Subject: Re: [Carbon-dev] tryIt error for ShoppingCartDS in Carbon Stadio Hi Harshana, The sample you quoted is the ShoppingCart sample. ShoppingCart sample I download from SVN repository is not an ant build project, instead it is a maven project. Thanks, Xue-Feng ________________________________ From: Harshana Martin <[email protected]> To: [email protected] Sent: Sun, February 13, 2011 1:20:52 PM Subject: Re: [Carbon-dev] tryIt error for ShoppingCartDS in Carbon Stadio 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
