SpringBoot+myBatisPlus+sharding-jdbc数据源分页查询类型
转换问题
在实际项⽬中涉及到多数据源和分表，所以采⽤了shardingsphere，为了简化代码，引⼊了mybatis plus
版本：
mybatis plus：3.3.2
springboot：2.1.5
shardingsphere ： 4.0.0-RC2
错误信息：
Caud by: batis.spring.MyBatisSystemException: nested exception is org.ptions.PersistenceException:
### Error querying databa. Cau: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
### The error may exist in com/cxm/db/mapper/bi/CxmBiDemoDAO.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while tting parameters
英文词典### SQL: SELECT id,incread_stall_count FROM cxm_bi_demo LIMIT ?,?
### Cau: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
batis.anslateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
batis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy150.lectList(Unknown Source)
batis.spring.SqlSessionTemplate.lectList(SqlSessionTemplate.java:223)
at uteForIPage(MybatisMappe
rMethod.java:134)
at ute(MybatisMapperMethod.java:96)
滨才英语at verride.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
amendat com.sun.proxy.$Proxy157.lectPage(Unknown Source)
花的英文怎么写vice.CxmBaServiceImpl.page(CxmBaServiceImpl.java:292)
vice.CxmBaServiceImpl.page(CxmBaServiceImpl.java:307)
vice.CxmBaServiceImpl$$FastClassBySpringCGLIB$$5d9c5448.invoke(<generated>)
at lib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvidInterceptor.intercept(CglibAopProxy.java:684)
vice.impl.CxmBiDemoServiceImpl$$EnhancerBySpringCGLIB$$e0e43073.page(<generated>)
internal>smap成员
vice.impl.CxmBiDailyIncreadStatisticServiceImpl.queryIn(CxmBiDailyIncreadStatisticServiceImpl.java:86)
vice.impl.CxmBiDailyIncreadStatisticServiceImpl$$FastClassBySpringCGLIB$$588bac5b.invoke(<generated>)
网店营销at lib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at org.springframework.aop.interceptor.ExpoInvocationInterceptor.invoke(ExpoInvocationInterceptor.java:93)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvidInterceptor.intercept(CglibAopProxy.java:688)
vice.impl.CxmBiDailyIncreadStatisticServiceImpl$$EnhancerBySpringCGLIB$$bbed46d4.queryIn(<generated>)
CxmRetailApplication.run(CxmRetailApplication.java:68)
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:813)
... 5 common frames omitted
Caud by: org.ptions.PersistenceException:
### Error querying databa. Cau: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
### The error may exist in com/cxm/db/mapper/bi/CxmBiDemoDAO.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while tting parameters
### SQL: SELECT id,incread_stall_count FROM cxm_bi_demo LIMIT ?,?
### Cau: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
at org.ptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.ssion.defaults.DefaultSqlSession.lectList(DefaultSqlSession.java:149)
at org.apache.ibatis.ssion.defaults.DefaultSqlSession.lectList(DefaultSqlSession.java:140)
flect.NativeMethodAccessorImpl.invoke0(Native Method)
flect.NativeMethodAccessorImpl.invoke0(Native Method)
flect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at flect.Method.invoke(Method.java:498)
batis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 32 common frames omitted
Caud by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
at org.lect.Value(Pagination.java:60)
at org.lect.pagination.Pagination.<init>(Pagination.java:54)
at org.atePagination(LimitPaginationEngine.java:40) at org.atePagination(PaginationEngine.java:50)
at org.ie.dml.ShardingSelectOptimizeEngine.optimize(ShardingSelectOptimizeEngine.java:63)
at org.ie.dml.ShardingSelectOptimizeEngine.optimize(ShardingSelectOptimizeEngine.java:47)
at org.uter.ute(ParsingSQLRouter.java:72)
at org.ute(PreparedStatementRoutingEngine.java:66)
at org.ute(PreparedQueryShardingEngine.java:60)
at org.uteRoute(BaShardingEngine.java:86)
at org.BaShardingEngine.shard(BaShardingEngine.java:70)
at org.apache.shardingsphere.statement.ShardingPreparedStatement.shard(ShardingPreparedStatement.java:224)
at org.apache.shardingsphere.ute(ShardingPreparedStatement.java:170)
flect.NativeMethodAccessorImpl.invoke0(Native Method)
flect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at flect.Method.invoke(Method.java:498)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
at com.sun.proxy.$ute(Unknown Source)
at org.utor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
at org.utor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
flect.NativeMethodAccessorImpl.invoke0(Native Method)
flect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
学习 英语at flect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy226.query(Unknown Source)
at utor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67)
at org.utor.BaExecutor.queryFromDataba(BaExecutor.java:324)
at org.utor.BaExecutor.query(BaExecutor.java:156)
at utor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:163)
at utor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:90)
at org.apache.ibatis.ssion.defaults.DefaultSqlSession.lectList(DefaultSqlSession.java:147)
... 38 common frames omitted
问题分析：
追踪⽇志，查看源码发现是由于shardingsphere的Pagination中有⼀个类型转换直接写死为int类型导致的，
因为分页参数⾥⾯穿的值是Long的类型，⽽下⾯这个⽅法直接强制转换为int，所以导致出错
private int getValue(final PaginationValueSegment paginationValueSegment, final List<Object> parameters) {
return paginationValueSegment instanceof ParameterMarkerPaginationValueSegment
(int) (((ParameterMarkerPaginationValueSegment) paginationValueSegment).getParameterIndex())
: ((NumberLiteralPaginationValueSegment) paginationValueSegment).getValue();
}
aglow因为mybatisplus的分页对象IPage⾥⾯的属性是long
解决⽅案：
1：⾃定义实现adata.IPage;，
cushion
将 private long size;private long current; 修改为int 类型可以修复这个问题，但没有进⾏覆盖测试，不知道是否会引起其他问题2：重新shardingsphere的Pagination
3：弃⽤shardingsphere-core，分库分表采⽤阿⾥云的组建，多数据源采⽤AbstractRoutingDataSource⾃定义注解实现
