← Back to team overview

dhis2-devs team mailing list archive

Re: Supporting MS Sql Server?

 

2009/8/27 Lars Helge Øverland <larshelge@xxxxxxxxx>

> 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:-)
>

So basically the answer is no, we do not support MSSQL (South Africa is
wondering).

Knut

>
> 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
>>
>>
>


-- 
Cheers,
Knut Staring

Follow ups

References