Not able to connect using Hibernate 4.2.16

[hardik sheth]

Hi,

I am trying to integrate HikariCP-java6-2.2.5, with hibernate 4.2.16 and spring 3.2.11 in our project. My session factory configuration looks as follows:

<bean id="sessionFactory"

class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

<property name="dataSource" ref="dataSourceHikariMaster"/> 

<!-- Added by Hardik J Sheth to use annotation in Hibernate class -->

<property name="packagesToScan" >

<array>

<value>com.tcs.digigov.*</value>

</array>

</property>

<!-- Added by Hardik J Sheth to use annotation in Hibernate class -->

<property name="hibernateProperties">

<props>

<prop key="hibernate.connection.release_mode">auto</prop>

<!-- c3p0 conneciton pool properties -->

<!-- end of c3p0 props -->

<prop key="hibernate.show_sql">false</prop>

<prop key="hibernate.format_sql">false</prop>

<prop key="hibernate.dialect">${dialect}</prop>

<prop key="hibernate.use_outer_join">true</prop>

<prop key="hibernate.use_sql_comments">false</prop>

<prop key="hibernate.jdbc.batch_size">${batchSize}</prop>

<prop key="hibernate.connection.release_mode">auto</prop>

<prop key="hibernate.hikari.dataSourceClassName">com.zaxxer.hikari.HikariDataSource</prop>

<prop key="hibernate.hikari.dataSource.username">${username}</prop>

<prop key="hibernate.hikari.dataSource.jdbcUrl">jdbc:db2://10.139.4.210:50000/AMCDEV:currentSchema=AMCDEV;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;</prop>

<prop key="hibernate.hikari.dataSource.password">${password}</prop>

<prop key="hibernate.hikari.dataSource.driverClassName">${driverClass}</prop>

<prop key="dataSource.connectionTestQuery">select 1 from dual</prop>

<prop key="hibernate.hikari.dataSource.connectionInitSql">select 1 from dual</prop>  

<prop key="hibernate.hikari.dataSource.autoCommit">false</prop>

<!--properties for Query cahce and second leve cache-->

<prop key="hibernate.cache.use_query_cache"></prop>

<!-- Added by Nirav Bumia for enabling second level caching -->

<prop key="hibernate.cache.use_second_level_cache">true</prop>

<!-- Added By Hardik Joshi -->

<!-- <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop> -->

<!-- <prop key="hibernate.cache.provider_class">org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</prop> -->

<prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</prop>

<!-- <prop key="net.sf.ehcache.configurationResourceName">ehcacheMaster.xml</prop> -->

<!--  <prop key="org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator">com.zaxxer.hikari.hibernate.HikariConnectionProvider</prop> 

--> <prop key="hibernate.connection.provider_class">com.zaxxer.hikari.hibernate.HikariConnectionProvider</prop>

<prop key="hibernate.generate_statistics">true</prop>

</props>

</property>

<property name="mappingJarLocations">

<list>

<!--  Changed by Ruchita : Usage Statistics Starts -->

 <value>WEB-INF/lib/digi*.jar</value>

<!--  Changed by Ruchita : Usage Statistics ends -->

 <value>WEB-INF/lib/hrmis-*.jar</value>

 <value>WEB-INF/lib/sample-*.jar</value>

 <value>WEB-INF/lib/ifms-*.jar</value>

 <!--  Added by Ruchi : Scheduler Starts -->

 <value>WEB-INF/lib/dg-scheduler-*.jar</value>

<value>WEB-INF/lib/dg-*.jar</value>

 <!--  Added by Ruchi : Scheduler Ends -->

 </list>

        </property>

</bean>

I get following error after I start my server.

2014-11-28 17:47:38.312 INFO  ConnectionProviderInitiator:188 - HHH000130: Instantiating explicit connection provider: com.zaxxer.hikari.hibernate.HikariConnectionProvider

2014-11-28 17:47:38.312 INFO  ConnectionProviderInitiator:188 - HHH000130: Instantiating explicit connection provider: com.zaxxer.hikari.hibernate.HikariConnectionProvider

2014-11-28 17:47:38.317 INFO  PropertyBeanSetter:57 - PropName:dataSource.password and Value=amcdev

2014-11-28 17:47:38.318 INFO  PropertyBeanSetter:57 - PropName:dataSourceClassName and Value=com.zaxxer.hikari.HikariDataSource

