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
