The ijp-setup.properties file
- driver
- is the name of the jdbc driver and must match the jar file for your database.
- dbProperties
- identifies the IJP jobs database and how to connect to it.
- glassfish
- is the top level of the glassfish installation. It must contain "glassfish/domains", and will be referred to here as
GLASSFISH_HOME as if an environment variable had been set.
- port
- is the administration port of the chosen glassfish domain which is typically 4848.
For a local oracle-xe installation the following values of driver, dbProperties should be good except for
the user and
password values:
driver=oracle.jdbc.pool.OracleDataSource
dbProperties=url="'"jdbc:oracle:thin:@//localhost:1521/XE"'":ImplicitCachingEnabled=true:MaxStatements=200:user=icat:password=secret
Note the
"'"
which is needed because the url contains colons which also separate individual properties.
For MySQL:
driver=com.mysql.jdbc.jdbc2.optional.MysqlDataSource
dbProperties=user=icat:password=secret:databaseName=ijp
Check that the IJP works
Launch the IJP by visiting https://localhost:8181/ijp, and login with the credentials defined in ijp.properties. Then:
- Choose "date" from the list of Job Types
- Click "Submit Job"; this should bring up a dialog "date Options" with buttons labelled Submit and Close.
- Click "Submit". The resulting dialog should display a single Submitted Job ID. Note the ID, and click Close.
- Click on "Show job status panel"; this should launch a separate dialog listing known jobs and their statuses.
- At or near the top of the list should be an entry for the noted ID, with name "date". If the Status is Queued,
wait until it changes to Completed. Once Completed, click Display Job Output.
- The output display should show that the job has run; at or near the end should be a line that ends with
"date ending with code 0".
Install the demojobs distribution (on both the IJP server and the batch server if they are different).
Repeat for these job types, to test other aspects of the IJP, e.gs:
- sleepcount
- Asks for sleep duration and no. of iterations. It should be possible to observe the output before the job completes.
- test_args_multi
- Allows the user to select multiple datasets and datafiles and submit them either to a single job, or one job per selection.
Output reports the IDs of the selected datasets/datafiles.
- create_datafile
- Allows the user to select one or more datasets; requests a filename and (one-line) contents.
For each selected dataset, runs a (separate) job that creates the file in that dataset.
- copy_datafile
- The user should select a single target dataset and a single datafile (in a different dataset).
The job will create a copy of the datafile in the target dataset.
Note that the IJP allows selection of multiple datasets and/or datafiles, and allows the user to run
multiple jobs; but in these cases the jobs will fail. Only a single dataset and a single datafile
(in a different dataset) should be selected.