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?
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?
-
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).
Please sign in to leave a comment.
Comments 1