topic Seeting up Hikari Connection pool with Actitviti DB in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/seeting-up-hikari-connection-pool-with-actitviti-db/m-p/188370#M141500 <HTML><HEAD></HEAD><BODY><SPAN>HI</SPAN><BR /><BR /><SPAN>I want to use HIkari as a connection pool and jtds as a driver. Following is my configuration.</SPAN><BR /><BR /><SPAN>&lt;bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="dataSourceClassName" value="net.sourceforge.jtds.jdbcx.JtdsDataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="dataSourceProperties"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;props&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;prop key="url"&gt;jdbc:jtds:sqlserver://localhost:1433/Galileo_DB&lt;/prop&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;prop key="user"&gt;galileo_user&lt;/prop&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;prop key="password"&gt;Galileo@2014&lt;/prop&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/props&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; </SPAN><BR /><SPAN> &lt;!– HikariCP configuration –&gt;</SPAN><BR /><SPAN>&lt;bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;constructor-arg ref="hikariConfig" /&gt;</SPAN><BR /><SPAN>&lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&nbsp; &lt;bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchema" value="activiti" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseTablePrefix" value="activiti." /&gt;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="deploymentResources" value="classpath*:*.bpmn" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bean&gt;</SPAN><BR /><BR /><BR /><SPAN>And I’m getting the following error.</SPAN><BR /><SPAN>Nov 18, 2014 4:44:09 PM org.apache.catalina.core.StandardContext listenerStart</SPAN><BR /><SPAN>SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/spring/root-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.RuntimeException: java.beans.IntrospectionException: Method not found: setUrl</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:278)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5221)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.FutureTask.run(FutureTask.java:266)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:744)</SPAN><BR /><SPAN>Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.RuntimeException: java.beans.IntrospectionException: Method not found: setUrl</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:164)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:125)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:270)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 23 more</SPAN><BR /><SPAN>Caused by: java.lang.RuntimeException: java.beans.IntrospectionException: Method not found: setUrl</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.util.PropertyBeanSetter.setProperty(PropertyBeanSetter.java:129)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.util.PropertyBeanSetter.setTargetFromProperties(PropertyBeanSetter.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.pool.HikariPool.initializeDataSource(HikariPool.java:532)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.pool.HikariPool.&lt;init&gt;(HikariPool.java:138)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.pool.HikariPool.&lt;init&gt;(HikariPool.java:104)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.HikariDataSource.&lt;init&gt;(HikariDataSource.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:408)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 25 more</SPAN><BR /><SPAN>Caused by: java.beans.IntrospectionException: Method not found: setUrl</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.beans.PropertyDescriptor.&lt;init&gt;(PropertyDescriptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.zaxxer.hikari.util.PropertyBeanSetter.setProperty(PropertyBeanSetter.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 35 more</SPAN><BR /><BR /><BR /><SPAN>Please let me know where I’m doing wrong in my configurations.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /></BODY></HTML> Tue, 18 Nov 2014 14:59:05 GMT mann_frnd 2014-11-18T14:59:05Z Seeting up Hikari Connection pool with Actitviti DB https://connect.hyland.com/t5/alfresco-archive/seeting-up-hikari-connection-pool-with-actitviti-db/m-p/188370#M141500 HII want to use HIkari as a connection pool and jtds as a driver. Following is my configuration.&lt;bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig"&gt;&nbsp;&nbsp;&nbsp; &lt;property name="dataSourceClassName" value="net.sourceforge.jtds.jdbcx.JtdsDataSource" /&gt;&nbsp;&nbsp;&nbsp; &lt;property name="dataSourcePro Tue, 18 Nov 2014 14:59:05 GMT https://connect.hyland.com/t5/alfresco-archive/seeting-up-hikari-connection-pool-with-actitviti-db/m-p/188370#M141500 mann_frnd 2014-11-18T14:59:05Z Re: Seeting up Hikari Connection pool with Actitviti DB https://connect.hyland.com/t5/alfresco-archive/seeting-up-hikari-connection-pool-with-actitviti-db/m-p/188371#M141501 <HTML><HEAD></HEAD><BODY><SPAN>The exception is crystal clear:</SPAN><BR /><BR /><SPAN>Method not found: setUrl</SPAN><BR /><BR /><BR /><SPAN>You are setting the url property. Hikari datasource does not have that property. Please check the Hikare connection configuration in the docs.</SPAN></BODY></HTML> Thu, 20 Nov 2014 08:05:13 GMT https://connect.hyland.com/t5/alfresco-archive/seeting-up-hikari-connection-pool-with-actitviti-db/m-p/188371#M141501 jbarrez 2014-11-20T08:05:13Z