2014-11-28 17:47:38.318 INFO  PropertyBeanSetter:57 - PropName:dataSource.connectionInitSql and Value=select 1 from dual

2014-11-28 17:47:38.319 INFO  PropertyBeanSetter:57 - PropName:dataSource.driverClassName and Value=net.sf.log4jdbc.DriverSpy

2014-11-28 17:47:38.319 INFO  PropertyBeanSetter:57 - PropName:dataSource.autoCommit and Value=false

2014-11-28 17:47:38.319 INFO  PropertyBeanSetter:57 - PropName:dataSource.username and Value=amcdev

2014-11-28 17:47:38.319 INFO  PropertyBeanSetter:57 - PropName:dataSource.jdbcUrl and Value=jdbc:db2://10.139.4.210:50000/AMCDEV:currentSchema=AMCDEV;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;

2014-11-28 17:47:38.323 INFO  HikariDataSource:77 - HikariCP pool HikariPool-0 is starting.

2014-11-28 17:47:38.333 INFO  PropertyBeanSetter:57 - PropName:autoCommit and Value=false

2014-11-28 17:47:38.334 INFO  PropertyBeanSetter:57 - PropName:password and Value=amcdev

2014-11-28 17:47:38.334 INFO  PropertyBeanSetter:57 - PropName:driverClassName and Value=net.sf.log4jdbc.DriverSpy

2014-11-28 17:47:38.335 INFO  PropertyBeanSetter:57 - PropName:jdbcUrl and Value=jdbc:db2://10.139.4.210:50000/AMCDEV:currentSchema=AMCDEV;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;

2014-11-28 17:47:38.335 INFO  PropertyBeanSetter:57 - PropName:connectionInitSql and Value=select 1 from dual

2014-11-28 17:47:38.335 INFO  PropertyBeanSetter:57 - PropName:username and Value=amcdev

2014-11-28 17:47:38.342 INFO  HikariDataSource:101 - HikariCP pool HikariPool-1 is starting.

2014-11-28 17:47:38.345 INFO  DriverDataSource:50 - user amcdev

2014-11-28 17:47:38.345 INFO  DriverDataSource:51 - password:amcdev

2014-11-28 17:47:38.345 INFO  DriverDataSource:52 - Hardik jdbc:db2://10.139.4.210:50000/AMCDEV:currentSchema=AMCDEV;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;

2014-11-28 17:47:55.635 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.717 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.739 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.748 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.771 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.778 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.800 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.807 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.834 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.841 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.857 INFO  Dialect:122 - HHH000400: Using dialect: org.hibernate.dialect.DB2Dialect

2014-11-28 17:47:55.857 INFO  Dialect:122 - HHH000400: Using dialect: org.hibernate.dialect.DB2Dialect

2014-11-28 17:47:55.863 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.869 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.891 INFO  LobCreatorBuilder:94 - HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4

2014-11-28 17:47:55.891 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.891 INFO  LobCreatorBuilder:94 - HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4

2014-11-28 17:47:55.897 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.922 INFO  TransactionFactoryInitiator:68 - HHH000399: Using default transaction strategy (direct JDBC transactions)

2014-11-28 17:47:55.922 INFO  TransactionFactoryInitiator:68 - HHH000399: Using default transaction strategy (direct JDBC transactions)

2014-11-28 17:47:55.924 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.930 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.939 INFO  ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory

2014-11-28 17:47:55.939 INFO  ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory

2014-11-28 17:47:55.939 INFO  ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory

2014-11-28 17:47:55.959 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.966 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:55.995 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:56.002 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

2014-11-28 17:47:56.851 WARN  EhcacheAccessStrategyFactoryImpl:57 - HHH020007: read-only cache configured for mutable entity [ecache_lookup]

2014-11-28 17:47:56.851 WARN  EhcacheAccessStrategyFactoryImpl:57 - HHH020007: read-only cache configured for mutable entity [ecache_lookup]

2014-11-28 17:47:56.851 WARN  EhcacheAccessStrategyFactoryImpl:57 - HHH020007: read-only cache configured for mutable entity [ecache_lookup]

2014-11-28 17:47:59.044 WARN  EhcacheAccessStrategyFactoryImpl:90 - HHH020007: read-only cache configured for mutable entity [ecache_lookup]

2014-11-28 17:47:59.044 WARN  EhcacheAccessStrategyFactoryImpl:90 - HHH020007: read-only cache configured for mutable entity [ecache_lookup]

2014-11-28 17:47:59.044 WARN  EhcacheAccessStrategyFactoryImpl:90 - HHH020007: read-only cache configured for mutable entity [ecache_lookup]

2014-11-28 17:47:59.527 INFO  DefaultListableBeanFactory:433 - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@b15d34: defining beans [springSecurityFilterChain,customAnonymousFilter,blackListedIPFilter,applicationContextIntegrationFilter,ROBORequestFilter,secService,charEncodingFilter,metaCharFilter,requestRegistry,httpSessionContextIntegrationFilter,securityContextHolderAwareRequestFilter,authEventManager,anonymousProcessingFilter,authenticationManager,anonymousAuthenticationProvider,authenticationProcessingFilter,sucessAuthencationHandler,errorAuthencationHandler,sessionAuthenticationStrategy,reAuthenticationProcessingFilter,exceptionTranslationFilter,roleVoter,daoAuthenticationProvider,md5PasswordEncoder,sHAPasswordEncoder,jasyptStringDigester,authDao,userDetailsService,userCache,userCacheBackend,myCacheManager,filterInvocationInterceptor,daoBasedFilterInvocationDefinitionSource,sessionManagementFilter,securityContextRepository,logoutFilter,logoutHadler,customLogoutHandler,concurrentSessionFilter,concurrentSessionController,sessionRegistry,channelProcessingFilter,insecureChannelProcessor,retryWithHttpEntryPoint,secureChannelProcessor,retryWithHttpsEntryPoint,portMapper,inMemoryFilterInvocation,multipartResolver,loggerListener,CacheManager,localeResolver,messageSource,configurationEncryptor,propertyConfigurer,sessionFactory,sessionFactorySlave,dataSourceHikariMaster,dataSourceC3POMaster,dataSourceC3POSlave,reportDbCon,localeChangeInterceptor,abstractDao,baseController,baseControllerServiceExecuter,servLocator,urlMapping,themeChangeInterceptor,themeResolver,org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping#0,com.tcs.digigov.spring.view.DGResourceBundleViewResolver#0,modelViewResolver,HandleApplicationEvent,eventListenerBean,eventListenerBeanForQuartz,handlerManager,beanUtility,springServiceLocator,digigovServiceLocator,txManager,txAdvice,org.springframework.aop.config.internalAutoProxyCreator,handleRequestOperation,servExeOffline,serviceExecution,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#1,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#2,genericDAO,frameworkMetaDataDAO,frameworkMetaDataService,cmnLanguageMstDaoImpl,cmnLookupMstDAOImpl,loginDAOImpl,frmActionServiceRltDAOImpl,loginServiceImpl,changePasswordServiceImpl,firstTimeLoginServiceImpl,updatePasswordServiceImpl,digigovHomePageServiceImpl,cmnAttachmentMstDAOImpl,cmnAttachmentMpgDAOImpl,cmnAttdocMstDAOImpl,cmnAttbiometricMstDAOImpl,fileUploadServiceImpl,wfDAOImpl,serviceAdminDaoImpl,serviceAdminServiceImpl,unlockUsrACDAOImpl,unlockUsrACServiceImpl,eventAuditTrailDAOImpl,eventAuditTrailServiceImpl,adminDAOImpl,adminServiceImpl,qualificationDaoImpl,registrationDaoImpl,registrationServiceImpl,fmsCorrNotingsDAOImpl,fmsCorrMstDAOImpl,wfjobMvmtMstDaoImpl,wfDocMstDaoImpl,fmsCorrNumDtlsDaoImpl,wfJobMstDaoImpl,wfActualHierarchyMpgDaoImpl,userPostDaoImpl,fmsDocActionMpgDaoImpl,wfHierarchyPostMpgDaoImpl,frmServiceMstDAOImpl,fmsCorrAppTrackDAOImpl,fmsFileMstDAOImpl,fmsFileNotingDAOImpl,wfLeastJobDaoImpl,wfRoundRobinDaoImpl,fmsJobDueDateDtlDaoImpl,fmsUserPrfdlstDtlsDaoImpl,fmsUserPrfdlstMstDaoImpl,cmnBranchlocMpgDaoImpl,fmsOutwardMstDaoImpl,cmnLocationMstDaoImpl,fmsFileTabDaoImpl,fmsCorrTabDtlDaoImpl,fmsOutwardAttachMpgDaoImpl,wfDocDetailsMstDaoImpl,orgUserMstDaoImpl,fmsCommuniqueStdTmpDaoImpl,empDAOImpl,cmnDatabaseMstDaoImpl,orgPostMstDaoImpl,fmsCommuniqueMstDaoImpl,fmsCommuniqueDtlDaoImpl,cmnProjectMstDaoImpl,orgEmpDsgnMpgDaoImpl,orgDesignationMstDaoImpl,CmnAttachmentMpgDAOImpl,fmsCorrNotingServiceImpl,workFlowServiceImpl,fmsCorrForwardJobImpl,fmsCorrReturnImpl,orgPostOfficeMpgDaoImpl,orgEmpMstDao,orgEmpPostMpgDaoImpls,wfHierarchyDetailsServiceImpl,fmsCorrApproveImpl,fmsFileForwardJobImpl,fmsFileReturnImpl,fmsFileApproveImpl,fMSInterfaceImpl,fmsUserPrfdLstService,fmsFileAppTrackDAOImpl,wfAuditTrialMstDaoImpl,fmsFileNotingServiceImpl,fmsOutwardVOGeneratorImpl,fmsOutwardServiceImpl,fmsCommuniqueDetailsServiceImpl,fmsCommuniqueStdTmpServiceImpl,aclRoleDetailsDaoImpl,wfLogicalHierachyMstDaoImpl,aclModuleMstDaoImpl,WfDocMstDaoImpl,wflinkedCorrServiceImpl,fmsCorrCheckListDaoImpl,fmsCorrCheckListMpgDaoImpl,fmsCorrCheckListServiceImpl,initiateCorrespondenceServiceImpl,fmsRequestMstDAOImpl,orgOfficeDtlsDaoImpl,orgDesignationDtlsDaoImpl,fmsPendencyServiceImpl,fmsElementMstDaoImpl,fmsGetLinksForSpecificRoleServiceImpl,fmsFileStatusServiceImpl,fmsCorrespondenceServiceImpl,fmsFetchlJobServiceImpl,fmsBulkWorkflowActionServiceImpl,fmsRecordRoomToWorklistServiceImpl,getBarChartDataDaoImpl,cmnLocSupervisorMpgDaoImpl,showBarChartService,wfHierarchyMstDaoImpl,hierarchyTreeViewDAOImpl,orgBrnchSupvsrPostMpgDaoImpl,hierarchyTreeViewService,wfUtilityMethods,fmsBulkApproveMsgServiceImpl,fmsBulkApproveServiceImpl,fmsRefdocsFolderMstDaoImpl,fmsTemplateCategoryDtlsDaoImpl,fmsTemplateCategoryMstDaoImpl,fmsCtgryAttribDsplDtlDaoImpl,fmsTemplateAttributeDtlsDaoImpl,fmsRefdocFavMstDaoImpl,fmsTemplateAttributeMstDaoImpl,fmsRefDocsTemplateDtlsDaoImpl,fmsCategoryTemplateMpgDaoImpl,fmsTemplateMetadataTxnDtlsDaoImpl,fmsRefdocsDocFolderMpgDaoImpl,fmsRefdocRepositoryDaoImpl,fmsRefdocsDocHistoryMpgDaoImpl,fmsRefDocsTemplateMstDaoImpl,fmsRefdocsRatingMstDaoImpl,fmsRefDocsServiceImpl,inwardRegServiceImpl,outwardRegServiceImpl,fileServiceImpl,corrServiceImpl,fmsFileSearchDaoImpl,fmsFileSearchServiceImpl,wfBranchMstDaoImpl,wfSubjectDtlsServiceImpl,fmsBranchFilenoFmtDaoImpl,fmsBranchFileNumberFormatServiceImpl,fmsFileCheckListDaoImpl,fmsFileCheckListMpgDaoImpl,fMSUserBranchDaoImpl,fmsDocCategoryMpgDaoImpl,fmsDrftRefdocTmplMpgDAOImpl,wflinkedFileServiceImpl,fmsFilePrecedenceCasesImpl,orgPostDtlsDaoImpl,orgSubMpgDaoImpl,fmsFileCreateImpl,fmsFileCheckListServiceImpl,fmsBulkWorkflowActionMsgServiceImpl,fmsbulkWorkflowActionServiceImpl,bulkWorkflowAction,aclElementSubjectRltDaoImpl,aclElementSubOperationRltDaoImpl,aclEleSubOpnPostRltDaoImpl,aclEleSubOpnRoleRltDaoImpl,aclEleSubOpnMarkHieRltDaoImpl,aclOperationMstDaoImpl,aclElementOperationRltDaoImpl,eleSubOperationMappingServiceImpl,fmsFileCommonPoolServiceImpl,newArrivalServiceImpl,cmnContactMstDaoImpl,cmnDocCklstDtlDAOImpl,cmnDocCklstMstDAOImpl,cmnPrsnBankMpgDaoImpl,contactDaoImpl,contactServiceImpl,personDaoImpl,personServiceImpl,fmsQueryNotingServiceImpl,orgUserTypeConfigRltDaoImpl,orgGradeMstDaoImpl,aclPostRoleRltDaoImpl,customUserCreationServiceImpl,employeeDAOImpl,cmnNationalityDaoImpl,loginAuditDAOImpl,hrDepartmentMstDAOImpl,hrDesignationMstDAOImpl,hrEmpMstDAOImpl,hrRoleMstDAOImpl,aclMstRoleDaoImpl,frmSystemParametersDaoImpl,frmExtCommAuditDtlDAOImpl,frameworkUtility,dataListAttributeMstDaoImpl,dataListEntityMstDAOImpl,dataListEntityStyleDaoImpl,dataListAttributeDtlsDaoImpl,userDataListMstDAOImpl,dataListServiceImpl,userDataServiceImpl,schedulerJobDaoImpl,schedulerTriggerDaoImpl,schedulerRecipientDaoImpl,schedulerConfigDaoImpl,schedulerService,wfAction,cmnGeographicLocDtlDaoImpl,cmnGeographicLocMpgDaoImpl,cmnGeographicLocMstDaoImpl,cmnGeographicLocPinDaoImpl,cmnGeographicLocationServiceImpl,employeePresenceDaoImpl,employeePresenceServiceImpl,cmnLookupDAOImpl,filePriorityServiceImpl,fileConfidentialityServiceImpl,lookupMstService,empAbsentService,aclLoginStatusDAO,loginAuditService,idGenerateDAO,roleMstService,homePage,wfHierarchyRefMstDao,schIntimationDao,intimationService,empMstService,aclRoleEleRltDao,aclSecureEleService,frmGlobalServiceDao,globalService,frmDBBundleDao,frmDBBundleService,blackListDao,blackListService,aclRoleRltDao,aclRoleRltService,cmnLangDao,cmnLangService,frmServicedao,frmService,cmnTemplateDtlDaoImpl,cmnTemplateMstDaoImpl,cmnTemplateMpgDaoImpl,cmndraftMstDaoImpl,templateManagerImpl,draftPlaceholderTest,fmsFileDraftDaoImpl,fmsFileDraftServiceImpl,orgOrganizationDtlDaoImpl,FrmSysParamServiceImpl,mailServiceImpl,smsServiceImpl,faxServiceImpl,notificationDaoImpl,cmnEventMpgDaoImpl,cmnEventMstDaoImpl,cmnNtfcnDaoImpl,CmnNotificationStatusDaoImpl,orgEmpcontactMstDaoImpl,notificationServiceImpl,postMstService,cmnLocationMstService,orgDtlDaoImpl,orgMstDaoImpl,orgService,orgOfficeService,orgOfficeMpgDao,orgPostDtlDao,orgEmpDsgnDao,orgEmpPostMpgDao,cmnAddressMstDaoImpl,cmnAddressFieldMpgDaoImpl,cmnAddressFieldMstDaoImpl,cmnAddressServiceImpl,orgCadreMstDaoImpl,cadreMasterserviceImpl,orgEmpMstDaoImpl,aclRoleMstDaoImpl,EmpServiceImpl,cmnLookupMstDAOImplDetails,orgUlbMasterDaoImpl,ulbMasterServiceImpl,cmnHolidayMstDaoImpl,cmnHolidayMstService,cmnOrgHldyMpgDaoImpl,cmnOrgHldyMpgService,orgEmpPostMpgDaoImpl,wfDelegationMstDaoImpl,wfDelegateServiceImpl,wfDelegationDao,draftPublishTest,attachmentByteArrayFromUUIDTest,roleElementMpgService,aclOperationRoleEleRltDaoImpl,aclElementMstDaoImpl,aclElementOperationDtlsDaoImpl,aclRoleElementRltDaoImpl,roleEleOpnMpgServiceImpl,subjectHierarchyConfigDtlsDaoImpl,hierarchyConfigurationDaoImpl,hierarchyPostConfigurationDaoImpl,hierarchyRoleConfigurationDaoImpl,subjectHierarchyConfigServiceImpl,subjectHierarchyConfigDaoImpl,userMstServiceImpl,baseLoginServiceImpl,postRoleServiceImpl,testAttachmentMstDaoImpl,testAttachmentRltDaoImpl,testAttachmentServiceImpl,orgUserMstServiceImpl,cmnLanguageMstServiceImpl,userService,queueService,auditService,auditDaoImpl,auditExceptionDaoImpl,serviceCatalogueDaoImpl,serviceCatalogueServiceImpl,projectAuditService,ruleEngineDAOImpl,ruleExecutorServiceImpl,cacheAdministrationService,wfDocAccessMpgDaoImpl,connectionFactory,messagesForProcessing,auditMessageToProcess,messageProcessor,processListenerContainer]; root of factory hierarchy

2014-11-28 17:47:59.537 INFO  HikariPool:241 - HikariCP pool HikariPool-0 is shutting down.

2014-11-28 17:47:59.542 ERROR ContextLoader:308 - Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'springSecurityFilterChain' defined in ServletContext resource [/WEB-INF/spring-security.xml]: Cannot resolve reference to bean 'ROBORequestFilter' while setting bean property 'filterChainMap' with key [Root bean: class [org.springframework.security.web.util.matcher.RegexRequestMatcher]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ROBORequestFilter' defined in ServletContext resource [/WEB-INF/spring-security.xml]: Cannot resolve reference to bean 'secService' while setting bean property 'eleUrlService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'secService' defined in ServletContext resource [/WEB-INF/spring-security.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txAdvice': Cannot resolve reference to bean 'txManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in ServletContext resource [/WEB-INF/digigov-service-config.xml]: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:353)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:153)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedMap(BeanDefinitionValueResolver.java:378)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:161)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)

