te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>java - i cant paginate with oracleDialect - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>java - i cant paginate with oracleDialect - Stack Overflow

    java - i cant paginate with oracleDialect - Stack Overflow

    programmeradmin3浏览0评论

    database-platform: .hibernate.dialect.OracleDialect

    when im using oracle dialect i got error here is my pagination

     Pageable pageable = PageRequest.of(page, size);
 Page<Rate> rates = rateRepository.findAll(pageable);

    my springboot version is 3.4.0 java version 17

    here is what exception im getting postman when im trying to paginate .springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL

    when im trying to use oracle12cdialect im getting no class found error

     Pageable pageable = PageRequest.of(page, size);
 Page<Rate> rates = rateRepository.findAll(pageable);

    my springboor version is 3.4.0 java version 17

    here is what exception i getin postman when i trying to paginate .springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select r1_0.rate_id,r1_0ments,r1_0.created_at,r1_0.rating_star,r1_0.remote_address,r1_0.updated_at from ms_web_rate r1_0 offset ? rows fetch first ? rows only] [ORA-00933: SQL command not properly ended\n\r\n/] [n/a]; SQL [n/a]",

    database-platform: .hibernate.dialect.OracleDialect

    when im using oracle dialect i got error here is my pagination

     Pageable pageable = PageRequest.of(page, size);
 Page<Rate> rates = rateRepository.findAll(pageable);

    my springboot version is 3.4.0 java version 17

    here is what exception im getting postman when im trying to paginate .springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL

    when im trying to use oracle12cdialect im getting no class found error

     Pageable pageable = PageRequest.of(page, size);
 Page<Rate> rates = rateRepository.findAll(pageable);

    my springboor version is 3.4.0 java version 17

    here is what exception i getin postman when i trying to paginate .springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select r1_0.rate_id,r1_0ments,r1_0.created_at,r1_0.rating_star,r1_0.remote_address,r1_0.updated_at from ms_web_rate r1_0 offset ? rows fetch first ? rows only] [ORA-00933: SQL command not properly ended\n\r\nhttps://docs.oracle/error-help/db/ora-00933/] [n/a]; SQL [n/a]",

    • java
    • oracle-database
    • spring-boot
    Share Improve this question edited Feb 17 at 14:14 Ilyas Azizzade asked Feb 17 at 14:07 Ilyas AzizzadeIlyas Azizzade 11 bronze badge New contributor Ilyas Azizzade is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. 3
    • 1 Post whole exception text. It should contain actual SQL causing error. – talex Commented Feb 17 at 14:10
    • 1 Please edit the question and include a minimal reproducible example including: the SQL that is being generated; the text/stack trace for the exception; and sufficient code to be able to replicate the issue. – MT0 Commented Feb 17 at 14:11
    • You have said you are using oracle12cdialect but you haven't said which database version you are using. The row limiting syntax with offset/fetch is only available from 12cR1 (12.1) onwards - so are you maybe working with an 11g (or even earlier) database - where it will get that error? – Alex Poole Commented Feb 17 at 16:11
    Add a comment  | 

    1 Answer 1

    Reset to default 0

    Try just using

    spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

    no need to specify .hibernate.dialect anymore, the metadata of the database should be accessed to determine the capabilities, and thus not using "offset ... rows fetch ..." if not yet available.

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论