← Back to team overview

dhis2-devs team mailing list archive

Re: Supporting MS Sql Server?

 

There is a lot direct JDBC operations going on which requires us to
implement a dialect for MSSQL, currently not there. Have a look in
dhis-service-jdbc and give it a go:-)

Lars


On Thu, Aug 27, 2009 at 1:08 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References