DB2/400 driver file JT400.jar not showing in IS Classpath

, ,
1

Hello,
I am running wM 6.1 and installed JDBC 6.0.3 adapter. Would need to connect DB2 database on AS/400 V5R3. All I have done is copied existing driver file JT400.jar that been used by JAVA application that connects to the same AS/400.

placed JT400.jar under IS directory path -
\webMethods6\IntegrationServer\packages\WmJDBCAdapter\code\jars

and restarted IS. But, I do not see this added to IS Classpath. Hence, when I get this error on enabling adapter connection,

[ADA.1.200] The JDBC DataSource class “com.ibm.as400.access.AS400JDBCDataSource” cannot be located.
com.ibm.as400.access.AS400JDBCDataSource

Adapter Connection Properties:

Transaction Type : LOCAL_TRANSACTION
DataSource Class : com.ibm.as400.access.AS400JDBCDataSource
serverName : (IP address supplied )
user : (valid user name and Password used)
password :
Other Properties: driverType=thin

Rest of the properties are defaulted.

Any help is greatly apprecaited.

Thanks,
Siva

2

Just one more to add to my earlier message,

   JT400.jar file is also copied to  path - \webMethods6\IntegrationServer\lib
3

Hi Siva,

the most common places for these type of jar files are
<IS_Root>/packages/WmJDBCAdapter/code/jars (maybe subdir static)
<IS_Root>/lib/jars

When it is placed under the Adapter it is only visible to the Adapter (should be sufficient for most cases) and will not be shown in the classpath on the About page (except if it is in the static subdir, then it will be added to he classpath).
When it is placed in the lib/jars, it will be added to the classpath.

Any typos in the DataSource Name? Trailing Blanks in DataSource field?
Are there any natives for this driver which might be missing?

Regards,
Holger

4

Hi Holger,

      Thanks for your help. It worked after placing .jar file in

<IS_Root>/lib/jars

Also, as you suggested subdir with static, it works good.

Thanks again,
Siva