Bean property 'lobHandler' is not writable or has an invalid setter method.

本文解决了一个Spring框架中关于LocalSessionFactoryBean的lobHandler属性设置错误的问题,详细描述了错误信息及解决方案,通过更改lobHandler的实现类从OracleLobHandler到DefaultLobHandler,成功解决了ContextInitializationFailed异常。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

错误描述
严重: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'lobHandler' of bean class [org.springframework.orm.hibernate4.LocalSessionFactoryBean]: Bean property 'lobHandler' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1427)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1132)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:522)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:589)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1571)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1561)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.beans.NotWritablePropertyException: Invalid property 'lobHandler' of bean class [org.springframework.orm.hibernate4.LocalSessionFactoryBean]: Bean property 'lobHandler' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1044)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:904)
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:57)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1424)
... 22 more
解决方法:将spring配置文件applicationContext.xml中的<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
修改为
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true">

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: &#39;true&#39; sql.show: &#39;true&#39; 2025-05-14 14:23:55-[INFO ShardingMetaDataLoader.java:131] Loading 2 logic tables&#39; 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 &#39;shardingDataSource&#39;: 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)
最新发布
05-15
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值