Skip to content

An error occurred when querying the database by pagination from Oracle 11g database #2993

@gaoxingxs

Description

@gaoxingxs

apache-drill version: 1.22.0
oracle version: 11g

The query will return an error when the SQL statement contains limit.

org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. 

Sql: SELECT *
FROM "APEX_030200"."WWV_FLOWS"
FETCH NEXT 10 ROWS ONLY
Fragment: 0:0

storage plugin:

{
  "type": "jdbc",
  "driver": "oracle.jdbc.OracleDriver",
  "url": "jdbc:oracle:thin:@//xxx.xxx.xxx.xxx:1521/orcl",
  "username": "xxx",
  "password": "xxx",
  "authMode": "SHARED_USER",
  "writerBatchSize": 10000,
  "enabled": true
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions