5.1.17 IBM Toolbox for Java
JSM services such as the PDFSpoolFileService require IBM Toolbox for Java or JTOpen.
JSM ships with Open Source Software, JTOpen 8.2, codebase 5770-SS1 V7R2M0.00 built=20140313.
- The IBM Toolbox for Java is a library of Java classes that give Java programs easy access to IBM i data and resources.
- JTOpen is the open source version of Toolbox for Java.
- This toolbox is available as License Program 57xxJC1 - Toolbox for Java.
- This toolbox is available as License Program 57xxSS1 Extended Base Directory Support for V7R1.
- The jt400.jar file is located in the /QIBM/ProdData/HTTP/Public/jt400/lib directory.
For further information refer to:
IBM provides two JDBC drivers for the IBM i database:
Native JDBC driver
This is shipped as part of the IBM i Developer Kit for Java (57xxJV1).
It is implemented by making native method calls to the SQL CLI (Call Level Interface).
Consequently, it only runs on the IBM i JVM.
The class name to register is com.ibm.db2.jdbc.app.DB2Driver. The URL subprotocol is db2.
Toolbox JDBC driver
This is shipped as part of the IBM Toolbox for Java.
It is implemented by making direct socket connections to the database host server.
This JDBC driver runs on any JVM.
The class name to register is com.ibm.as400.access.AS400JDBCDriver. The URL subprotocol is as400.
Physical file journaling for JDBC updates
CRTJRNRCV JRNRCV(MYLIB/JDBC) TEXT('JDBC Journal Receiver')
CRTJRN JRN(MYLIB/JDBC) JRNRCV(MYLIB/JDBC) TEXT('JDBC Journal')
STRJRNPF FILE(MYLIB/MYFILE) JRN(MYLIB/JDBC) IMAGES(*BOTH)
It is easy to forget to start journaling when you create or change a physical file.
You can avoid such problems by creating a data area named QDFTJRN in any library where you want to automatically start journaling.
The new data area contains the name of a journal, and as long as the person creating the physical file has adequate authority, journaling will be started to the journal named in the data area.
You specify the journal library in the first 10 positions, and the second 10 positions contain the journal, and the last five positions contain *FILE. You can also specify *NONE in the last five positions to prevent journaling from starting.