at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)

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.factory.BeanCreationException: Error creating bean with name 'ROBORequestFilter' defined in ServletContext resource [/WEB-INF/spring-security.xml]: Cannot resolve reference to bean 'secService' while setting bean property 'eleUrlService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'secService' defined in ServletContext resource [/WEB-INF/spring-security.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txAdvice': Cannot resolve reference to bean 'txManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in ServletContext resource [/WEB-INF/digigov-service-config.xml]: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)

... 28 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'secService' defined in ServletContext resource [/WEB-INF/spring-security.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txAdvice': Cannot resolve reference to bean 'txManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in ServletContext resource [/WEB-INF/digigov-service-config.xml]: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:527)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)

... 38 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txAdvice': Cannot resolve reference to bean 'txManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in ServletContext resource [/WEB-INF/digigov-service-config.xml]: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.aop.support.AbstractBeanFactoryPointcutAdvisor.getAdvice(AbstractBeanFactoryPointcutAdvisor.java:85)

at org.springframework.aop.aspectj.AspectJProxyUtils.isAspectJAdvice(AspectJProxyUtils.java:67)

at org.springframework.aop.aspectj.AspectJProxyUtils.makeAdvisorChainAspectJCapableIfNecessary(AspectJProxyUtils.java:49)

at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.extendAdvisors(AspectJAwareAdvisorAutoProxyCreator.java:101)

