webMethods

webMethods

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

SQL JDBC Adapter for SQL Server 2005

  • 1.  SQL JDBC Adapter for SQL Server 2005

    Posted Wed February 02, 2011 12:32 AM

    Hi All,

    We’ve wM 8.0 with WmJDBCAdapter 6.5 configured with SQL server 2005 with sqljdbc.jar under the WmJDBCAdapter/code/jars folder.

    We have a stored proc which takes in an XML(as varchar) and returns an XML output.

    Whenever we try to configure it, We’re getting the error -
    com.webMethods.developer.adapter.metadata.AdapterMetadataException: com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.

    I tried restarting the server keeping the jars at IntegrationServer/lib/jars folder, however there wasn’t any difference.

    Kindly suggest a solution for the same.

    Thanks in Advance,
    Prakash


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


  • 2.  RE: SQL JDBC Adapter for SQL Server 2005

    Posted Wed February 02, 2011 12:38 AM

    Please let me know if I can use any settings in the SQL JDBC connections for SQL Server XML data handling .

    TIA.
    Prakash


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


  • 3.  RE: SQL JDBC Adapter for SQL Server 2005

    Posted Wed February 16, 2011 06:38 AM

    Any further details in the error log that could help further?


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


Related Content