shardingsphere集成达梦，使用分页插件 PageHelper.startPage(1,2);报错

wwding commented 2 hours ago

SELECT FROM ( SELECT TMP_PAGE., ROWNUM PAGEHELPER_ROW_ID FROM ( SELECT attendance_id,worker_Id,param,project_id,attendance_date,operation_type,update_Time AS createTime,update_Time FROM tf_b_attendance_mirror WHERE (project_id = ?) ) TMP_PAGE) WHERE PAGEHELPER_ROW_ID <= ? AND PAGEHELPER_ROW_ID > ?

    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
        <version>5.2.1</version>
    </dependency>

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException

org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException

The error may exist in com/example/demo/zhao/AttendanceMirrorMapper.java (best guess)

The error may involve com.example.demo.zhao.AttendanceMirrorMapper.selectList

The error occurred while executing a query

SQL: SELECT FROM ( SELECT TMP_PAGE., ROWNUM PAGEHELPER_ROW_ID FROM ( SELECT attendance_id,worker_Id,param,project_id,attendance_date,operation_type,update_Time AS createTime,update_Time FROM tf_b_attendance_mirror WHERE (project_id = ?) ) TMP_PAGE) WHERE PAGEHELPER_ROW_ID <= ? AND PAGEHELPER_ROW_ID > ?

Cause: org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException

linghengqian commented 2 hours ago

You should try shardingsphere 5.5.0.
You need to provide git with minimal reproducible unit tests, where your database should be created by testcontainers-java.
By the way, dm8 never provided docker image or testcontainer module for developers, and I think it is impossible to solve this problem in a public environment.

wwding commented 1 hour ago

shardingsphere 5.5.0. 和

org.apache.shardingsphere shardingsphere-jdbc-core-spring-boot-starter 5.2.1

不兼容

	丁稳稳

@. | ---- 回复的原邮件 ---- | 发件人 | Ling @.> | | 发送日期 | 2024年9月21日 12:36 | | 收件人 | @.> | | 抄送人 | @.>, @.***> | | 主题 | Re: [apache/shardingsphere] shardingsphere集成达梦，使用分页插件 PageHelper.startPage(1,2);报错 (Issue #32946) | You should try shardingsphere 5.5.0. You need to provide git with minimal reproducible unit tests, where your database should be created by testcontainers-java. By the way, dm8 never provided docker image or testcontainer module for developers, and I think it is impossible to solve this problem in a public environment.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

linghengqian commented 1 hour ago

You no longer need ShardingSphere Spring Boot Starter, it has been removed due to incompatibility with Spring Boot 3.
By the way, you exposed your private information when you replied via email.

wwding commented 1 hour ago

好的，我尝试一下，感谢

| | dingwenwen

@. | ---- 回复的原邮件 ---- | 发件人 | Ling @.> | | 发送日期 | 2024年9月21日 12:57 | | 收件人 | @.> | | 抄送人 | @.>, @.***> | | 主题 | Re: [apache/shardingsphere] shardingsphere集成达梦，使用分页插件 PageHelper.startPage(1,2);报错 (Issue #32946) | You no longer need ShardingSphere Spring Boot Starter, it has been removed due to incompatibility with Spring Boot 3. By the way, you exposed your private information when you replied via email.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

apache / shardingsphere