You need to do several things, so pardon my quoting from JBoss In Action
(
http://www.manning.com/jamae), chapter 15:
anonymous wrote : The first thing you'll need to do is download the Quartz source file
that corresponds to the version provided by JBoss AS. You can determine the Quartz version
by examining the META-INF/Manifest.mf file located in the server/xxx/lib/quartz.jar file.
|
| With the Quartz source code at hand, you need to change two things in the
server/xxx/deploy/ejb3-timer-server.xml file.
|
| First, the ejb3-timer-server.xml file contains a list of Quartz properties. You're
interested in this property:
|
| org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.HSQLDBDelegate
|
| You need to change the delegate class to match the one for your database. The valid
delegates can be found in the src/java/org/quartz/impl/jdbcjobstore directory of the
Quartz source. For example, use the PostgreSQLDelegate class for a PostgreSQL database. If
thereâÂÂs no delegate specific to your database, as is the case for MySQL, use the
StdJDBCDelegate class. For example, for MySQL this delegate property would be
|
| org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
|
| The second change is more complicated. The SqlProperties attribute in the
ejb3-timer-server.xml file contains a list of SQL statements used to create and initialize
the tables in the database. You need to replace these SQL statements with the ones for
your database. You can find the correct statements in the Quartz sources in the
docs/dbTables directory. For example, use the tables_postgres.sql file for a PostgreSQL
database.
| When replacing the SQL statements, leave the CREATE_* property name on the line. For
example, the property to create the job details table would look like
|
| CREATE_TABLE_JOB_DETAILS = CREATE TABLE qrtz_job_details(...);
|
| where the CREATE TABLE qrtz_job_details(...); text comes from the tables_*.sql file
for your database.
|
| For MySQL users, note that the tables_mysql.sql file uses uppercase letters for the
table names. If youâÂÂre running MySQL on Unix/Linux, make sure you make that change
because MySQL table names are case-sensitive on those platforms.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4174365#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...