at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findEligibleAdvisors(AbstractAdvisorAutoProxyCreator.java:88)

at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.getAdvicesAndAdvisorsForBean(AbstractAdvisorAutoProxyCreator.java:68)

at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.wrapIfNecessary(AbstractAutoProxyCreator.java:359)

at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessAfterInitialization(AbstractAutoProxyCreator.java:322)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:407)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1461)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

... 44 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in ServletContext resource [/WEB-INF/digigov-service-config.xml]: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)

... 64 more

Caused by: org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at com.zaxxer.hikari.hibernate.HikariConnectionProvider.unwrap(HikariConnectionProvider.java:133)

at org.springframework.orm.hibernate4.SessionFactoryUtils.getDataSource(SessionFactoryUtils.java:101)

at org.springframework.orm.hibernate4.HibernateTransactionManager.afterPropertiesSet(HibernateTransactionManager.java:264)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)

... 71 more

2014-11-28 17:47:59.561 ERROR RunGetFromMessageQueue:71 - Exception occure in RunGetFromMessageQueuejava.lang.NullPointerException

java.lang.NullPointerException

at com.tcs.digigov.core.dao.RunGetFromMessageQueue.<init>(RunGetFromMessageQueue.java:55)

at com.tcs.digigov.core.dao.AuditListener.contextInitialized(AuditListener.java:34)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)

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)

