Geek Answers Handbook

Quartz Configuration with Oracle

How to configure the Quartz configuration file to work with Oracle. I am using Quartz.NET 2.0, Oracle 10G and Visual Studio 2010.

I implemented Quartz 1.0.3 in the project. I have to upgrade the Quartz project to version 2.0, to do this, I created Job in a test project and added links to Quartz Dlls. The strange thing is that Job works well without installing Quartz service ... how is this possible ???

+4
source share
2 answers
  • Run the Oracle table creation scripts contained in the quartz.net package. I think the script is under Quartz \ database \ tables \ tables_oracle.sql

  • Edit Quartz.Config

    quartz.jobStore.tablePrefix = your table prefix , I think default is QRTZ_ quartz.jobStore.dataSource = myDS quartz.dataSource.myDS.connectionString = your connection string quartz.dataSource.myDS.provider = OracleClient-20

I think you will be good to go if you use the built-in quartz, you can do number 2 in ypur code.

See this tutorial for more details.

+3
source

There are many options for running scheduled tasks in the Oracle database. So maybe you don't need Quartz for what you want to do. You can use the older DBMS_JOB package or the newer and more complex DBMS_SCHEDULER is also available in 10g.

+1
source

More articles:


All Articles