IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
  • 1.  DB2/400 driver file JT400.jar not showing in IS Classpath

    Posted Fri July 28, 2006 03:06 PM

    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


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: DB2/400 driver file JT400.jar not showing in IS Classpath

    Posted Fri July 28, 2006 03:21 PM

    Just one more to add to my earlier message,

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

    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: DB2/400 driver file JT400.jar not showing in IS Classpath

    Posted Mon July 31, 2006 04:26 AM

    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


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 4.  RE: DB2/400 driver file JT400.jar not showing in IS Classpath

    Posted Mon July 31, 2006 12:39 PM

    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


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB