Driver Identifier and Driver Class

The JDBC driver that the SLQQuery action uses to access the database is a Java client package on the Z and I Emulator for Web client workstation that communicates with a server program on a remote host. This server program on the remote host provides access to the database.

The Z and I Emulator for Web client already includes a JDBC driver from the AS/400 Toolbox for Java. This driver is automatically downloaded as part of the emulator client. This driver allows a client to access DB2/400 data on a properly configured iSeries or AS/400.

If you need a different JDBC driver, contact the administrator of the remote database server to obtain the driver. You must take some action to deploy the driver to your Z and I Emulator for Web client workstations.

In the Driver Identifier listbox of the SQLQuery action window in the Macro Editor, select the driver provided with Z and I Emulator for Web, or select Other if you plan to use another driver.

The Driver Class field contains the fully qualified Java class name of the driver. If you select the driver provided with Z and I Emulator for Web, then the Macro Editor displays the class name for you in the Driver Class field (com.ibm.as400.access.AS400JDBCDRIVER) and does not allow you to modify the class name. In contrast, if you select Other in the Driver Identifier listbox, then you must type the fully qualified class name of the driver into the Driver Class field. If you do not know the fully qualified class name, contact the provider of the driver. When you type in the name, remember that case is significant (for example, com is different from COM).

If you want to add a driver to the list of available drivers in the Driver Identifier listbox (instead of having each time to select Other and type in the class name), then you can register the driver with Z and I Emulator for Web (see Registering a JDBC driver).