Quartz « DataSource « Java Database Q&A





1. Custom DataSource doesn't work    forums.terracotta.org

The value set for the "org.quartz.dataSource.myCustomDS.connectionProvider.class" property must be a class that implements ConnectionProvider -- you can easily do this if you wish. You should more easily be able to have Quartz create the datasource as you did in your second attempt -- it looks like you just didn't have DBCP and/or it's dependencies (such as commons-pool) in your application's classpath. ...

2. Quartz dataSource usage issue    forums.terracotta.org

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 ...

3. accessing datasource (web app):You are trying to use a connection factory that has been shut down    forums.terracotta.org

Hi, We had some jobs that access oracle database thru datasource defined in jboss. Basically it has been working but suddenly we're getting next exception when trying to get the connection. Does anyone have a clue of why is this happening? Caused by: org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - ...

4. Problem with Quartz an CMT Datasource    forums.terracotta.org

Hello together, I have a installation of a J2EE Software an problems with quartz and the CMT Datasource. We have updated quartz from 1.4 to 1.7.3. My system environment is as follow: - JBoss 4.2.3 GA - mySql 5.0.67 - mysql-Driver 5.0.5 GA - Quartz-Version: 1.7.3 (Updated from Quartz 1.4) - Hibernateversion 2.0 My JBoss Datasource looks as follow: Code:

5. No setter for property 'dataSource'    forums.terracotta.org

#============================================================================ # Configure Main Scheduler Properties #============================================================================ org.quartz.scheduler.instanceName = ClusteredScheduler org.quartz.scheduler.instanceId = AUTO #============================================================================ # Configure ThreadPool #============================================================================ org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool org.quartz.threadPool.threadCount = 25 org.quartz.threadPool.threadPriority = 5 #============================================================================ # Configure JobStore #============================================================================ org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreCMT org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate org.quartz.jobStore.useProperties = false org.quartz.jobStore.dataSource = quartzDS org.quartz.jobStore.nonManagedTXDataSource = quartzDSNoTx org.quartz.jobStore.tablePrefix = QRTZ_ org.quartz.jobStore.isClustered = true org.quartz.jobStore.clusterCheckinInterval = 20000 org.quartz.jobStore.acquireTriggersWithinLock=true #============================================================================ # Configure Datasources ...

6. quartz jdbc datasource connection pooling    forums.terracotta.org

org.terracotta.quartz.skipUpdateCheck=true # Generates a unique instance ID org.quartz.scheduler.instanceId=cluster1.node1 #Naming convention: ClusterName.SchedulerName org.quartz.scheduler.instanceName=cluster1.node1 org.quartz.scheduler.rmi.export = false org.quartz.scheduler.rmi.proxy = false org.quartz.scheduler.wrapJobExecutionInUserTransaction = false org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool org.quartz.threadPool.threadCount = 10 org.quartz.threadPool.threadPriority = 5 org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate org.quartz.jobStore.useProperties = false org.quartz.jobStore.dataSource = myDS org.quartz.jobStore.tablePrefix = QRTZ_ org.quartz.jobStore.isClustered = true #datasource stuff org.quartz.dataSource.myDS.driver=oracle.jdbc.driver.OracleDriver org.quartz.dataSource.myDS.user = myapp org.quartz.dataSource.myDS.password = password org.quartz.dataSource.myDS.maxConnections = 5 org.quartz.dataSource.myDS.URL=jdbc:oracle:thin:@192.168.1.1:1521:qrtz ...

7. [Quartz 2.1.1] datasource    forums.terracotta.org

Hello people; I use the Quartz API and I'm interested in "JobStore persistent" I wonder if there's a way not to put the parameters of the datasource in quartz properties file. The tracks available to me I guess: 1 - Use the datasource configured on my server application. on http://quartz-scheduler.org/document...figDataSources I find: quote: Example of a Datasource referenced from an Application ...

8. The conflict between 2 applications when using the same datasource    forums.terracotta.org

hello,I am encountering a problem,i have 2 applications using the same datasource,but i fount that seems there is a thread monitoring the change of triggers and jobs,then trigger all the jobs in my database,i am wondering if there is a way to trigger the jobs in the application where they are really belong to ,instead of trigger all the jobs in ...