Clover 3.1 Server and JTDS

CloverDX Platform
1

We are trying to upgrade our Clover Server from 3.0.1 to 3.1.0 and are experiencing problems with the JTDS driver. The error message is:

Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver

I have edited the WEB-INF/config.properties to use MSSQL configuration like this:

jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://myserver:1433;databaseName=clover
jdbc.dialect=org.hibernate.dialect.SybaseDialect
jdbc.username=clover
jdbc.password=####

I see that JTDS is defined in the plugins/org.jetel.jdbc/plugins.xml file and the jar file exists where it should. What am I missing?

2

Hello,
to make CloverETL Server working on different than default derby database you need to copy the driver to the application server class-path directory, eg. on Tomcat you need to copy it to <tomcat_home_directory>/lib.
By the way you shouldn’t modify clover files, you should rather create cloverServer.properties file with the configuration (see Config Sources and Their Priorities).