[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Configuring ejb3-timer-service.xml (JBoss 5.0.0.CR1)

[PeterJ]

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#4174365

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4174365