SQL JDBC Adapter for SQL Server 2005

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

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

TIA.
Prakash

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