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.

 View Only
  • 1.  Informix Connection Enabling Error

    Posted Wed March 25, 2009 07:50 AM

    i am working on 7.1.1 version having 6.5 JDBC Adapter and informix Databse is 11 version
    while am enable the connection i got the following error.

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.InformixConnection:InformixConnection.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.200] The JDBC DataSource class “com.informix.jdbcx.ifxDataSource” cannot be located.
    com.informix.jdbcx.ifxDataSource

    i copied the jar file in
    <int_loc>\lib\jars\ifxjdbc-2.1.jar
    <int_loc>\lib\jars\ifxjdbc.jar
    <int_loc>\lib\jars\xerces.jar

    <int_loc>\packages\WmJDBCAdapter\code\jars\static\ifxjdbc-2.1.jar
    <int_loc>\packages\WmJDBCAdapter\code\jars\static\ifxjdbc.jar
    <int_loc>\packages\WmJDBCAdapter\code\jars\static\xerces.jar

    connection details are

    DWAFCommon.InformixConnection:InformixConnection Details
    Connection Type JDBC Adapter Connection
    Package Name DWAFCommon
    Connection Properties
    Transaction Type NO_TRANSACTION
    DataSource Class com.informix.jdbcx.ifxDataSource
    serverName inf_10_wart
    user wmarsrd
    password ******
    databaseName nc_ws
    portNumber 1541
    networkProtocol olsoctcp
    Other Properties ifxIFXHOST=10.132.32.228
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 1
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 1000
    Expire Timeout (msec) 1000
    Startup Retry Count 0
    Startup Backoff Timeout (sec) 10

    any one help me why am getting the error,am i using correct jar files can any one attach the jar file need to connect to the Informix database.
    </int_Loc></int_Loc></int_Loc></int_Loc></int_Loc></int_Loc>


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


  • 2.  RE: Informix Connection Enabling Error

    Posted Wed March 25, 2009 07:51 AM

    Hi All,

    I Removed ifxjdbc-2.1.jar,ifxjdbc.jar,xerces.jar files from the <int_loc>\lib\jars\ and <int_loc>\packages\WmJDBCAdapter\code\jars\static\ locations and

    i kept
    JDBC.2.21.JC4.jar,JDBC.3.50.JC3DE.jar files in <int_loc>\lib\jars\ <int_loc>\packages\WmJDBCAdapter\code\jars\static\ and which i downloaded from IBM site. the propert setting for connection is

    InformixConnection Details
    Connection Type JDBC Adapter Connection
    Package Name DWAFCommon
    Connection Properties
    Transaction Type NO_TRANSACTION
    DataSource Class com.informix.jdbcx.IfxDataSource
    serverName inf_10_wart
    user warmsrd
    password ******
    databaseName nc_ws
    portNumber 1565
    networkProtocol tcp/ip
    Other Properties IfxIFXHOST=10.132.32.228
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 1
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 1000
    Expire Timeout (msec) 1000
    Startup Retry Count 0
    Startup Backoff Timeout (sec) 10

    i got below error while enabling the connection

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.InformixConnection:InformixConnection.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.200] The JDBC DataSource class “com.informix.jdbcx.IfxDataSource” cannot be located.
    com.informix.jdbcx.IfxDataSource.

    please any one help me on drivers jar files where i can be downloaded the jar files for informix database 11.50 version and WM 7.1.1 version having JDBC 6.5 version adapters.

    please attach me (anilellendula@gmail.com)the jar files to connect to the informix databse or give me the url to get download it.

    regards,
    anil kumar e
    </int_Loc></int_Loc></int_Loc></int_Loc>


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


  • 3.  RE: Informix Connection Enabling Error

    Posted Wed March 25, 2009 07:55 AM

    hi all,
    i downloaded JDBC.2.21.JC4.jar,JDBC.3.50.JC3DE.jar,JDBC.3.00.JC1DE.jar and
    JDBC.3.10.JC1DE jar files,which i downloaded from ibm
    site(http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc),kept these files in in IntegrationServer/lib/jars and
    WmJDBCAdapter\code\jars\static folde,i got the below error.

    InformixConnection Details
    Connection Type JDBC Adapter Connection
    Package Name DWAFCommon
    Connection Properties
    Transaction Type NO_TRANSACTION
    DataSource Class com.informix.jdbcx.IfxDataSource
    serverName inf_10_wart
    user warmsrd
    password ******
    databaseName nc_ws
    portNumber 1565
    networkProtocol tcp/ip
    Other Properties IfxIFXHOST=10.132.32.228
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 1
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 1000
    Expire Timeout (msec) 1000
    Startup Retry Count 0
    Startup Backoff Timeout (sec) 10

    Error

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable
    connection resource DWAFCommon.InformixConnection:InformixConnection.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure
    connection manager.
    [ADA.1.200] The JDBC DataSource class
    “com.informix.jdbcx.IfxDataSource” cannot be located.
    com.informix.jdbcx.IfxDataSource

    please send me the jar files and connection properties to set in connection


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


  • 4.  RE: Informix Connection Enabling Error

    Posted Wed March 25, 2009 01:26 PM

    Hi All,
    i removed all jar file from lib locations and i sucedded by these jar files ifxjdbc.jar and ifxjdbcx.jar,before ifxjdbcx.jar i didnot have this jar file,only these two files required to connect to the informix 11.50 database with below details.

    InformixConnection Details
    Connection Type JDBC Adapter Connection
    Package Name DWAFCommon
    Connection Properties
    Transaction Type NO_TRANSACTION
    DataSource Class com.informix.jdbcx.IfxDataSource
    serverName inf_10_wart
    user warmsrd
    password ******
    databaseName nc_ws
    portNumber 1565
    networkProtocol tcp/ip
    Other Properties IfxIFXHOST=10.132.32.228
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 1
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 1000
    Expire Timeout (msec) 1000
    Startup Retry Count 0
    Startup Backoff Timeout (sec) 10

    regards,
    anil kumar ellendula


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


  • 5.  RE: Informix Connection Enabling Error

    Posted Wed March 25, 2009 01:26 PM

    Hi All,
    i removed all jar file from lib locations and i sucedded by these jar files ifxjdbc.jar and ifxjdbcx.jar,before ifxjdbcx.jar i didnot have this jar files,only these two files required to connect to the informix 11.50 database with below details.

    InformixConnection Details
    Connection Type JDBC Adapter Connection
    Package Name DWAFCommon
    Connection Properties
    Transaction Type NO_TRANSACTION
    DataSource Class com.informix.jdbcx.IfxDataSource
    serverName inf_10_wart
    user warmsrd
    password ******
    databaseName nc_ws
    portNumber 1565
    networkProtocol tcp/ip
    Other Properties IfxIFXHOST=10.132.32.228
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 1
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 1000
    Expire Timeout (msec) 1000
    Startup Retry Count 0
    Startup Backoff Timeout (sec) 10

    regards,
    anil kumar ellendula


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