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.
I don't know if you understand my question. 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
