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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  JDBC Adapter

    Posted 06/07/04 05:14 PM

    Can JDBC OCI and JDBC Thin driver co-exist on the same Instance.

    Iam getting the following error when I try to use the OCI driver:

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource IntegrationDataStore:IntegrationDataStore_OCI_NoTx_JDBCAdapter.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
    Invalid Oracle URL specified: OracleDataSource.makeURL

    The following are the configuration settings for the adapter:
    Connection Type JDBC Adapter Connection
    Package Name DatabaseConnections
    Connection Properties
    Transaction Type --NO_TRANSACTION
    DataSource Class --oracle.jdbc.pool.OracleDataSource
    serverName ---- dlxksoradb1e.lex.lexmark.com
    user ------ b2blxk
    password -----
    Retype password
    databaseName — wmidden1
    portNumber —1649
    networkProtocol — TCP
    Other Properties ---- drivetTyp=oci

    The Server Configurations settings made in server.sh are :

    CLASSPATH=${CLASSPATH}:/oracle/product/9.2.0.1/jdbc/lib/classes12.jar

    System path
    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/oracle/product/9.2.0.1/lib

    Oracle home
    ORACLE_HOME=/oracle/product/9.2.0.1/

    My OCI driver client is installed properly because I tested it by writing a sample Java Program.

    The cause for the error Iam getting seems to be like its using Thin driver.

    Any help is greatly appreciated.

    thanks
    ucbabu


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