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
Back to discussions
Expand all | Collapse all

Issue creating "select" jdbc adapter with SYNONYM table type

  • 1.  Issue creating "select" jdbc adapter with SYNONYM table type

    Posted Thu January 28, 2010 10:31 AM

    Hi… I created a jdbc select adapter on a table of type “SYNONYM”. here i am not getting the option of “fill in all columns” in select tab. when i inquired about this I got two solutions.

    1. For table type SYNONYM, use custom SQL only
    2. create the select adapter on the original table, fill in all the columns in ‘select’ tab later point the adapter to the SYNONYM table.

    Advice me if these are the only solutions available? or which is the best practice.

    I am using 6.5 version.


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


  • 2.  RE: Issue creating "select" jdbc adapter with SYNONYM table type

    Posted Fri February 05, 2010 12:36 PM

    Can Anyone pls advice me on the above issue


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


  • 3.  RE: Issue creating "select" jdbc adapter with SYNONYM table type

    Posted Mon March 01, 2010 02:36 PM

    Hi Venky,
    did you find any solution for this ? I am facing similar issue with wMJDBC Adapter V 6.5


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


  • 4.  RE: Issue creating "select" jdbc adapter with SYNONYM table type

    Posted Tue March 02, 2010 07:36 AM

    HI Siva/Venky,
    Please use ojdbc14.jar and ojdbc5.jar instead of Classes12.jar. It should resolve this issue.


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


  • 5.  RE: Issue creating "select" jdbc adapter with SYNONYM table type

    Posted Wed September 28, 2011 06:05 PM

    Ah! It would’ve been nice to see a solution for this. We’re having the same issue. Custom SQL appears to be the only solution so far.

    IS 7.1.2; JDBC Adapter 6.5; ojdbc6.jar


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


Related Content