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

Tue, 04 Dec 2007 23:33:05 -0800 

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: Afkham Azeez
            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

Reply via email to