Problem

The customer is developing a flow in Mapping Services to query a MSSQL database.

Connection is successful but simulation seems to never end and cancelling it gives error:

[JDX - 17010]: Connection failed for Channel

(MAPSERVICE.project....:DB Channel).

Driver=(net.sourceforge.jtds.jdbc.Driver),

Url=(jdbc:jtds:sqlserver://hostname:1433;databaseName=dbname),

User=****, Password=****

[MON - 1040]: Unable to open Channel (MAPSERVICE.Bproject...:DB Channel)

Mapbroker execution failed (general failure)

Collecting mapbroker output instances...

Finished: 0 output instance(s) collected.

Resolution

Like in Mapping Services 2.4, the driver needs to be copied over to a java/lib/ext folder.

Copy the file jtds-1.2.5.jar from

C:\Axway\MappingServices\plugins\com.axway.ms.dml.sql.lib_2.5.0.v20140702-1446\lib
to

C:\Axway\MappingServices\plugins\com.axway.dml.mapper.standalone_2.5.0.v20150522-1430\engine\java\lib\ext

Note that with a newer SP comes a new plugins for the target:

com.axway.dml.mapper.standalone_2.5.0.v20160206-0111

always copy in the latest version of com.axway.dml.mapper.standalone