Database driver

In order for InterFormNG to connect to a database, it needs a JDBC driver for the particular database type. The driver comes in the form of a .jar
file which can usually be downloaded from the database vendor's website. 

If the JDBC driver is missing, then you might get the error message:

Connection failed, error: No suitable driver is found for xxxx.

JDBC driver for AS400/iSeries/IBM i

On the AS400 platform you can find the JDBC driver as the jt400.jar file in the IFS in the path:

/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar

JDBC driver for MS SQL server

The JDBC driver for MS SQL Server can e.g. be downloaded via this link:

https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

• This will download a zip file. After unzipping the file you can find the JDBC driver as the file: mssql-jdbc-11.2.0.jre8.jar.

• This works for InterFormNG2 version 3.4.3 and below.
  

• For version 3.5.0 and above, both the jre8 and jre11 jar version should work.

You can then install it as described below.

Install the JDBC driver

You need to stop and start the InterFormNG2 service after installing a JDBC driver.

The installation is a matter of copying the JDBC driver to a folder.

For Version 3.5.0 and above of InterFormNG2

• In Windows the driver.jar should be placed in the folder:
  

  <INTERFORMNG2-INSTALL-LOCATION>/libext

  This is as default this path:
  

  C:\Program Files\InterFormNG2\libext

• On the IBM i platform the driver should be placed in this folder:
  

  /iformng2/InterFormNG-shell/Core/libext

For Version 3.4.3 and below of InterFormNG2

• On the Windows platform you should place the jdbc driver inside the subdirectories
  

   /jre/lib/ext

  of where InterFormNG2 is installed.
  That is default:
  

  C:\Program Files\InterFormNG2\jre\lib\ext

• On the IBM i platform it can e.g. be:
  

   /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/jre/lib/ext

• On other platforms you should place the jdbc driver inside the directory of the JDK (Java Development Kit), that is used for InterFormNG2.

 

• Related Articles

• From database

  A workflow can be initiated by a job record in a database table. Only relational databases are supported. Please notice, that this input only supports the very specific table layout as described in the section, Database configuration, where in input ...

• Database configuration

  The section below describes the database configuration for the From database workflow input, which is very seldomly used. For most you should consider the alternative: From database with custom SQL. To use the database input component, database ...

• Database connections

  If you want InterFormNG2 to connect to a database in order to get input files for processing, then you need to configure the database as below. This section contains these topics: Prerequisite A prerequisite for a database connection is, that you ...

• Enrich XML from database

  It is possible to change the contents of an XML file and to add data from an external database with the advanced special workflow component: Enrich XML from database. An alternative to this component is ng.databaseLookup, which can e.g. be used ...

• Enrich spooled file from database

  It is possible to change the contents of a spooled file (as known on the IBM i platform) and to add data from an external database with the advanced special workflow component: Enrich spooled file from database. You can also add data with the ...