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

Open
#2,993 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
java, sql
Domain
databases

Research direction

Start by reproducing the reported pagination query against Oracle 11g through the JDBC storage plugin. Trace how the plugin generates the FETCH NEXT SQL and verify that the query executes successfully without the reported setup error.

Written by the indexing model from the issue text.

Description

bug

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
}
Dominant language
Java
Stars
2k
Forks
989
Avg merge
1d 8h
Merged PRs (30d)
5

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/drill

All issues in apache/drill

Similar issues

More Java issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.