...
| Code Block |
|---|
<!--
HSQLDB Resource
<Parameter name="org.quartz.jobStore.driverDelegateClass" value="org.quartz.impl.jdbcjobstore.HSQLDBDelegate" override="false"/>
<Resource auth="Container"
type="javax.sql.DataSource"
name="jdbc/frevvoDS"
driverClassName="org.hsqldb.jdbcDriver"
username="sa"
password=""
url="jdbc:hsqldb:file:${catalina.home}/../data/db/forms"
maxActive="200"
maxIdle="20"
maxWait="10000"
validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
testOnBorrow="true"
testOnIdle="true"
timeBetweenEvictionRunsMillis="10000"
removeAbandoned="true"
logAbandoned="true"/>
--> |
...
| Code Block |
|---|
<!-- SQLSERVER Resource --> <Parameter name="org.quartz.jobStore.driverDelegateClass" value="org.quartz.impl.jdbcjobstore.MSSQLDelegate" override="false"/> <Resource auth="Container" maxActive="200" maxIdle="20" maxWait="10000" validationQuery="select 1" testOnBorrow="true" testOnIdle="true" timeBetweenEvictionRunsMillis="10000" removeAbandoned="true" logAbandoned="true" name="jdbc/frevvoDS" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" username="root" password="" type="javax.sql.DataSource" url="jdbc:sqlserver://localhost:1433;databaseName=frevvo;"/> |
| Note |
| There is now a parameter for org.quartz.jobStore.driverDelegateClass which is automatically configured for SQL and Oracle databases. If the delegate property is explicitly set, it will override the automatic selection. |
Configure the frevvo database
...