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.  Oracle 10G RAC JDBC Pool URL/String

    Posted Thu March 06, 2008 01:07 AM

    Hi guys ,
    I am kind of desperately looking around for some JDBC URL String for Oracle 10G RAC to be used in JDBC Pools ( Not the JDBC Adapter) . And we are not using OCI.
    I searched around and i could not find anything that works for us.
    I have DataDirect Connect for JDBC Release 3.6 Build 0007(SL53_CJ36.Jar)
    If you guys could send me a JDBC String that works in your JDBC Pools for a clustered/Failover enabled/Load-balanced environment ,
    i would be monumentally indebted to you for the favor.
    Thanks in advance.
    Sincerely,
    -Scoobydoo


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


  • 2.  RE: Oracle 10G RAC JDBC Pool URL/String

    Posted Mon December 15, 2008 09:42 PM

    Hi - Were you able to figure out how to construct this connection string?


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


  • 3.  RE: Oracle 10G RAC JDBC Pool URL/String

    Posted Tue December 16, 2008 04:42 AM

    Figured it out. Here’s the general structure of the Database URL:

    url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1234))(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1234)))(CONNECT_DATA=(SERVICE_NAME=myDbService)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))(DELAY=10)(RETRIES=5)))


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


Related Content