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@gmail.com 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
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:
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).
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@gmail.com 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
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:
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@gmail.com 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
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:
The question of MSSQL support has come up again - it seems important
for many potential users. Does anyone have time to look into it?
Thanks,
Knut
···
On Thu, Aug 27, 2009 at 2:55 PM, Saptarshi Purkayastha <sunbiz@gmail.com> wrote:
I would really encourage people to use the other databases: DB2, Terradata,
Oracle and MSSQL's databases to be the biggest ones.
...and in principal we should do everything possible to encourage people to
use databases of their choice, since we are a data warehouse.
---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme
The question of MSSQL support has come up again - it seems important
for many potential users. Does anyone have time to look into it?
All explicit SQL statements in the system are centralized in dhis-support-jdbc → StatementBuilder interface. Its a matter of providing a new implementation (MsSqlStatementBuilder). Why don’t you give it a try?
Lars
···
On Tue, May 4, 2010 at 10:47 AM, Knut Staring knutst@gmail.com wrote:
Thanks,
Knut
On Thu, Aug 27, 2009 at 2:55 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:
I would really encourage people to use the other databases: DB2, Terradata,
Oracle and MSSQL’s databases to be the biggest ones.
…and in principal we should do everything possible to encourage people to
use databases of their choice, since we are a data warehouse.
The question of MSSQL support has come up again - it seems important
for many potential users. Does anyone have time to look into it?
All explicit SQL statements in the system are centralized in
dhis-support-jdbc -> StatementBuilder interface. Its a matter of providing a
new implementation (MsSqlStatementBuilder). Why don't you give it a try?
It seems a little more involved:
I suppose we need to have StatementDialect.MSSQL in import
org.amplecode.quick.StatementDialect
Can you help with that?
Knut
···
2010/5/4 Lars Helge Øverland <larshelge@gmail.com>:
On Tue, May 4, 2010 at 10:47 AM, Knut Staring <knutst@gmail.com> wrote:
Lars
Thanks,
Knut
On Thu, Aug 27, 2009 at 2:55 PM, Saptarshi Purkayastha <sunbiz@gmail.com> >> wrote:
> I would really encourage people to use the other databases: DB2,
> Terradata,
> Oracle and MSSQL's databases to be the biggest ones.
> ...and in principal we should do everything possible to encourage people
> to
> use databases of their choice, since we are a data warehouse.
> ---
> Regards,
> Saptarshi PURKAYASTHA
> Director R & D, HISP India
> Health Information Systems Programme
>
> My Tech Blog: http://sunnytalkstech.blogspot.com
> You Live by CHOICE, Not by CHANCE
>
>
> 2009/8/27 Knut Staring <knutst@gmail.com>
>>
>> On Thu, Aug 27, 2009 at 1:55 PM, Bob Jolliffe <bobjolliffe@gmail.com> >> >> wrote:
>>>
>>> 2009/8/27 Ola Hodne Titlestad <olatitle@gmail.com>
>>>
>>> How important is MS SQL? I'd personally rather discourage people from
>>> using it at all ...
>>
>> It seems to be crucial if we want to see DHIS 2 used in South Africa,
>> as
>> it is their standard platform.
>> Knut
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
The question of MSSQL support has come up again - it seems important
for many potential users. Does anyone have time to look into it?
All explicit SQL statements in the system are centralized in
dhis-support-jdbc -> StatementBuilder interface. Its a matter of providing a
new implementation (MsSqlStatementBuilder). Why don't you give it a try?
It seems a little more involved:
I suppose we need to have StatementDialect.MSSQL in import
org.amplecode.quick.StatementDialect
Can you help with that?
Or tell me how to contribute to amplecode. Here is the file:
2010/5/4 Lars Helge Øverland <larshelge@gmail.com>:
On Tue, May 4, 2010 at 10:47 AM, Knut Staring <knutst@gmail.com> wrote:
Lars
Thanks,
Knut
On Thu, Aug 27, 2009 at 2:55 PM, Saptarshi Purkayastha <sunbiz@gmail.com> >>> wrote:
> I would really encourage people to use the other databases: DB2,
> Terradata,
> Oracle and MSSQL's databases to be the biggest ones.
> ...and in principal we should do everything possible to encourage people
> to
> use databases of their choice, since we are a data warehouse.
> ---
> Regards,
> Saptarshi PURKAYASTHA
> Director R & D, HISP India
> Health Information Systems Programme
>
> My Tech Blog: http://sunnytalkstech.blogspot.com
> You Live by CHOICE, Not by CHANCE
>
>
> 2009/8/27 Knut Staring <knutst@gmail.com>
>>
>> On Thu, Aug 27, 2009 at 1:55 PM, Bob Jolliffe <bobjolliffe@gmail.com> >>> >> wrote:
>>>
>>> 2009/8/27 Ola Hodne Titlestad <olatitle@gmail.com>
>>>
>>> How important is MS SQL? I'd personally rather discourage people from
>>> using it at all ...
>>
>> It seems to be crucial if we want to see DHIS 2 used in South Africa,
>> as
>> it is their standard platform.
>> Knut
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>
>