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. Thanks anyway, I need to go to bed now. 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
