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

JDBC Adapter issue with MSSQL 2008

  • 1.  JDBC Adapter issue with MSSQL 2008

    Posted Mon January 23, 2012 07:23 PM

    Hi,

    We are working on a database migration from Oracle to MS SQL server 2008 and facing a challenging issue here.

    In the new MS SQL 2008 database, the schema name will differ from environment to environment & we have 100+ JDBC adapter services configured via those connections.

    We are using the select, insert and update template in which the table names are not displaying under . but showing under .xyz (where xyz is the schema name which differs across the environment).

    Is there any settings has to be done in webMethods or Database to show the tables under ?

    We tried using Type 4 MS SQL driver and data direct drivers. Both shows the tablenames only under the respective schema.

    Could anyone please help me on this?

    Many Thanks in Advance!!!


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


  • 2.  RE: JDBC Adapter issue with MSSQL 2008

    Posted Tue July 17, 2012 05:18 AM

    You may need to define the default schema at the MS SQL end.


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


Related Content