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
