Changing the JNDI name for the Quartz Scheduler

Use the instructions in this section if you need to change the JNDI name in the Quartz Scheduler to use the WebSphere JNDI name.

  1. Open the quartz.properties file with a text editor.
    Note: The default location is <LBI_HOME>\<SN_HOME>\Smart Notification.ear\lsnwar-<version_number>.war\WEB-INF\classes.
  2. Comment out the current configuration and add in the URL for the WebSphere JNDI as shown below:

    For MSSQL

    # org.quartz.dataSource.SNDB.driver = net.sourceforge.jtds.jdbc.Driver
# org.quartz.dataSource.SNDB.URL = jdbc:jtds:sqlserver://localhost:1433/SN9033
# org.quartz.dataSource.SNDB.user = snuser
# org.quartz.dataSource.SNDB.password = password
org.quartz.dataSource.SNDB.jndiURL = java:comp/env/jdbc/LawsonSN
org.quartz.dataSource.SNDB.maxconnections = 10
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MyMSSQLDelegate

    For ORACLE

    # org.quartz.dataSource.SNDB.driver = oracle.jdbc.driver.OracleDriver
# org.quartz.dataSource.SNDB.URL = jdbc:oracle:thin:@OracleServer:1521:ORCL
# org.quartz.dataSource.SNDB.user = snuser
# org.quartz.dataSource.SNDB.password = password
org.quartz.dataSource.SNDB.jndiURL = java:comp/env/jdbc/LawsonSN
org.quartz.dataSource.SNDB.maxconnections = 10
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
    Note: You should comment out the initial configuration information in case you want to revert to it at some point.
  3. Restart WebSphere for the changes to take effect.