[Carbon-jira] [jira] Created: (CARBON-11034) DSS throws an error when calling oracle in-only stored procedure

[Dinusha Dilrukshi (JIRA)]

DSS throws an error when calling oracle in-only stored procedure
----------------------------------------------------------------

                 Key: CARBON-11034
                 URL: https://wso2.org/jira/browse/CARBON-11034
             Project: WSO2 Carbon
          Issue Type: Bug
          Components: Data Services
    Affects Versions: 3.2.0
         Environment: oracle 10g
wso2dataservices-2.6.0

            Reporter: Dinusha Dilrukshi 
            Assignee: Dinusha Dilrukshi 
            Priority: High


1. Create a in-only stored procedure and create a data service to access it.

2. Server throws following error when accessing the operation through try-it.

[2011-07-25 17:13:25,865]  WARN {org.wso2.carbon.dataservices.core.description.query.SQLQuery} -  Error in processing batch query support for query 'query1' batch query support is disabled: DS Fault Message: Error in retrieving database metadata
DS Code: UNKNOWN_ERROR
Nested Exception:-
java.sql.SQLException: Invalid operation for forward only resultset : isLast

DS Fault Message: Error in retrieving database metadata
DS Code: UNKNOWN_ERROR
Nested Exception:-
java.sql.SQLException: Invalid operation for forward only resultset : isLast

    at org.wso2.carbon.dataservices.core.description.query.SQLQuery.calculateBatchQuerySupport(SQLQuery.java:268)
    at org.wso2.carbon.dataservices.core.description.query.SQLQuery.init(SQLQuery.java:176)
    at org.wso2.carbon.dataservices.core.description.query.SQLQuery.<init>(SQLQuery.java:152)
    at org.wso2.carbon.dataservices.core.description.query.QueryFactory.createSQLQuery(QueryFactory.java:301)
    at org.wso2.carbon.dataservices.core.description.query.QueryFactory.createQuery(QueryFactory.java:60)
    at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataServiceFactory.java:164)
    at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:639)
    at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:990)
    at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:168)
    at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
    at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:813)
    at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
    at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:371)
    at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254)
    at org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListener.java:365)
    at org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(SchedulerTask.java:73)
    at org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:94)
    at org.apache.axis2.deployment.scheduler.Scheduler$SchedulerTimerTask.run(Scheduler.java:93)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: Invalid operation for forward only resultset : isLast
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:349)
    at org.apache.commons.dbcp.DelegatingResultSet.isLast(DelegatingResultSet.java:355)
    at org.wso2.carbon.dataservices.core.description.query.SQLQuery.getStoredProcFuncProps(SQLQuery.java:228)
    at org.wso2.carbon.dataservices.core.description.query.SQLQuery.calculateBatchQuerySupport(SQLQuery.java:238)
    ... 19 more

3. When restarting, server starts with the same exception as above, but operation invokes fine. 

-- 
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