Even after setting connectionTestQuery I am getting connectionTestQuery must be set. I had added loggers PropertyBeanSetter.java class to see if the properties are getting set or not. Even there the values are getting set.

Kindly let me know the way forward.

PS: HikariConnectionProvider for Hibernate 4.2.16 needs to be updated, as package structure for one of the class has changed.

org.hibernate.service.jdbc.connections.spi.ConnectionProvider

[Jens]

2014-11-28 17:47:55.635 ERROR HikariPool:422 - JDBC4 Connection.isValid() method not supported, connection test query must be configured

Your JDBC driver does not fully implement JDBC 4 so you must configure Hikari to use a connection test query instead of connection.isValid().

-- J.

[hardik sheth]

Thanks for the response.

I have  already set the connection test query, yet it gives the error.

[Nitin Chauhan]

Try with log level debug for hikaricp. It lists all properties set in pool under text "HikariCP pool 0 configuration:" in logs. Hope that helps.

[Nitin Chauhan]

Also, "select 1 from dual" is ORACLE syntax. Check your DB manual for same.

[hardik sheth]

HI Thanks.

After enabling DEBUG log, I got how to set the connectionTestQuery. And query select 1 from dual works with DB2 as well.

Now I am getting following error 

Caused by: org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]

at com.zaxxer.hikari.hibernate.HikariConnectionProvider.unwrap(HikariConnectionProvider.java:152)

