[wsas-java-dev] [jira] Assigned: (WSAS-635) Data service sample client fails

Charitha Kankanamge (JIRA) Wed, 02 Jan 2008 01:25:05 -0800

     [ http://wso2.org/jira/browse/WSAS-635?page=all ]


Charitha Kankanamge reassigned WSAS-635:
----------------------------------------

    Assignee: sumedha rubasinghe  (was: Afkham Azeez)

Assigned data service issue to Sumedha

> Data service sample client fails
> --------------------------------
>
>                 Key: WSAS-635
>                 URL: http://wso2.org/jira/browse/WSAS-635
>             Project: WSO2 WSAS
>          Issue Type: Bug
>          Components: data-services
>         Environment: winxp, jdk15, WSAS-2.2-QABuild1
>            Reporter: Charitha Kankanamge
>         Assigned To: sumedha rubasinghe
>            Priority: Critical
>
> The following error thrown while executing data service sample client.
> run-client-1:
>      [java] Requesting contact details of customers in Boston...
>      [java] <?xml version="1.0" encoding="UTF-8"?>
>      [java] <data:data xmlns:data="http://ws.wso2.org/dataservice";>
>      [java]     <fault>
>      [java]         <data:code>Error occurred while preparing prepared 
> statement for sql : select  * from Customers where city = 'Boston' and 
> country = 'USA'</data:code>
>      [java]         <data:detail>org.apache.axis2.AxisFault: Error occurred 
> while preparing prepared
>  statement for sql : select  * from Customers where city = 'Boston' and 
> country = 'USA'
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getProcessedPreparedStatement(DBUtils.java:943)
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getSelectResult(DBUtils.java:244)
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getRDBMSResult(DBUtils.java:142)
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.processSQLQuery(DBUtils.java:101)
>      [java]     at org.wso2.ws.dataservice.DBUtils.invoke(DBUtils.java:394)
>      [java]     at 
> org.wso2.ws.dataservice.DBMessageReceiver.invokeBusinessLogic(DBMessageReceiver.java:41)
>      [java]     at 
> org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:42)
>      [java]     at 
> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96)
>      [java]     at 
> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:148)
>      [java]     at 
> org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
>      [java]     at 
> org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:121)
>      [java]     at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>      [java]     at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>      [java]     at 
> org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:142)
> ;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>      [java]     at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>      [java]     at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>      [java]     at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>      [java]     at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> ;
>      [java]     at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>      [java]     at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>      [java]     at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)&#13;
>      [java]     at 
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnec
> tion(Http11BaseProtocol.java:667)&#13;
>      [java]     at 
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527
> )&#13;
>      [java]     at 
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerT
> hread.java:80)&#13;
>      [java]     at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684
> )&#13;
>      [java]     at java.lang.Thread.run(Thread.java:595)&#13;
>      [java] Caused by: SQL Exception: Schema 'WSAS' does not exist&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Sou
> rce)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> Source
> )&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.&lt;init&gt;(Unknown 
> Source)&#1
> 3;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.&lt;init&gt;(Unknown 
> Source)&
> #13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.&lt;init&gt;(Unknown 
> Source)&
> #13;
>      [java]     at 
> org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown 
> Source)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getProcessedPreparedStatement(DBUtils.java:898)&#
> 13;
>      [java]     ... 29 more&#13;
>      [java] </data:detail>
>      [java]     </fault>
>      [java] </data:data>
>      [java] Requesting employee contact details for employee number 1002...
>      [java] <?xml version="1.0" encoding="UTF-8"?>
>      [java] <data:data xmlns:data="http://ws.wso2.org/dataservice";>
>      [java]     <fault>
>      [java]         <data:code>Error occurred while preparing prepared 
> statement for sql : select *
> from Employees where employeeNumber = ?</data:code>
>      [java]         <data:detail>org.apache.axis2.AxisFault: Error occurred 
> while preparing prepared
>  statement for sql : select * from Employees where employeeNumber = ?&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getProcessedPreparedStatement(DBUtils.java:943)&#
> 13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getSelectResult(DBUtils.java:244)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getRDBMSResult(DBUtils.java:142)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.processSQLQuery(DBUtils.java:101)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.invoke(DBUtils.java:394)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBMessageReceiver.invokeBusinessLogic(DBMessageReceiver.j
> ava:41)&#13;
>      [java]     at 
> org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(A
> bstractInOutSyncMessageReceiver.java:42)&#13;
>      [java]     at 
> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceive
> r.java:96)&#13;
>      [java]     at 
> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:148)&#13;
>      [java]     at 
> org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTra
> nsportUtils.java:275)&#13;
>      [java]     at 
> org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:121)&#13;
>      [java]     at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709)&#13;
>      [java]     at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)&#13;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilte
> rChain.java:252)&#13;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.j
> ava:173)&#13;
>      [java]     at 
> org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:142)&#13
> ;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilte
> rChain.java:202)&#13;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.j
> ava:173)&#13;
>      [java]     at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:21
> 3)&#13;
>      [java]     at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:17
> 8)&#13;
>      [java]     at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)&#13
> ;
>      [java]     at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)&#13
> ;
>      [java]     at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> &#13;
>      [java]     at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)&#13;
>      [java]     at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)&#13;
>      [java]     at 
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnec
> tion(Http11BaseProtocol.java:667)&#13;
>      [java]     at 
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527
> )&#13;
>      [java]     at 
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerT
> hread.java:80)&#13;
>      [java]     at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684
> )&#13;
>      [java]     at java.lang.Thread.run(Thread.java:595)&#13;
>      [java] Caused by: SQL Exception: Schema 'WSAS' does not exist&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Sou
> rce)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> Source
> )&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.&lt;init&gt;(Unknown 
> Source)&#1
> 3;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.&lt;init&gt;(Unknown 
> Source)&
> #13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.&lt;init&gt;(Unknown 
> Source)&
> #13;
>      [java]     at 
> org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown 
> Source)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getProcessedPreparedStatement(DBUtils.java:898)&#
> 13;
>      [java]     ... 29 more&#13;
>      [java] </data:detail>
>      [java]     </fault>
>      [java] </data:data>
>      [java] Requestinng customer address for Jean King...
>      [java] <?xml version="1.0" encoding="UTF-8"?>
>      [java] <data:data xmlns:data="http://ws.wso2.org/dataservice";>
>      [java]     <fault>
>      [java]         <data:code>Error occurred while preparing prepared 
> statement for sql : select *
> from Customers where contactLastName = ? and contactFirstName = ?</data:code>
>      [java]         <data:detail>org.apache.axis2.AxisFault: Error occurred 
> while preparing prepared
>  statement for sql : select * from Customers where contactLastName = ? and 
> contactFirstName = ?&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getProcessedPreparedStatement(DBUtils.java:943)&#
> 13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getSelectResult(DBUtils.java:244)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getRDBMSResult(DBUtils.java:142)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.processSQLQuery(DBUtils.java:101)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.invoke(DBUtils.java:394)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBMessageReceiver.invokeBusinessLogic(DBMessageReceiver.j
> ava:41)&#13;
>      [java]     at 
> org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(A
> bstractInOutSyncMessageReceiver.java:42)&#13;
>      [java]     at 
> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceive
> r.java:96)&#13;
>      [java]     at 
> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:148)&#13;
>      [java]     at 
> org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTra
> nsportUtils.java:275)&#13;
>      [java]     at 
> org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:121)&#13;
>      [java]     at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709)&#13;
>      [java]     at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)&#13;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilte
> rChain.java:252)&#13;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.j
> ava:173)&#13;
>      [java]     at 
> org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:142)&#13
> ;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilte
> rChain.java:202)&#13;
>      [java]     at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.j
> ava:173)&#13;
>      [java]     at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:21
> 3)&#13;
>      [java]     at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:17
> 8)&#13;
>      [java]     at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)&#13
> ;
>      [java]     at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)&#13
> ;
>      [java]     at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> &#13;
>      [java]     at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)&#13;
>      [java]     at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)&#13;
>      [java]     at 
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnec
> tion(Http11BaseProtocol.java:667)&#13;
>      [java]     at 
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527
> )&#13;
>      [java]     at 
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerT
> hread.java:80)&#13;
>      [java]     at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684
> )&#13;
>      [java]     at java.lang.Thread.run(Thread.java:595)&#13;
>      [java] Caused by: SQL Exception: Schema 'WSAS' does not exist&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Sou
> rce)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> Source
> )&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.&lt;init&gt;(Unknown 
> Source)&#1
> 3;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.&lt;init&gt;(Unknown 
> Source)&
> #13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.&lt;init&gt;(Unknown 
> Source)&
> #13;
>      [java]     at 
> org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown 
> Source)&#13;
>      [java]     at 
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown 
> Source)&#13;
>      [java]     at 
> org.wso2.ws.dataservice.DBUtils.getProcessedPreparedStatement(DBUtils.java:898)&#
> 13;
>      [java]     ... 29 more&#13;
>      [java] </data:detail>
>      [java]     </fault>
>      [java] </data:data>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

_______________________________________________
Wsas-java-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev

[wsas-java-dev] [jira] Assigned: (WSAS-635) Data service sample client fails

Reply via email to