Terracotta Discussion Forums

I am getting the following error in my application. Apparently its becuase QuartzOraclePool went out of resources.

I am using JobStoreCMT , with 'quartzDataSource' and 'quartzNonManagedDataSoruce'

my question is why org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection() is using 'quartzDataSoruce' instead of 'quartzNonManagedDataSoruce'

No resources currently available in pool "quartzDataSource" to allocate to applications, please increase the size of the pool and retry..
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.dev-scheduler':
weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException:
No resources currently available in pool QuartzOraclePool to allocate to applications,
please increase the size of the pool and retry..
[See nested exception: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool ILOraclePool to allocate to applications, please increase the size of the pool and retry..]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3811)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3847)

can you post your configuration (quartz.properties)?

Hi James,

following are the properties I am configuring through Spring SchedulerFactoryBean. Just to clarify, I am not concerned about the ResourceLimitException, my question is why it is using XA quartzDataSource while it should be using quartzNonManagedDataSoruce().
Thanks for your response in advance.

<bean id="schedulerFactoryBean" class="org.springframework.scheduling.quartz.SchedulerFactoryBean" lazy-init="true">
<property name="autoStartup" value="${scheduler.autoStartup}" /> 
<property name="waitForJobsToCompleteOnShutdown" value="${scheduler.waitForJobsToCompleteOnShutdown}" /> 
<property name="schedulerName" value="${scheduler.name}" /> 
<property name="startupDelay" value="${scheduler.startupDelay}" /> 

<property name="dataSource">
<ref bean="quartzDataSource"/>
</property>
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="quartzProperties">
<props>
<prop key="org.quartz.scheduler.instanceId">AUTO</prop>
<prop key="org.quartz.threadPool.class">org.quartz.simpl.SimpleThreadPool</prop>
<prop key="org.quartz.threadPool.threadCount">${scheduler.threadCount}</prop> 
<prop key="org.quartz.threadPool.threadPriority">5</prop>
<prop key="org.quartz.jobStore.isClustered">${scheduler.isClustered}</prop> 
<prop key="org.quartz.jobStore.misfireThreshold">${scheduler.misfireThreshold}</prop>

<prop key="org.quartz.jobStore.class">org.quartz.impl.jdbcjobstore.JobStoreCMT</prop>

<prop key="org.quartz.jobStore.driverDelegateClass">org.quartz.impl.jdbcjobstore.oracle.weblogic.WebLogicOracleDelegate</prop>
<prop key="org.quartz.jobStore.tablePrefix">QRTZ_</prop>

<prop key="org.quartz.jobStore.nonManagedTXDataSource">quartzNonManagedDataSoruce</prop>

</props>
</property>
</bean>