at org.springframework.orm.hibernate4.SessionFactoryUtils.getDataSource(SessionFactoryUtils.java:91)

at org.springframework.orm.hibernate4.HibernateTransactionManager.afterPropertiesSet(HibernateTransactionManager.java:336)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511)

Any idea?

[Nitin Chauhan]

please share how you set connectionTestQuery ...will help someone in future :)

wrt unwrap ..please try latest dev build as it has fix for something similar

[Brett Wooldridge]

This is probably a question better asked in the Hibernate forums, try to reach out to Brett Meyer.   When using Spring auto-wiring, you at least need to use pure jdbcUrl-based configuration.  Try eliminating the "hibernate.hikari.dataSourceClassName" property.  Not that it should affect anything, but you also do not need "hibernate.hikari.dataSource.connectionInitSql".

Brett W.

[hardik sheth]

HI Brett /Nitin,

I was able to resolve the issue and successfully integrate Hikari CP with Hibernate and Spring. I was able to do configuration with two different way

1) Using connection_provider class.

<bean id="sessionFactory"

class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

<property name="dataSource" ref="dataSourceHikariMaster"/> 

<!-- Added by Hardik J Sheth to use annotation in Hibernate class -->

<property name="packagesToScan" >

<array>

<value>com.tcs.digigov.*</value>

</array>

</property>

<!-- Added by Hardik J Sheth to use annotation in Hibernate class -->

<property name="hibernateProperties">

<props>

<prop key="hibernate.connection.release_mode">auto</prop>

<!-- c3p0 conneciton pool properties -->

<!-- end of c3p0 props -->

<prop key="hibernate.show_sql">false</prop>

<prop key="hibernate.format_sql">false</prop>

<prop key="hibernate.dialect">${dialect}</prop>

<prop key="hibernate.use_outer_join">true</prop>

<prop key="hibernate.use_sql_comments">false</prop>

<prop key="hibernate.jdbc.batch_size">${batchSize}</prop>

<prop key="hibernate.connection.release_mode">auto</prop>

<!-- <prop key="hibernate.hikari.dataSourceClassName">com.ibm.db2.jcc.DB2SimpleDataSource</prop> -->

