KB Article #65637
"No suitable driver" error when using a remote database
-- getting the error when building the project :
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:65)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
at com.axway.integrator.databaseaccess.SqlChannel.connect(SqlChannel.java:122)
at com.axway.integrator.databaseaccess.ConnectionManager.getConnection(ConnectionManager.java:115)
[MON - 1040]: Unable to open Channel (Company.folder.JDBC)
[JDX - 17010]: Connection failed for Channel (Company.folder.JDBC). Driver=(net.sourceforge.jtds.jdbc.Driver), Url=(jdbc:jtds:sqlserver:/172.21.179.252:1108;DatabaseName=NDG;domain=SQLEXPRESS), User=****, Password=****
Note : SQL Server database connection has been configured correctly in Windows -> Préférences
Resolution
* put the jar file jtds-1.2.2.jar in Synchrony\Mapping_Services\Map_Designer\mappingengine\java\lib\ext
(take the latest version available on internet. you can also use jtds-1.2.2.jar that can be copied from <Synchrony folder>\Mapping_Services\Map_Designer\plugins\com.axway.md.lib_2.3.0.201006181915\lib)