We tried to use JDBC adapter to connect with IBM AS400 DB2 server(known as iServer), but SAP confirmed that JDBC adapter can not connect to IBM AS400 DB2 database server(iServer) which uses the driver jt400.jar for connectivity. Now, we are planning to write Groovy script to directly connect with DB2 server and read/write the data. From my local machine eclipse tool,we are able to use JT400.jar driver file and connect with DB2 server successfully.
Next step is to make this groovy work directly in CPI IFlow. Hence, I created IFlow and using groovy script for DB2 connectivity from IFlow and uploaded JT400.jar in the RESOURCES tab. But, groovy is throwing the error: SQLException: No suitable driver found.
We can see some blogs(given below) related to using custom java jars in groovy script, but no information related to using standard jar files in groovy. Please let us know, how to use standard jar files in groovy scripts.