2025-05-14 14:23:55-[INFO ConfigurationLogger.java:104] ShardingRuleConfiguration:
tables:
addr_segm:
actualDataNodes: dataSource.ADDR_SEGM_$->{3301..3311}
logicTable: addr_segm
tableStrategy:
complex:
algorithmClassName: com.zres.product.resmaster.space.zjyd.conf.CityCodeShardingAlgorithm
shardingColumns: SEGM_ID,OLD_ID_EQP,REGION_ID
addr_segm_access:
actualDataNodes: dataSource.ADDR_SEGM_ACCESS_$->{3301..3311}
logicTable: addr_segm_access
tableStrategy:
complex:
algorithmClassName: com.zres.product.resmaster.space.zjyd.conf.CityCodeShardingAlgorithm
shardingColumns: SEGM_ID,REGION_ID
2025-05-14 14:23:55-[INFO ConfigurationLogger.java:104] Properties:
column-uppercase: 'true'
sql.show: 'true'
2025-05-14 14:23:55-[INFO ShardingMetaDataLoader.java:131] Loading 2 logic tables' meta data.
2025-05-14 14:23:57-[INFO DefaultSingletonBeanRegistry.java:422] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@4d0ef07a: defining beans [frameWorkResEventHandlerDelegate,databaseObjectQueryFrameImpl,menuFrameService,namingServiceImpl,navigationConfService,propertyDataBizService,propertyDynamicMapperService,propertyPageData,propertyServiceImpl,dynamicQueryServiceImpl,frameQueryServiceImpl,pubRelationFrameService,treeService,afficheSerivceImpl,processStatThreadHolder,databaseQueryImpl,pubFunctionMenuService,fileUploadSerivceImpl,routeService,groupRoleSerivce,pubDataDimensionTypeService,pubEntityRoleService,pubRoleDimensionService,rolegrpService,roleQuyuService,roleSpecialityService,rolesService,staffRoleService,usergrpRolegrpService,vwPubDataDimensionService,departmentService,spcRegionService,staffStateService,staffWorkgrpService,titleService,workGroupService,safeStrategyService,frameWorkApplicationContext,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,zjydGisDataOperation,resQryOperation,resBaseQryOperation,addressOperation,districtQryOperation,keyAddrQryOperation,csvUtilOperation,addrBaseQryOperation,accessTypeQryOperation,nearaddrQryOperation,accessQryDataOperation,baseServiceOperation,syncIntfDataOperation,syncFullAddrOperation,syncManageOperation,zjydSolrDataOperation,syncIncreAddrOperation,syncITFOperation,esbDataOperation,syncAccessOperation,syncIntfService,syncDataFactoryService,interfaceLogService,zjydSolrService,esbService,accessQryService,addrSyncOperation,portNumSyncOperation,addrDataInStockOperation,portNumDataInStockOperation,addrInstockService,syncFilesNotifyService,portNumInstockService,tokenCacheManager,gwTokenFetcherImpl,const,spacePropertyService,spaceConfigService,spaceRestApiService,addrBatchAddService,roomPlaneService,addrRelDeviceService,addrManageService,accessQueryService,mergeAddressService,deleteResService,solrService,deviceSelectService,threeViewService,addrTreeService,deviceSelectDataOperation,solrDataOperation,addressAdjustDataOperation,deleteResDataOperation,addrRelDeviceDataOperation,threeViewDataOperation,spaceConfigDataOperation,accessQueryDataOperation,roomPlaneDataOperation,addrTreeDataOperation,addrManageDataOperation,spacePropertyDataOperation,addrBatchAddDataOperation,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,messageSource,jdbcTemplate,sqlSessionFactory,com.ztesoft.res.frame.orm.mybatis.mapper.ResMapperScannerConfigurer#0,sqlSessionTemplate,transactionManager,transactionInterceptor,org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator#0,com.ztesoft.res.frame.initialize.HttpRemoteSysConfigInitListener#0,loginController,com.ztesoft.res.frame.buz.ResProductComponentScan#0,cacheComponent,mongoDB,com.ztesoft.res.frame.tools.log.NoSqlLoggerInstance#0,loginTypeEnableAssertConfig,com.ztesoft.res.frame.filter.DefaultHasNameWebFilterChain#0,multiDataSourceWebFilter,com.ztesoft.res.frame.user.login.listener.DataSourceRouteSwitchOnLoginEventListener#0,roleDistributionServiceDynamic,staffServiceDynamic,com.ztesoft.res.frame.user.authority.listener.UserAuthorityListener#0,com.zres.product.resmaster.space.zjyd.conf.GisZjydConfData#0,com.zres.product.resmaster.space.zjyd.service.ZjydGisService#0,com.zres.product.resmaster.space.zjyd.conf.CSVConfData#0,com.zres.product.resmaster.space.zjyd.service.SyncAddrService#0,sResBaseQry,sAccessType,sAddrBaseQry,sDistrictQry,sKeyAddrQry,sNearaddrQry,sResQryCSV,sSolrQueryCSV,sSolrGetGuideResult,sQueryAccessInfo,sQrySegmAccess,projectConfBean,searchBean,com.ztesoft.res.frame.web.executor.protocol.ProtocolDispatchHandler#0,com.zres.product.resmaster.space.zjyd.conf.CSFFunctionCallApply#0,resJdbcTemplate,smartLocationServiceImpl,gaodeAPIServiceImpl,baiduAPIServiceImpl,addressServiceImpl,addressWebServiceDao,smartLocationRelDao,ossAddrSegmAccessDao,smartLocationSdeDao,ossDistrictDao,addressWebService,configDao,logDao,mapDao,configServiceImpl,logServiceImpl,ossAddrDao,ossAuthorityDao,ossCableDao,ossComDao,ossDelToProDao,ossEqpDao,ossGridDao,ossLineLengthDao,ossPipeDao,ossResQueryDao,ossAddrServiceImpl,ossAuthorityServiceImpl,ossComServiceImpl,ossDelToProServiceImp,ossGridServiceImpl,ossLineLengthServiceImpl,ossResQueryServiceImpl,ossResStatisticsServiceImpl,ossCableService,ossEqpService,ossPipeService,gisLineLengthDao,graphDao,graphUpdateDao,geoCoordConv,gisLineLength,graphDegree,mapStatisticDao,optCblDao,resConfigDao,resEditDao,resLineLengthDao,resQueryDao,synchronizationResDao,delPipeSectServiceImpl,mapStatisticServiceImpl,optCblServiceImpl,resEditServiceImpl,resLineLengthServiceImpl,resQueryServiceImpl,uploadFileService,queryClauseUtil,mapConfigDao,mapConfigServiceImpl,editTaskImpl,findTaskImpl,identifyTaskImpl,queryTaskImpl,geometryUtilityImpl,mapAPIConfigure,locationDao,mapAPIService,iMapAPIService,com.ztesoft.gis.module.location.service.impl.ZJESBCallApply#0,stGeometry,nativeJdbcExtrator,lobHandler,smartLocationService,iSmartLocationCSV,gisDataSource,resDataSource,dataSource,CSFConfig,cityCodeShardingAlgorithm,addr_segm_strategy,addr_segm_access_strategy,shardingDataSource,databaseObjectQueryFrameDao,menuFrameDao,namingFrameDao,navigationConfDao,propertyFrameDao,dynamicQueryDao,dynamicQueryDataDao,queryFrameDao,pubRelationFrameDao,treeDao,afficheDao,databaseQueryDao,pubFunctionMenuDao,fileUploadDao,routeDao,groupRoleDao,pubDataDimensionTypeDao,pubEntityRoleDao,pubRoleDimensionDao,rolegrpDao,roleQuyuDao,rolesDao,roleSpecialityDao,staffRoleDao,usergrpRolegrpDao,vwPubDataDimensionDao,loginUserDao,departmentDao,spcRegionDao,staffDao,staffStateDao,staffWorkgrpDao,titleDao,uosStaffDao,vwPubStaffDao,workGroupDao,safeStrategyDao,districtQryDao,resBaseQryDao,resQryDao,accessTypeQryDao,addrBaseQryDao,keyAddrQryDao,nearaddrQryDao,addrXAndYQryDao,accessQryDao,syncITFDao,syncAddrDao,interfaceLogDao,baseServiceDao,esbAddrDao,zjydSolrDao,addrInStockDao,portNumInSockDao,syncFilesNotifyDao,threeViewDao,addressAdjustDao,addrTreeDao,deleteResDao,addrRelDeviceDao,deviceSelectDao,addrManageDao,addrBatchAddDao,accessQueryDao,spaceConfigDao,addressDao]; root of factory hierarchy
2025-05-14 14:23:57-[ERROR ContextLoader.java:220] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingDataSource': Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.apache.shardingsphere.shardingjdbc.spring.datasource.SpringShardingDataSource]: Constructor threw exception; nested exception is java.sql.SQLException: Invalid column name
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
最新发布