2
回答
sharding-jdbc 不拆分数据表分页问题
华为云实践训练营,热门技术免费实践!>>>   

最近使用sharding-jdbc1.5.3单库分表的过程中其中一些不需要拆分的数据表进行分页查询只能查询到第一页的数据,以下是我的sharidng-jdbc配置如下:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:rdb="http://www.dangdang.com/schema/ddframe/rdb"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans.xsd
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context.xsd
                        http://www.dangdang.com/schema/ddframe/rdb
                        http://www.dangdang.com/schema/ddframe/rdb/rdb.xsd
                        ">
<!-- 数据源配置, 使用DBCP数据库连接池 -->
		<bean id="db-node-0" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" >
			<!-- Connection Info -->
			<property name="driverClassName" value="${jdbc.driver}" />
			<property name="url" value="${jdbc.url}" />
			<property name="username" value="${jdbc.username}" />
			<property name="password" value="${jdbc.password}" />
		
			<!-- Connection Pooling Info -->
			<property name="maxActive" value="${dbcp.maxActive}" />
			<property name="maxIdle" value="${dbcp.maxIdle}" />
			<property name="defaultAutoCommit" value="false" />
			<!-- 连接Idle一个小时后超时 -->
			<property name="timeBetweenEvictionRunsMillis" value="3600000" />
			<property name="minEvictableIdleTimeMillis" value="3600000" />
		</bean>
		<bean id="db-node-1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" >
			<!-- Connection Info -->
			<property name="driverClassName" value="${jdbc.driver}" />
			<property name="url" value="${jdbc.url}" />
			<property name="username" value="${jdbc.username}" />
			<property name="password" value="${jdbc.password}" />

			<!-- Connection Pooling Info -->
			<property name="maxActive" value="${dbcp.maxActive}" />
			<property name="maxIdle" value="${dbcp.maxIdle}" />
			<property name="defaultAutoCommit" value="false" />
			<!-- 连接Idle一个小时后超时 -->
			<property name="timeBetweenEvictionRunsMillis" value="3600000" />
			<property name="minEvictableIdleTimeMillis" value="3600000" />
		</bean>
    <!--分表规则-->
    <rdb:strategy id="pcardIndexStrategy" sharding-columns="fkxlh" algorithm-class="com.wondersgroup.framework.algorithm.SingleKeyModuloTableShardingAlgorithm"/>

    <rdb:data-source id="dataSource" >
        <rdb:sharding-rule data-sources="db-node-0" default-data-source="db-node-1">
            <rdb:table-rules>
                <rdb:table-rule logic-table="cmp_card_info" actual-tables="cmp_card_info,cmp_card_info2" table-strategy="pcardIndexStrategy"/>
                <rdb:table-rule logic-table="security_user" actual-tables="security_user"/>
                <rdb:table-rule logic-table="security_user_role" actual-tables="security_user_role"/>
                <rdb:table-rule logic-table="security_organization" actual-tables="security_organization"/>
                <rdb:table-rule logic-table="security_organization_role" actual-tables="security_organization_role"/>
                <rdb:table-rule logic-table="tb_pcard_index" actual-tables="tb_pcard_index"/>

            </rdb:table-rules>
            <rdb:binding-table-rules>
                <rdb:binding-table-rule logic-tables="cmp_card_info"/>
            </rdb:binding-table-rules>
            <rdb:default-database-strategy sharding-columns="none" algorithm-class="com.dangdang.ddframe.rdb.sharding.api.strategy.database.NoneDatabaseShardingAlgorithm"/>
            <rdb:default-table-strategy sharding-columns="none" algorithm-class="com.dangdang.ddframe.rdb.sharding.api.strategy.table.NoneTableShardingAlgorithm"/>
        </rdb:sharding-rule>
        <rdb:props>
            <prop key="metrics.enable">true</prop>
            <prop key="sql.show">true</prop>
        </rdb:props>
    </rdb:data-source>
</beans>

查询第一页数据打印日志如下:

12:12:58.252 [qtp1902693237-47] INFO  Sharding-JDBC-SQL[59] - Logic SQL: select count(*) as col_0_0_ from pss_request_note requestnot0_ where 1=1
12:12:58.253 [qtp1902693237-47] INFO  Sharding-JDBC-SQL[59] - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=pss_request_note, alias=Optional.of(requestnot0_))]), conditions=Conditions(conditions={}), sqlTokens=[TableToken(beginPosition=33, originalLiterals=pss_request_note)], parametersIndex=0)), containStar=false, selectListLastPosition=28, groupByLastPosition=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(*), alias=Optional.of(col_0_0_), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
12:12:58.253 [qtp1902693237-47] INFO  Sharding-JDBC-SQL[59] - Actual SQL: db-node-0 ::: select count(*) as col_0_0_ from pss_request_note requestnot0_ where 1=1
12:12:58.258 [qtp1902693237-47] WARN  o.h.e.j.internal.JdbcCoordinatorImpl[384] - HHH000387: ResultSet's statement was not registered
12:12:58.340 [qtp1902693237-47] INFO  Sharding-JDBC-SQL[59] - Logic SQL: select requestnot0_.id as id1_44_, requestnot0_.audit_date as audit2_44_, requestnot0_.audit_user as audit3_44_, requestnot0_.create_date as create4_44_, requestnot0_.create_user as create5_44_, requestnot0_.obsolete_date as obsolete6_44_, requestnot0_.obsolete_explain as obsolete7_44_, requestnot0_.obsolete_user as obsolete8_44_, requestnot0_.reject_date as reject9_44_, requestnot0_.reject_explain as reject10_44_, requestnot0_.reject_user as reject11_44_, requestnot0_.submit_date as submit12_44_, requestnot0_.submit_user as submit13_44_, requestnot0_.areab as areab14_44_, requestnot0_.auto_flag as auto15_44_, requestnot0_.bank_code as bank16_44_, requestnot0_.bank_flag as bank17_44_, requestnot0_.bank_name as bank18_44_, requestnot0_.bank_net_id as bank19_44_, requestnot0_.card_type as card20_44_, requestnot0_.code as code21_44_, requestnot0_.code_syn_status as code22_44_, requestnot0_.delivery_type as deliver23_44_, requestnot0_.dic_bank as dic24_44_, requestnot0_.download_date as downloa25_44_, requestnot0_.download_date4data as downloa26_44_, requestnot0_.download_date4health_check as downloa27_44_, requestnot0_.download_date4key as downloa28_44_, requestnot0_.download_date_4gx_check as downloa29_44_, requestnot0_.download_date_gx_no as downloa30_44_, requestnot0_.download_insdutry_data_date as downloa31_44_, requestnot0_.ftp_flag as ftp32_44_, requestnot0_.gx_no_file_name as gx33_44_, requestnot0_.gx_no_flag as gx34_44_, requestnot0_.health_flag as health35_44_, requestnot0_.insdusty_flag as insdust36_44_, requestnot0_.insdusty_syn_flag as insdust37_44_, requestnot0_.linkman as linkman38_44_, requestnot0_.mobile_phone as mobile39_44_, requestnot0_.org_code as org40_44_, requestnot0_.orgb as orgb41_44_, requestnot0_.purchase_code as purchas42_44_, requestnot0_.remark as remark43_44_, requestnot0_.reg_name as reg44_44_, requestnot0_.sequence_no as sequenc45_44_, requestnot0_.status as status46_44_, requestnot0_.sum_price as sum47_44_, requestnot0_.synbank_open_account2gx_flag as synbank48_44_, requestnot0_.telephone as telepho49_44_, requestnot0_.to_health_check_file_name as to50_44_, requestnot0_.to_health_data_file_name as to51_44_, requestnot0_.to_health_key_file_name as to52_44_, requestnot0_.togx_check_file_name as togx53_44_, requestnot0_.type as type54_44_, requestnot0_.userb as userb55_44_, requestnot0_.version as version56_44_ from pss_request_note requestnot0_ where 1=1 order by requestnot0_.create_date desc limit ?
12:12:58.344 [qtp1902693237-47] INFO  Sharding-JDBC-SQL[59] - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=pss_request_note, alias=Optional.of(requestnot0_))]), conditions=Conditions(conditions={}), sqlTokens=[TableToken(beginPosition=2386, originalLiterals=pss_request_note)], parametersIndex=0)), containStar=false, selectListLastPosition=2381, groupByLastPosition=0, items=[CommonSelectItem(expression=requestnot0_.submit_date, alias=Optional.of(submit12_44_)), CommonSelectItem(expression=requestnot0_.remark, alias=Optional.of(remark43_44_)), CommonSelectItem(expression=requestnot0_.dic_bank, alias=Optional.of(dic24_44_)), CommonSelectItem(expression=requestnot0_.download_date, alias=Optional.of(downloa25_44_)), CommonSelectItem(expression=requestnot0_.telephone, alias=Optional.of(telepho49_44_)), CommonSelectItem(expression=requestnot0_.bank_code, alias=Optional.of(bank16_44_)), CommonSelectItem(expression=requestnot0_.create_user, alias=Optional.of(create5_44_)), CommonSelectItem(expression=requestnot0_.bank_flag, alias=Optional.of(bank17_44_)), CommonSelectItem(expression=requestnot0_.code, alias=Optional.of(code21_44_)), CommonSelectItem(expression=requestnot0_.create_date, alias=Optional.of(create4_44_)), CommonSelectItem(expression=requestnot0_.areab, alias=Optional.of(areab14_44_)), CommonSelectItem(expression=requestnot0_.insdusty_flag, alias=Optional.of(insdust36_44_)), CommonSelectItem(expression=requestnot0_.mobile_phone, alias=Optional.of(mobile39_44_)), CommonSelectItem(expression=requestnot0_.userb, alias=Optional.of(userb55_44_)), CommonSelectItem(expression=requestnot0_.download_date4health_check, alias=Optional.of(downloa27_44_)), CommonSelectItem(expression=requestnot0_.to_health_data_file_name, alias=Optional.of(to51_44_)), CommonSelectItem(expression=requestnot0_.download_date4data, alias=Optional.of(downloa26_44_)), CommonSelectItem(expression=requestnot0_.type, alias=Optional.of(type54_44_)), CommonSelectItem(expression=requestnot0_.to_health_check_file_name, alias=Optional.of(to50_44_)), CommonSelectItem(expression=requestnot0_.reject_date, alias=Optional.of(reject9_44_)), CommonSelectItem(expression=requestnot0_.gx_no_file_name, alias=Optional.of(gx33_44_)), CommonSelectItem(expression=requestnot0_.card_type, alias=Optional.of(card20_44_)), CommonSelectItem(expression=requestnot0_.auto_flag, alias=Optional.of(auto15_44_)), CommonSelectItem(expression=requestnot0_.download_date4key, alias=Optional.of(downloa28_44_)), CommonSelectItem(expression=requestnot0_.obsolete_user, alias=Optional.of(obsolete8_44_)), CommonSelectItem(expression=requestnot0_.sequence_no, alias=Optional.of(sequenc45_44_)), CommonSelectItem(expression=requestnot0_.insdusty_syn_flag, alias=Optional.of(insdust37_44_)), CommonSelectItem(expression=requestnot0_.download_date_4gx_check, alias=Optional.of(downloa29_44_)), CommonSelectItem(expression=requestnot0_.id, alias=Optional.of(id1_44_)), CommonSelectItem(expression=requestnot0_.version, alias=Optional.of(version56_44_)), CommonSelectItem(expression=requestnot0_.obsolete_date, alias=Optional.of(obsolete6_44_)), CommonSelectItem(expression=requestnot0_.health_flag, alias=Optional.of(health35_44_)), CommonSelectItem(expression=requestnot0_.togx_check_file_name, alias=Optional.of(togx53_44_)), CommonSelectItem(expression=requestnot0_.org_code, alias=Optional.of(org40_44_)), CommonSelectItem(expression=requestnot0_.reg_name, alias=Optional.of(reg44_44_)), CommonSelectItem(expression=requestnot0_.audit_user, alias=Optional.of(audit3_44_)), CommonSelectItem(expression=requestnot0_.reject_user, alias=Optional.of(reject11_44_)), CommonSelectItem(expression=requestnot0_.orgb, alias=Optional.of(orgb41_44_)), CommonSelectItem(expression=requestnot0_.to_health_key_file_name, alias=Optional.of(to52_44_)), CommonSelectItem(expression=requestnot0_.bank_net_id, alias=Optional.of(bank19_44_)), CommonSelectItem(expression=requestnot0_.gx_no_flag, alias=Optional.of(gx34_44_)), CommonSelectItem(expression=requestnot0_.reject_explain, alias=Optional.of(reject10_44_)), CommonSelectItem(expression=requestnot0_.download_date_gx_no, alias=Optional.of(downloa30_44_)), CommonSelectItem(expression=requestnot0_.delivery_type, alias=Optional.of(deliver23_44_)), CommonSelectItem(expression=requestnot0_.audit_date, alias=Optional.of(audit2_44_)), CommonSelectItem(expression=requestnot0_.synbank_open_account2gx_flag, alias=Optional.of(synbank48_44_)), CommonSelectItem(expression=requestnot0_.linkman, alias=Optional.of(linkman38_44_)), CommonSelectItem(expression=requestnot0_.submit_user, alias=Optional.of(submit13_44_)), CommonSelectItem(expression=requestnot0_.code_syn_status, alias=Optional.of(code22_44_)), CommonSelectItem(expression=requestnot0_.ftp_flag, alias=Optional.of(ftp32_44_)), CommonSelectItem(expression=requestnot0_.bank_name, alias=Optional.of(bank18_44_)), CommonSelectItem(expression=requestnot0_.obsolete_explain, alias=Optional.of(obsolete7_44_)), CommonSelectItem(expression=requestnot0_.download_insdutry_data_date, alias=Optional.of(downloa31_44_)), CommonSelectItem(expression=requestnot0_.purchase_code, alias=Optional.of(purchas42_44_)), CommonSelectItem(expression=requestnot0_.status, alias=Optional.of(status46_44_)), CommonSelectItem(expression=requestnot0_.sum_price, alias=Optional.of(sum47_44_))], groupByItems=[], orderByItems=[OrderItem(owner=Optional.of(requestnot0_), name=Optional.of(create_date), type=DESC, nullOrderType=ASC, index=-1, alias=Optional.of(create4_44_))], limit=Limit(rowCountRewriteFlag=true, offset=null, rowCount=LimitValue(value=20, index=0)), subQueryStatement=null)
12:12:58.349 [qtp1902693237-47] INFO  Sharding-JDBC-SQL[59] - Actual SQL: db-node-0 ::: select requestnot0_.id as id1_44_, requestnot0_.audit_date as audit2_44_, requestnot0_.audit_user as audit3_44_, requestnot0_.create_date as create4_44_, requestnot0_.create_user as create5_44_, requestnot0_.obsolete_date as obsolete6_44_, requestnot0_.obsolete_explain as obsolete7_44_, requestnot0_.obsolete_user as obsolete8_44_, requestnot0_.reject_date as reject9_44_, requestnot0_.reject_explain as reject10_44_, requestnot0_.reject_user as reject11_44_, requestnot0_.submit_date as submit12_44_, requestnot0_.submit_user as submit13_44_, requestnot0_.areab as areab14_44_, requestnot0_.auto_flag as auto15_44_, requestnot0_.bank_code as bank16_44_, requestnot0_.bank_flag as bank17_44_, requestnot0_.bank_name as bank18_44_, requestnot0_.bank_net_id as bank19_44_, requestnot0_.card_type as card20_44_, requestnot0_.code as code21_44_, requestnot0_.code_syn_status as code22_44_, requestnot0_.delivery_type as deliver23_44_, requestnot0_.dic_bank as dic24_44_, requestnot0_.download_date as downloa25_44_, requestnot0_.download_date4data as downloa26_44_, requestnot0_.download_date4health_check as downloa27_44_, requestnot0_.download_date4key as downloa28_44_, requestnot0_.download_date_4gx_check as downloa29_44_, requestnot0_.download_date_gx_no as downloa30_44_, requestnot0_.download_insdutry_data_date as downloa31_44_, requestnot0_.ftp_flag as ftp32_44_, requestnot0_.gx_no_file_name as gx33_44_, requestnot0_.gx_no_flag as gx34_44_, requestnot0_.health_flag as health35_44_, requestnot0_.insdusty_flag as insdust36_44_, requestnot0_.insdusty_syn_flag as insdust37_44_, requestnot0_.linkman as linkman38_44_, requestnot0_.mobile_phone as mobile39_44_, requestnot0_.org_code as org40_44_, requestnot0_.orgb as orgb41_44_, requestnot0_.purchase_code as purchas42_44_, requestnot0_.remark as remark43_44_, requestnot0_.reg_name as reg44_44_, requestnot0_.sequence_no as sequenc45_44_, requestnot0_.status as status46_44_, requestnot0_.sum_price as sum47_44_, requestnot0_.synbank_open_account2gx_flag as synbank48_44_, requestnot0_.telephone as telepho49_44_, requestnot0_.to_health_check_file_name as to50_44_, requestnot0_.to_health_data_file_name as to51_44_, requestnot0_.to_health_key_file_name as to52_44_, requestnot0_.togx_check_file_name as togx53_44_, requestnot0_.type as type54_44_, requestnot0_.userb as userb55_44_, requestnot0_.version as version56_44_ from pss_request_note requestnot0_ where 1=1 order by requestnot0_.create_date desc limit ? ::: [20]
12:12:58.392 [qtp1902693237-47] WARN  o.h.e.j.internal.JdbcCoordinatorImpl[384] - HHH000387: ResultSet's statement was not registered