<!-- <prop key="hibernate.hikari.dataSource.driverType">4</prop>

<prop key="hibernate.hikari.dataSource.serverName">10.139.4.210</prop>

<prop key="hibernate.hikari.dataSource.portNumber">50000</prop>

<prop key="hibernate.hikari.dataSource.databaseName">AMCDEV</prop>

<prop key="hibernate.hikari.dataSource">com.ibm.db2.jcc.DB2DataSource</prop>

<prop key="hibernate.hikari.dataSource.username">${username}</prop>

<prop key="hibernate.hikari.jdbcUrl">jdbc:log4jdbc:db2://10.139.4.210:50000/AMCDEV:currentSchema=AMCDEV;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;</prop>

<prop key="hibernate.hikari.dataSource.password">${password}</prop>

<prop key="hibernate.hikari.driverClassName">${driverClass}</prop>

<prop key="hibernate.hikari.username">${username}</prop>

<prop key="hibernate.hikari.password">${password}</prop>

<prop key="hibernate.hikari.connectionTestQuery">select 1 from dual</prop> -->

<!-- <prop key="hibernate.hikari.dataSource.connectionInitSql">select 1 from dual</prop>  -->

<prop key="hibernate.hikari.autoCommit">false</prop>

 

<!--properties for Query cahce and second leve cache-->

<prop key="hibernate.cache.use_query_cache"></prop>

<!-- Added by Nirav Bumia for enabling second level caching -->

<prop key="hibernate.cache.use_second_level_cache">true</prop>

<!-- Added By Hardik Joshi -->

<!-- <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop> -->

<!-- <prop key="hibernate.cache.provider_class">org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</prop> -->

<prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</prop>

<!-- <prop key="net.sf.ehcache.configurationResourceName">ehcacheMaster.xml</prop> -->

<!--  <prop key="org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator">com.zaxxer.hikari.hibernate.HikariConnectionProvider</prop> 

--> <!-- <prop key="hibernate.connection.provider_class">com.zaxxer.hikari.hibernate.HikariConnectionProvider</prop> -->

<prop key="hibernate.generate_statistics">true</prop>

</props>

</property>

<property name="mappingJarLocations">

<list>

<!--  Changed by Ruchita : Usage Statistics Starts -->

 <value>WEB-INF/lib/digi*.jar</value>

<!--  Changed by Ruchita : Usage Statistics ends -->

 <value>WEB-INF/lib/hrmis-*.jar</value>

 <value>WEB-INF/lib/sample-*.jar</value>

 <value>WEB-INF/lib/ifms-*.jar</value>

 <!--  Added by Ruchi : Scheduler Starts -->

 <value>WEB-INF/lib/dg-scheduler-*.jar</value>

<value>WEB-INF/lib/dg-*.jar</value>

 <!--  Added by Ruchi : Scheduler Ends -->

 </list>

        </property>

</bean>

Here I had to update the HikariConnectionProvider class to return data source in unwrap method as follows.

@Override

   @SuppressWarnings("unchecked")

   public <T> T unwrap(Class<T> unwrapType)

   {

      /*if (isUnwrappableAs(unwrapType)) {

         return (T) this;

      }

      else {

         throw new UnknownUnwrapTypeException(unwrapType);

      }*/

       return (T) this.hds;

   }

2) Without connection provider class

In this case I had removed the hibernate.connection.provider_class from LocalSessionFactoryBean and following is the dataSource class.

<bean id="dataSourceHikariMaster"

class="com.zaxxer.hikari.HikariDataSource">

<property name="username"><value>${username}</value></property>

<property name="jdbcUrl"><value>${connectionUrl}</value></property>

<property name="password"><value>${password}</value></property>

<property name="driverClassName"><value>${driverClass}</value></property>

<property name="connectionTestQuery"><value>select 1 from dual</value></property>

<property name="connectionInitSql"><value>select 1 from dual</value></property>  

<property name="autoCommit"><value>false</value></property>

</bean>

Thanks again for the help.

[Brett Wooldridge]

Thanks for the update, Hardik.  I'll look at the HikariConnectionProvider to see if it is doing something wrong, or if there is a workaround.  Also note that Hibernate 4.3.1 and newer includes it's own HikariConnectionProvider, and that should be used instead of the one provided by HikariCP if you upgrade Hibernate.

-Brett