# Clover 3.1 Server and JTDS

**URL:** https://forum.cloverdx.com/t/clover-3-1-server-and-jtds/912
**Category:** CloverDX Platform
**Created:** [August 11, 2011, 12:00am UTC](https://forum.cloverdx.com/t/clover-3-1-server-and-jtds/912 "2011-08-11T00:00:00Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![dnrickner](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@dnrickner](https://forum.cloverdx.com/u/dnrickner)
#### Post date: [August 11, 2011, 12:00am UTC](https://forum.cloverdx.com/t/clover-3-1-server-and-jtds/912/1 "2011-08-11T00:00:00Z")

</div>

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?

- [config\_files.zip](https://cdn.cloverdx.com/forum/11640%5F598cd0cb75d96e980465d3613a5a3a57/config%5Ffiles.zip)

---

<div class="post-metadata">

### Author: ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)
#### Post date: [August 12, 2011, 10:06am UTC](https://forum.cloverdx.com/t/clover-3-1-server-and-jtds/912/2 "2011-08-12T10:06:16Z")

</div>

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](http://server-demo-ec2.cloveretl.com/clover/docs/config-sources.html)).
