GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — oracle下查询分页问题 · Issue #162 · APIJSON/APIJSON

oracle下查询分页问题 #162

New issue
Copy link
New issue
Copy link
Closed
Closed
oracle下查询分页问题#162
Copy link
Labels
Bug 漏洞Oraclehelp wanted请求帮助请求帮助

Description

@dream-t-mac
dream-t-mac
opened on Nov 27, 2020
Issue body actions

环境信息

  • 系统: Windows 10
  • JDK: 1.8.0_17
  • 数据库: Oracle 11.2.0.4.0
  • APIJSON: 4.2.5

问题描述

APIJSONDemo
连接Oracle数据源，启动报错

错误信息
image

分析可能原因：oracle分页语法问题
image

image

Activity

  1. TommyLemon
    added
    Bug 漏洞
    help wanted请求帮助请求帮助
    on Nov 28, 2020

  2. kxlv2000 commented on Mar 12, 2021

    @kxlv2000
    kxlv2000
    on Mar 12, 2021
    Contributor
    More actions

    您好，
    请问问题解决了吗，可以允许我尝试修复此问题吗？

  3. TommyLemon commented on Mar 12, 2021

    @TommyLemon
    TommyLemon
    on Mar 12, 2021
    Member
    More actions

    您好，
    请问问题解决了吗，可以允许我尝试修复此问题吗？

    还没有，可以的哦，非常感谢~
    https://github.com/Tencent/APIJSON/blob/master/CONTRIBUTING.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%80%E5%AE%9A%E8%A6%81%E8%B4%A1%E7%8C%AE%E4%BB%A3%E7%A0%81

  4. chenpanpan0809 commented on Mar 23, 2021

    @chenpanpan0809
    chenpanpan0809
    on Mar 23, 2021
    More actions

    您好，我想问一下这个问题解决吗，我现在也遇到这个问题了

  5. kxlv2000 commented on Mar 23, 2021

    @kxlv2000
    kxlv2000
    on Mar 23, 2021 via email
    Contributor
    More actions
    您好，暂时还没有完成修复，我们是 SUSTech 的计算机本科生，选择了多个包括此 issue 在内的 issue，作为我们本学期课程的实践课题。如果您有急需的话，我们可以尝试优先修复此问题，还请您理解，谢谢！
    …
    2021年3月23日 15:00，chenpanpan0809 ***@***.***> 写道： 您好，我想问一下这个问题解决吗，我现在也遇到这个问题了 — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#162 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALYC7MN23ANROP3HVVS3W63TFA4CTANCNFSM4UEWIWAA>.
    Reacted by TommyLemon

  6. chenpanpan0809 commented on Mar 23, 2021

    @chenpanpan0809
    chenpanpan0809
    on Mar 23, 2021
    More actions

    好的，谢谢了，希望这个问题能尽快解决。

  7. TommyLemon commented on Apr 8, 2021

    @TommyLemon
    TommyLemon
    on Apr 8, 2021
    Member
    More actions

    您好，暂时还没有完成修复，我们是 SUSTech 的计算机本科生，选择了多个包括此 issue 在内的 issue，作为我们本学期课程的实践课题。如果您有急需的话，我们可以尝试优先修复此问题，还请您理解，谢谢！
    …
    2021年3月23日 15:00，chenpanpan0809 @.***> 写道： 您好，我想问一下这个问题解决吗，我现在也遇到这个问题了 — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#162 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALYC7MN23ANROP3HVVS3W63TFA4CTANCNFSM4UEWIWAA.

    确实很需要，非常欢迎和感谢修复问题~
    这个应该是由于 Oracle 12 以下不支持 OFFSET FETCH 分页语法导致的，
    得换成 ROW_NUMBER 加子查询解决，改动很大，优先级可以放低些

  8. TommyLemon
    added
    Oracle
    on May 26, 2022

  9. TommyLemon commented on Aug 10, 2022

    @TommyLemon
    TommyLemon
    on Aug 10, 2022
    Member
    More actions

    非常感谢 @kxlv2000 解决了这个问题~
    #223

  10. TommyLemon
    closed this as completedon Aug 10, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Bug 漏洞Oraclehelp wanted请求帮助请求帮助

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions
      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.