webMethods

webMethods

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.  JDBC Adapter 6.03

    Posted Mon September 12, 2005 09:17 PM

    Hii All,

    Can Anyone help me where i can download JDBC adapter 6.03. i want Update my JDBC adapter.

    Rg,
    -widodo-


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


  • 2.  RE: JDBC Adapter 6.03

    Posted Tue September 13, 2005 02:34 AM

    You can download the JDBC adapter using the standard Installer.


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


  • 3.  RE: JDBC Adapter 6.03

    Posted Mon October 09, 2006 06:31 AM

    the error encountered while setting jdbc connection

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource JDBCConnection:jdbccon.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.200] The JDBC DataSource class “Oracle.jdbc.Pool.OracleDataSource” cannot be located.
    Oracle.jdbc.Pool.OracleDataSource.class not found

    jdbc adapter connection properties

    Connection Type JDBC Adapter Connection
    Package Name JDBCConnect
    Connection Properties
    Transaction Type LOCAL_TRANSACTION
    DataSource Class Oracle.jdbc.Pool.OracleDataSource
    serverName TRF_Server
    user tgs
    password ******
    databaseName TGS_WEB.FRK.COM
    portNumber 1521
    networkProtocol TCP
    Other Properties driverType=thin
    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

    also the TNSNAMES.ORA entries in oracle is as

    TGS_WEB.FRK.COM=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = TRF_Server )(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = wbirep1)
    )


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