查询第二页打印日志如下:

12:14:33.995 [qtp1902693237-45] INFO  Sharding-JDBC-SQL[59] - Logic SQL: select count(*) as col_0_0_ from pss_request_note requestnot0_ where 1=1
12:14:33.997 [qtp1902693237-45] INFO  Sharding-JDBC-SQL[59] - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=pss_request_note, alias=Optional.of(requestnot0_))]), conditions=Conditions(conditions={}), sqlTokens=[TableToken(beginPosition=33, originalLiterals=pss_request_note)], parametersIndex=0)), containStar=false, selectListLastPosition=28, groupByLastPosition=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(*), alias=Optional.of(col_0_0_), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
12:14:33.998 [qtp1902693237-45] INFO  Sharding-JDBC-SQL[59] - Actual SQL: db-node-0 ::: select count(*) as col_0_0_ from pss_request_note requestnot0_ where 1=1
12:14:34.009 [qtp1902693237-45] WARN  o.h.e.j.internal.JdbcCoordinatorImpl[384] - HHH000387: ResultSet's statement was not registered
12:14:34.082 [qtp1902693237-45] INFO  Sharding-JDBC-SQL[59] - Logic SQL: select requestnot0_.id as id1_44_, requestnot0_.audit_date as audit2_44_, requestnot0_.audit_user as audit3_44_, requestnot0_.create_date as create4_44_, requestnot0_.create_user as create5_44_, requestnot0_.obsolete_date as obsolete6_44_, requestnot0_.obsolete_explain as obsolete7_44_, requestnot0_.obsolete_user as obsolete8_44_, requestnot0_.reject_date as reject9_44_, requestnot0_.reject_explain as reject10_44_, requestnot0_.reject_user as reject11_44_, requestnot0_.submit_date as submit12_44_, requestnot0_.submit_user as submit13_44_, requestnot0_.areab as areab14_44_, requestnot0_.auto_flag as auto15_44_, requestnot0_.bank_code as bank16_44_, requestnot0_.bank_flag as bank17_44_, requestnot0_.bank_name as bank18_44_, requestnot0_.bank_net_id as bank19_44_, requestnot0_.card_type as card20_44_, requestnot0_.code as code21_44_, requestnot0_.code_syn_status as code22_44_, requestnot0_.delivery_type as deliver23_44_, requestnot0_.dic_bank as dic24_44_, requestnot0_.download_date as downloa25_44_, requestnot0_.download_date4data as downloa26_44_, requestnot0_.download_date4health_check as downloa27_44_, requestnot0_.download_date4key as downloa28_44_, requestnot0_.download_date_4gx_check as downloa29_44_, requestnot0_.download_date_gx_no as downloa30_44_, requestnot0_.download_insdutry_data_date as downloa31_44_, requestnot0_.ftp_flag as ftp32_44_, requestnot0_.gx_no_file_name as gx33_44_, requestnot0_.gx_no_flag as gx34_44_, requestnot0_.health_flag as health35_44_, requestnot0_.insdusty_flag as insdust36_44_, requestnot0_.insdusty_syn_flag as insdust37_44_, requestnot0_.linkman as linkman38_44_, requestnot0_.mobile_phone as mobile39_44_, requestnot0_.org_code as org40_44_, requestnot0_.orgb as orgb41_44_, requestnot0_.purchase_code as purchas42_44_, requestnot0_.remark as remark43_44_, requestnot0_.reg_name as reg44_44_, requestnot0_.sequence_no as sequenc45_44_, requestnot0_.status as status46_44_, requestnot0_.sum_price as sum47_44_, requestnot0_.synbank_open_account2gx_flag as synbank48_44_, requestnot0_.telephone as telepho49_44_, requestnot0_.to_health_check_file_name as to50_44_, requestnot0_.to_health_data_file_name as to51_44_, requestnot0_.to_health_key_file_name as to52_44_, requestnot0_.togx_check_file_name as togx53_44_, requestnot0_.type as type54_44_, requestnot0_.userb as userb55_44_, requestnot0_.version as version56_44_ from pss_request_note requestnot0_ where 1=1 order by requestnot0_.create_date desc limit ?, ?
12:14:34.088 [qtp1902693237-45] INFO  Sharding-JDBC-SQL[59] - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=pss_request_note, alias=Optional.of(requestnot0_))]), conditions=Conditions(conditions={}), sqlTokens=[TableToken(beginPosition=2386, originalLiterals=pss_request_note)], parametersIndex=0)), containStar=false, selectListLastPosition=2381, groupByLastPosition=0, items=[CommonSelectItem(expression=requestnot0_.download_date4key, alias=Optional.of(downloa28_44_)), CommonSelectItem(expression=requestnot0_.card_type, alias=Optional.of(card20_44_)), CommonSelectItem(expression=requestnot0_.download_date4data, alias=Optional.of(downloa26_44_)), CommonSelectItem(expression=requestnot0_.download_insdutry_data_date, alias=Optional.of(downloa31_44_)), CommonSelectItem(expression=requestnot0_.gx_no_file_name, alias=Optional.of(gx33_44_)), CommonSelectItem(expression=requestnot0_.code, alias=Optional.of(code21_44_)), CommonSelectItem(expression=requestnot0_.download_date_4gx_check, alias=Optional.of(downloa29_44_)), CommonSelectItem(expression=requestnot0_.obsolete_user, alias=Optional.of(obsolete8_44_)), CommonSelectItem(expression=requestnot0_.health_flag, alias=Optional.of(health35_44_)), CommonSelectItem(expression=requestnot0_.remark, alias=Optional.of(remark43_44_)), CommonSelectItem(expression=requestnot0_.version, alias=Optional.of(version56_44_)), CommonSelectItem(expression=requestnot0_.to_health_check_file_name, alias=Optional.of(to50_44_)), CommonSelectItem(expression=requestnot0_.id, alias=Optional.of(id1_44_)), CommonSelectItem(expression=requestnot0_.gx_no_flag, alias=Optional.of(gx34_44_)), CommonSelectItem(expression=requestnot0_.bank_net_id, alias=Optional.of(bank19_44_)), CommonSelectItem(expression=requestnot0_.org_code, alias=Optional.of(org40_44_)), CommonSelectItem(expression=requestnot0_.download_date4health_check, alias=Optional.of(downloa27_44_)), CommonSelectItem(expression=requestnot0_.reg_name, alias=Optional.of(reg44_44_)), CommonSelectItem(expression=requestnot0_.reject_explain, alias=Optional.of(reject10_44_)), CommonSelectItem(expression=requestnot0_.insdusty_syn_flag, alias=Optional.of(insdust37_44_)), CommonSelectItem(expression=requestnot0_.status, alias=Optional.of(status46_44_)), CommonSelectItem(expression=requestnot0_.auto_flag, alias=Optional.of(auto15_44_)), CommonSelectItem(expression=requestnot0_.telephone, alias=Optional.of(telepho49_44_)), CommonSelectItem(expression=requestnot0_.audit_user, alias=Optional.of(audit3_44_)), CommonSelectItem(expression=requestnot0_.obsolete_explain, alias=Optional.of(obsolete7_44_)), CommonSelectItem(expression=requestnot0_.synbank_open_account2gx_flag, alias=Optional.of(synbank48_44_)), CommonSelectItem(expression=requestnot0_.submit_user, alias=Optional.of(submit13_44_)), CommonSelectItem(expression=requestnot0_.mobile_phone, alias=Optional.of(mobile39_44_)), CommonSelectItem(expression=requestnot0_.sum_price, alias=Optional.of(sum47_44_)), CommonSelectItem(expression=requestnot0_.bank_code, alias=Optional.of(bank16_44_)), CommonSelectItem(expression=requestnot0_.create_date, alias=Optional.of(create4_44_)), CommonSelectItem(expression=requestnot0_.userb, alias=Optional.of(userb55_44_)), CommonSelectItem(expression=requestnot0_.insdusty_flag, alias=Optional.of(insdust36_44_)), CommonSelectItem(expression=requestnot0_.to_health_key_file_name, alias=Optional.of(to52_44_)), CommonSelectItem(expression=requestnot0_.togx_check_file_name, alias=Optional.of(togx53_44_)), CommonSelectItem(expression=requestnot0_.submit_date, alias=Optional.of(submit12_44_)), CommonSelectItem(expression=requestnot0_.ftp_flag, alias=Optional.of(ftp32_44_)), CommonSelectItem(expression=requestnot0_.reject_user, alias=Optional.of(reject11_44_)), CommonSelectItem(expression=requestnot0_.linkman, alias=Optional.of(linkman38_44_)), CommonSelectItem(expression=requestnot0_.areab, alias=Optional.of(areab14_44_)), CommonSelectItem(expression=requestnot0_.audit_date, alias=Optional.of(audit2_44_)), CommonSelectItem(expression=requestnot0_.orgb, alias=Optional.of(orgb41_44_)), CommonSelectItem(expression=requestnot0_.to_health_data_file_name, alias=Optional.of(to51_44_)), CommonSelectItem(expression=requestnot0_.bank_flag, alias=Optional.of(bank17_44_)), CommonSelectItem(expression=requestnot0_.type, alias=Optional.of(type54_44_)), CommonSelectItem(expression=requestnot0_.download_date, alias=Optional.of(downloa25_44_)), CommonSelectItem(expression=requestnot0_.download_date_gx_no, alias=Optional.of(downloa30_44_)), CommonSelectItem(expression=requestnot0_.bank_name, alias=Optional.of(bank18_44_)), CommonSelectItem(expression=requestnot0_.purchase_code, alias=Optional.of(purchas42_44_)), CommonSelectItem(expression=requestnot0_.sequence_no, alias=Optional.of(sequenc45_44_)), CommonSelectItem(expression=requestnot0_.dic_bank, alias=Optional.of(dic24_44_)), CommonSelectItem(expression=requestnot0_.create_user, alias=Optional.of(create5_44_)), CommonSelectItem(expression=requestnot0_.reject_date, alias=Optional.of(reject9_44_)), CommonSelectItem(expression=requestnot0_.obsolete_date, alias=Optional.of(obsolete6_44_)), CommonSelectItem(expression=requestnot0_.code_syn_status, alias=Optional.of(code22_44_)), CommonSelectItem(expression=requestnot0_.delivery_type, alias=Optional.of(deliver23_44_))], groupByItems=[], orderByItems=[OrderItem(owner=Optional.of(requestnot0_), name=Optional.of(create_date), type=DESC, nullOrderType=ASC, index=-1, alias=Optional.of(create4_44_))], limit=Limit(rowCountRewriteFlag=true, offset=LimitValue(value=20, index=0), rowCount=LimitValue(value=20, index=1)), subQueryStatement=null)
12:14:34.093 [qtp1902693237-45] INFO  Sharding-JDBC-SQL[59] - Actual SQL: db-node-0 ::: select requestnot0_.id as id1_44_, requestnot0_.audit_date as audit2_44_, requestnot0_.audit_user as audit3_44_, requestnot0_.create_date as create4_44_, requestnot0_.create_user as create5_44_, requestnot0_.obsolete_date as obsolete6_44_, requestnot0_.obsolete_explain as obsolete7_44_, requestnot0_.obsolete_user as obsolete8_44_, requestnot0_.reject_date as reject9_44_, requestnot0_.reject_explain as reject10_44_, requestnot0_.reject_user as reject11_44_, requestnot0_.submit_date as submit12_44_, requestnot0_.submit_user as submit13_44_, requestnot0_.areab as areab14_44_, requestnot0_.auto_flag as auto15_44_, requestnot0_.bank_code as bank16_44_, requestnot0_.bank_flag as bank17_44_, requestnot0_.bank_name as bank18_44_, requestnot0_.bank_net_id as bank19_44_, requestnot0_.card_type as card20_44_, requestnot0_.code as code21_44_, requestnot0_.code_syn_status as code22_44_, requestnot0_.delivery_type as deliver23_44_, requestnot0_.dic_bank as dic24_44_, requestnot0_.download_date as downloa25_44_, requestnot0_.download_date4data as downloa26_44_, requestnot0_.download_date4health_check as downloa27_44_, requestnot0_.download_date4key as downloa28_44_, requestnot0_.download_date_4gx_check as downloa29_44_, requestnot0_.download_date_gx_no as downloa30_44_, requestnot0_.download_insdutry_data_date as downloa31_44_, requestnot0_.ftp_flag as ftp32_44_, requestnot0_.gx_no_file_name as gx33_44_, requestnot0_.gx_no_flag as gx34_44_, requestnot0_.health_flag as health35_44_, requestnot0_.insdusty_flag as insdust36_44_, requestnot0_.insdusty_syn_flag as insdust37_44_, requestnot0_.linkman as linkman38_44_, requestnot0_.mobile_phone as mobile39_44_, requestnot0_.org_code as org40_44_, requestnot0_.orgb as orgb41_44_, requestnot0_.purchase_code as purchas42_44_, requestnot0_.remark as remark43_44_, requestnot0_.reg_name as reg44_44_, requestnot0_.sequence_no as sequenc45_44_, requestnot0_.status as status46_44_, requestnot0_.sum_price as sum47_44_, requestnot0_.synbank_open_account2gx_flag as synbank48_44_, requestnot0_.telephone as telepho49_44_, requestnot0_.to_health_check_file_name as to50_44_, requestnot0_.to_health_data_file_name as to51_44_, requestnot0_.to_health_key_file_name as to52_44_, requestnot0_.togx_check_file_name as togx53_44_, requestnot0_.type as type54_44_, requestnot0_.userb as userb55_44_, requestnot0_.version as version56_44_ from pss_request_note requestnot0_ where 1=1 order by requestnot0_.create_date desc limit ?, ? ::: [20, 20]
12:14:34.137 [qtp1902693237-45] WARN  o.h.e.j.internal.JdbcCoordinatorImpl[384] - HHH000387: ResultSet's statement was not registered

 

举报
AN安分分
发帖于2个月前 2回/142阅
顶部