You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/07/31 07:02:21 UTC
[GitHub] [shardingsphere] Spole0168 opened a new issue #6550: help sharingjdbc4.0.1 oracle page
Spole0168 opened a new issue #6550:
URL: https://github.com/apache/shardingsphere/issues/6550
I am using the 4.0.1 version of sharingjdbc to link to the oracle database and encounter problems with paging display data.
Currently sharingjdbc supports nesting of subqueries once, but Oracle paging can only be achieved by nesting twice with rownum. The recommendation on the official website is the same. When using it, it will report an error "Must have sharding column with subquery", just remove one level of nesting.
How to deal with Oracle paging?
Official suggestion link:
https://shardingsphere.apache.org/document/legacy/4.x/document/cn/features/sharding/use-norms/pagination/
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #6550: help sharingjdbc4.0.1 oracle page
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6550:
URL: https://github.com/apache/shardingsphere/issues/6550#issuecomment-667830221
Hi @Spole0168 Release has bad support for `subquery`. My suggestions are,
1. Make your SQL not contain `subquery`
2. Use our `master branch` for a test, since `master branch` has many improvements for `subquery.`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #6550: help sharingjdbc4.0.1 oracle page
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6550:
URL: https://github.com/apache/shardingsphere/issues/6550
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #6550: help sharingjdbc4.0.1 oracle page
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6550:
URL: https://github.com/apache/shardingsphere/issues/6550
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Spole0168 commented on issue #6550: help sharingjdbc4.0.1 oracle page
Posted by GitBox <gi...@apache.org>.
Spole0168 commented on issue #6550:
URL: https://github.com/apache/shardingsphere/issues/6550#issuecomment-667846392
Thank you very much,
currently shardingjdbc4.0.1 version cannot perform oracle paging.
I try other versions.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org