[Ds-java-dev] [jira] Closed: (DS-337) DeptUpdateService.dbs sample error

[Anushka Dayananda (JIRA)]

     [ https://wso2.org/jira/browse/DS-337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anushka Dayananda closed DS-337.
--------------------------------


> DeptUpdateService.dbs sample error
> ----------------------------------
>
>                 Key: DS-337
>                 URL: https://wso2.org/jira/browse/DS-337
>             Project: WSO2 Data Services
>          Issue Type: Bug
>          Components: UI
>    Affects Versions:  1.0-beta13
>         Environment: Win XP, JDK 1.5, FF2
>            Reporter: Anushka Dayananda
>            Assignee: Tyrell Perera
>
> Steps to recreate
> ------------------
> 1. Go to "Upload"
> 2. Browse DeptUpdateService.dbs from Samples/dbs
> 3. Upload the db
> Issue
> -----
> Try it fails
> Stacktrace
> [2008-08-25 14:28:50,703] ERROR -  [DeptUpdateService]  Error occurred while preparing prepared statement for sql : insert into department (id,na
> me) values (?,?) {org.apache.axis2.engine.AxisEngine}
> org.apache.axis2.AxisFault: [DeptUpdateService]  Error occurred while preparing prepared statement for sql : insert into department (id,name) val
> ues (?,?)
>         at org.wso2.dataservices.DBUtils.getProcessedPreparedStatement(DBUtils.java:1553)
>         at org.wso2.dataservices.DBUtils.getSelectResult(DBUtils.java:624)
>         at org.wso2.dataservices.DBUtils.getRDBMSResult(DBUtils.java:163)
>         at org.wso2.dataservices.DBUtils.processSQLQuery(DBUtils.java:100)
>         at org.wso2.dataservices.DBUtils.invoke(DBUtils.java:843)
>         at org.wso2.dataservices.DBMessageReceiver.invokeBusinessLogic(DBMessageReceiver.java:41)
>         at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:42)
>         at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
>         at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
>         at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
>         at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:133)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
>         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
>         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:116)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
>         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: Schema 'WSAS' does not exist
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>         at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>         at org.wso2.dataservices.DBUtils.getProcessedPreparedStatement(DBUtils.java:1410)
>         ... 32 more
> Caused by: ERROR 42Y07: Schema 'WSAS' does not exist
>         at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>         at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
>         at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
>         at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
>         at org.apache.derby.impl.sql.compile.DMLModStatementNode.verifyTargetTable(Unknown Source)
>         at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(Unknown Source)
>         at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>         at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>         at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
>         ... 39 more

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