← Back to team overview

dhis2-devs team mailing list archive

Re: Supporting MS Sql Server?

 

Hi,

It shouldn't require that much work though.
Lars?

I remember we added support for H2 some months back, and it didn't take that
much time, at least that was my impression.

Ola
-----------

2009/8/27 Knut Staring <knutst@xxxxxxxxx>

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