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.  Adapter Connection to Oracle RDB

    Posted Thu September 30, 2010 10:15 PM

    Hello All
    we are trying to Connect to one of out Legacy Systems Oracle RDB , downloaded ,thin Driver for the same for Oracle Download, when trying to Create A Adapter Connection returning an error “data source class cannot be found” if some one can help or faced Similar Issue?, or if Some knows the Data Source class that should be used ?
    Thanks in Advance


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


  • 2.  RE: Adapter Connection to Oracle RDB

    Posted Mon October 04, 2010 07:22 PM

    Siddu,

    I strongly suspect that SAG JDBC Adapter is not supported (6.5 version of JDBC) to integrate with Oracle RDB, you might want to check with SAG support on that.

    What is the driver name that you are using to connect to the database?

    If it is not supported but you still want to connect to the DB (for a POC) then i would suggest write a Java program to make a connection to the Database.

    I believe there are code snippets that are available on the internet for this purpose.

    [url]http://www.rgagnon.com/javadetails/java-0112.html[/url]

    Cheers,
    Akshith


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


  • 3.  RE: Adapter Connection to Oracle RDB

    Posted Mon October 04, 2010 08:06 PM

    the Driver we are using is Rdbthin Driver and used the Data Source Class is as Suggested " oracle.rdb.jdbc.rdb.Thin.Driver"
    please Suggest can we use Adapter rather use custom Code
    Thanks in advance


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


  • 4.  RE: Adapter Connection to Oracle RDB

    Posted Mon October 04, 2010 09:19 PM

    Put the jar file in the path indicated by the JDBC adapter guide. The class in question needs to be on the JVM classpath to be found.


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