整合shardingsphere-jdbc 4.1.1版本后 在数据权限web全自动配置报错

Blade 未结 2 1287
82822406
82822406 2021-05-19 16:23
悬赏:5

一、该问题的重现步骤是什么?

  1. 再pom里面添加sharding jar包

    image.png

2. 在配置文件application-dev.yml 里面添加sharding的配置

image.png

image.png

3. 数据权限页面添加

image.png

4、访问代码生成后的分页接口,sql如下

SELECT

 * 

FROM

 (

 SELECT

  id,

  source_goods_no,

  source_goods_status,

  shipper_id,

  shipper_user_id,

  is_sign_shipper,

  goods_insert_datetime,

  shipper_name,

  contact_name,

  personal_identity_type_code,

  personal_identity_document,

  telephone_number,

  mobile_telephone_number,

  deliver_province_code,

  deliver_province_name,

  deliver_city_code,

  deliver_city_name,

  deliver_area_code,

  deliver_area_name,

  deliver_detail_address,

  place_of_loading,

  load_transport_station_code,

  load_transport_station_name,

  resquested_load_start_datetime,

  resquested_load_end_datetime,

  consignee_id,

  consignee,

  consignee_pert_number,

  consi_contact_name,

  consi_telephone_number,

  consi_mobile_telephone_number,

  arrival_province_code,

  arrival_province_name,

  arrival_city_code,

  arrival_city_name,

  arrival_area_code,

  arrival_area_name,

  arrival_detail_address,

  goods_receipt_place,

  receipt_transport_station_code,

  receipt_transport_station_name,

  requested_unloaded_datetime,

  taketicket_flag,

  price_type,

  total_monetary_amount,

  vehicle_type_requirement,

  vehicle_length_requirement,

  goods_price,

  contract_number,

  payment_type,

  service_amount,

  insurance_company,

  insurance_company_code,

  insurance_bill_code,

  insurance_access_address,

  insurance_amount,

  deliver_settlement_name,

  deliver_settlement_telephone_number,

  synchronization_time,

  is_exception,

  business_type_code,

  business_type_name,

  statistics_type,

  remark,

  estimated_arrival_datetime,

  transport_type_code,

  version,

  tenant_id,

  create_user,

  create_dept,

  create_time,

  update_user,

  update_time,

  STATUS,

  is_deleted 

 FROM

  t_invoice 

 WHERE

  is_deleted = 0 

  AND tenant_id = '000000' 

 ORDER BY

  create_time DESC 

 ) scope 

WHERE

 scope.create_dept IN ( 1123598813738675201, 1123598813738675202, 1123598813738675203, 1381449354410323969 ) 

 LIMIT 10

二、你期待的结果是什么?实际看到的又是什么?

应该正常显示,但是界面出现了报错截图

image.png

三、你正在使用的是什么产品,什么版本?在什么操作系统上?

bladex, windows

四、请提供详细的错误堆栈信息,这很重要。


五、若有更多详细信息,请在下面提供。

2条回答
提交回复