← Back to team overview

dhis2-devs team mailing list archive

Supporting MS Sql Server?

 

I think DHIS 2 should be able to run on Microsoft's SQL Server, since it is
supported by Hibernate:https://www.hibernate.org/80.html

<https://www.hibernate.org/80.html>However, I need some help to make it
work.

To get a driver, I first placed jtds-1.2.2.jar in tomcat/lib and then added
these lines in hibernate.properties:
hibernate.dialect = org.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class = net.sourceforge.jtds.jdbc.Driver
hibernate.connection.url = jdbc:jtds:sqlserver://localhost/test

But when starting Tomcat, I get the following:
Caused by: java.lang.RuntimeException: Unsupported dialect:
org.hibernate.dialect.SQLServerDialect

-- 
Cheers,
Knut Staring

Follow ups