Forum Discussion

rcis's avatar
rcis
New Contributor
7 years ago
Solved

How do you configure a iSeries Navigator (AS400) database in SoapUI NG Pro?

How do you configure the database in SoapUI NG Pro to connect with the AS400 database (iSeries Navigator?) This is what I currently have set up - I'm looking for any suggestions/ideas.  Thanks!   ...
  • rcis's avatar
    rcis
    7 years ago

    In Preferences > JDBC drivers, I was able to get it configured by adding the following for the driver:

    com.ibm.as400.access.AS400JDBCDriver

    I then added the Connection String Template as:

    jdbc:as400://<HOST:123.123.12.12>/<DB>:user=<USER>;password=<PASSWORD>;

     

    *Note to get the IP address, open a CMD window and ping the database (i.e. ping databaseName.corp.company.com)

nmrao's avatar
nmrao
Champion Level 3

It is advised & right way is to copy the library under READY_API/bin/ext.

 

If you copy else where ( like you did), then you will lose what changes have been made to make it work and it might cause an issue if you want this to work other machines or co-workers computers.

 

And there are two ways to connect:

1. JDBC Request test step

2. Groovy Script test step: here you need to register the driver using below statement which documented here #10

com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( "your driver class" )

 

rcis's avatar
rcis
New Contributor
7 years ago

In Preferences > JDBC drivers, I was able to get it configured by adding the following for the driver:

com.ibm.as400.access.AS400JDBCDriver

I then added the Connection String Template as:

jdbc:as400://<HOST:123.123.12.12>/<DB>:user=<USER>;password=<PASSWORD>;

 

*Note to get the IP address, open a CMD window and ping the database (i.e. ping databaseName.corp.company.com)

  • groovyguy's avatar
    groovyguy
    Champion Level 1
    7 years ago

    Thanks for coming back and providing the steps to get it working. I'm glad you got it figured out!