Uploaded image for project: 'ZZZ-WSO2 Data Services Server'
  1. ZZZ-WSO2 Data Services Server
  2. DS-1197

Error when trying to activate OData against an Oracle schema database

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.5.1-Beta, 3.5.1
    • Component/s: None
    • Labels:
      None
    • Severity:
      Major
    • Estimated Complexity:
      Moderate
    • Test cases added:
      Yes

      Description

      When we enable the OData with Oracle database getting the following error:

      [2016-05-12 16:06:28,387] ERROR

      {org.wso2.carbon.dataservices.core.DBDeployer}

      - The test1.dbs service, which is not valid, caused

      {1}

      DS Fault Message: OData Service Fault : Error in reading table meta data in EXPORT_JOB_SQLDEV_217 table. :Invalid column index: getValidColumnIndex

      DS Code: UNKNOWN_ERROR

      Nested Exception:-

      java.sql.SQLException: Invalid column index: getValidColumnIndex

      at org.wso2.carbon.dataservices.core.odata.RDBMSDataHandler.readTableColumnMetaData(RDBMSDataHandler.java:999)
      at org.wso2.carbon.dataservices.core.odata.RDBMSDataHandler.initializeMetaData(RDBMSDataHandler.java:1021)
      at org.wso2.carbon.dataservices.core.odata.RDBMSDataHandler.<init>(RDBMSDataHandler.java:109)
      at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.createODataHandler(RDBMSConfig.java:64)
      at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:797)
      at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:1139)
      at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:195)
      at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
      at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:807)
      at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
      at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:377)
      at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254)
      at org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListener.java:371)
      at org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(SchedulerTask.java:59)
      at org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:67)
      at org.wso2.carbon.core.deployment.CarbonDeploymentSchedulerTask.runAxisDeployment(CarbonDeploymentSchedulerTask.java:93)
      at org.wso2.carbon.core.deployment.CarbonDeploymentSchedulerTask.run(CarbonDeploymentSchedulerTask.java:138)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
      at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      at java.lang.Thread.run(Thread.java:722)
      Caused by: java.sql.SQLException: Invalid column index: getValidColumnIndex
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
      at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:143)
      at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:279)
      at org.wso2.carbon.dataservices.core.odata.RDBMSDataHandler.readTableColumnMetaData(RDBMSDataHandler.java:978)
      ... 24 more

        Attachments

          Activity

            People

            • Assignee:
              madhawag@wso2.com Madhawa Gunasekara
              Reporter:
              keerthika@wso2.com Keerthika Mahendralingam
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: