[jira] [Commented] (CAMEL-12875) Quartz2- Releasing Idle connections

[Karthi (JIRA)]

    [ 
https://issues.apache.org/jira/browse/CAMEL-12875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16647543#comment-16647543
 ] 

Karthi commented on CAMEL-12875:
--------------------------------

Camel 2.21.0 version

In Camel  xml implementing quartz2
<bean id="quartz2" class="org.apache.camel.component.quartz2.QuartzComponent">
 <property name="propertiesFile" value="quartz.properties"/> 
 </bean>


<from 
uri="quartz2://myGroup/durableJobRoute?durableJob=true&amp;stateful=true&amp;cron="0*3"/>

 

Inside quartz properties files


# Main Quartz configuration 
org.quartz.scheduler.jobFactory.class=org.quartz.simpl.SimpleJobFactory 
org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX 
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
 
org.quartz.jobStore.dataSource=quartzDataSource 
org.quartz.jobStore.tablePrefix=QRTZ_ 
org.quartz.jobStore.isClustered=true 
org.quartz.threadPool.class=org.quartz.simpl.SimpleThreadPool 
org.quartz.threadPool.threadCount=10 
org.quartz.jobStore.clusterCheckinInterval=2000

JobStore: JDBC jobStoreTX 
org.quartz.dataSource.quartzDataSource.driver=org.postgresql.Driver
org.quartz.dataSource.quartzDataSource.URL=jdbc:postgresql:
org.quartz.dataSource.quartzDataSource.user=esb123 
org.quartz.dataSource.quartzDataSource.password=*****
org.quartz.dataSource.quartzDataSource.maxConnections=5 
org.quartz.dataSource.quartzDataSource.validationQuery=select 0 from dua

{color:#FF0000}If i implement below property getting exception no setter.
org.quartz.dataSource.myDS.idleConnectionValidationSeconds=50{color}

 

> Quartz2- Releasing Idle connections 
> ------------------------------------
>
>                 Key: CAMEL-12875
>                 URL: https://issues.apache.org/jira/browse/CAMEL-12875
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-quartz2
>    Affects Versions: 2.21.0
>            Reporter: Karthi
>            Priority: Minor
>
> Hi team,
>    We are using quartz2 implementations with 
> "org.quartz.impl.jdbcjobstore.PostgreSQLDelegate". We wanted to release test 
> idle connections. 
> We tried this property 
> "org.quartz.dataSource.NAME.idleConnectionValidationSeconds" in 
> quartz.properties files.
> But its not working in this version.Not even considering this property.after 
> some seconds still idle connections are persist.
> How to implement this feature.Are this available in later versions ?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)