两个quartz访问同一数据库,使用Quartz获取数据库连接

I have a requirement where i need to insert data and retrieve the same during my scheduling process.Though i can create my own connection class and can do the work but i am wondering is there a way to obtain a data base connection using Quartz API.

Since Quartz is efficiently doing data base connection and handling so my intention was to use a well defined structure in stead of creating my own.

I saw the following code in the Quartz

conn = DBConnectionManager.getInstance().getConnection(

getDataSource());

but i am not sure how good this approach is to obtain the connection.Or is there any good example/resource to create an efficient database connection class.

Quartz Property File

org.quartz.scheduler.instanceName=QuartzScheduler

org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX

org.quartz.threadPool.threadCount=7

org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate

org.quartz.jobStore.tablePrefix = QRTZ_

org.quartz.jobStore.dataSource = myDS

org.quartz.dataSource.myDS.driver=com.mysql.jdbc.Driver

org.quartz.dataSource.myDS.URL=jdbc:mysql://localhost:3306/quartz

org.quartz.dataSource.myDS.user=root

org.quartz.dataSource.myDS.password=root

org.quartz.dataSource.myDS.maxConnections=5

解决方案

You can get connection utilizing Quartz by naming the data-source you have defined in your property file like

conn = DBConnectionManager.getInstance().getConnection("myDS");

here myDS is the name of the data source you have defined in your property file

but since you are using the underlying data pool of quartz make sure that you close the connection so that it should get back to the pool.

This is just an outline based on my knowledge of Quartz and how it get connection.