Configuring Quartz Datasources

If you're using the JDBC JobStore, you'll need to define a datasource for its use. If you're using the JobStoreCMT, you'll actually need to define two datasources. Datasources can be configured in three ways:

  • The pool properties are specified in the quartz.properties file so that Quartz can create the Datasource itself.
  • The JNDI location of an application server managed Datasource can be specified so that Quartz can use it.
  • A custom-defined org.quartz.utils.ConnectionProvider implementation can be used.

Each datasource that you define must be given a name, and the properties you define for each must contain that name. The dataSource's NAME can be anything you want; it has no meaning and simply identifies the datasource when it is assigned to the JDBC JobStore.

When configuring a datasource using quartz.properties to define all the pool properties, the properties in Table A.6 are available for use.

Table A.6. The Properties for Configuring the Quartz Datasource

Name

Required

Type

Default Value

org.quartz.dataSource.NAME.driver

Yes

String

Null

org.quartz.dataSource.NAME.URL

Yes

String

null

org.quartz.dataSource.NAME.user

No

String

""

org.quartz.dataSource.NAME.password

No

String

""

org.quartz.dataSource.NAME.maxConnections

No

Integer

10

org.quartz.dataSource.NAME.validationQuery

No

String

null

org.quartz.jobStore.clusterCheckinInterval

No

Long

15000

 

org.quartz.dataSource.NAME.driver

This must be the Java class name of the JDBC driver for your database.

org.quartz.dataSource.NAME.URL

This is the connection URL (host, port, and so on) for connection to your database.

org.quartz.dataSource.NAME.user

This is the username to use when connecting to your database.

org.quartz.dataSource.NAME.password

This is the password to use when connecting to your database.

org.quartz.dataSource.NAME.maxConnections

This is the maximum number of connections that the DataSource can create in its pool of connections.

org.quartz.dataSource.NAME.validationQuery

This is an optional SQL query string that the DataSource can use to detect and replace failed/corrupt connections. For example, an Oracle user might choose select table_name from user_tables, which is a query that should never fail unless the connection is actually bad.

When you're using the Datasource defined in an application server, the properties in Table A.7 are available.

Table A.7. The Properties for Configuring Quartz to Use a Datasource from an Application Server

Name

Required

Type

Default Value

org.quartz.dataSource.NAME.jndiURL

Yes

String

null

org.quartz.dataSource.NAME.java.naming.factory.initial

No

String

null

org.quartz.dataSource.NAME.java.naming.provider.url

No

String

null

org.quartz.dataSource.NAME.java.naming.security.principal

No

String

null

org.quartz.dataSource.NAME.java.naming.security.credentials

No

String

null

 

org.quartz.dataSource.NAME.jndiURL

This is the JNDI URL for a DataSource that is managed by your application server.

org.quartz.dataSource.NAME.java.naming.factory.initial

This is the (optional) class name of the JNDI InitialContextFactory that you want to use.

org.quartz.dataSource.NAME.java.naming.provider.url

This is the (optional) URL for connecting to the JNDI context.

org.quartz.dataSource.NAME.java.naming.security.principal

This is the (optional) user principal for connecting to the JNDI context.

org.quartz.dataSource.NAME.java.naming.security.credentials

These are the (optional) user credentials for connecting to the JNDI context.


Scheduling in the Enterprise

Getting Started with Quartz

Hello, Quartz

Scheduling Jobs

Cron Triggers and More

JobStores and Persistence

Implementing Quartz Listeners

Using Quartz Plug-Ins

Using Quartz Remotely

Using Quartz with J2EE

Clustering Quartz

Quartz Cookbook

Quartz and Web Applications

Using Quartz with Workflow

Appendix A. Quartz Configuration Reference



Quartz Job Scheduling Framework(c) Building Open Source Enterprise Applications
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
ISBN: 0131886703
EAN: 2147483647
Year: N/A
Pages: 148

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net