dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

2010/5/4 Knut Staring <knutst@xxxxxxxxx>:
> 2010/5/4 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>>
>>
>> On Tue, May 4, 2010 at 10:47 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>
>>> 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:

http://www.amplecode.org/browser/quick/trunk/src/main/java/org/amplecode/quick/StatementDialect.java

Knut
>
>> Lars
>>
>>
>>>
>>> Thanks,
>>> Knut
>>>
>>> On Thu, Aug 27, 2009 at 2:55 PM, Saptarshi Purkayastha <sunbiz@xxxxxxxxx>
>>> 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@xxxxxxxxx>
>>> >>
>>> >> On Thu, Aug 27, 2009 at 1:55 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
>>> >> wrote:
>>> >>>
>>> >>> 2009/8/27 Ola Hodne Titlestad <olatitle@xxxxxxxxx>
>>> >>>
>>> >>> 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@xxxxxxxxxxxxxxxxxxx
>>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> >> More help   : https://help.launchpad.net/ListHelp
>>> >>
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Cheers,
>>> Knut Staring
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
>
> --
> Cheers,
> Knut Staring
>



-- 
Cheers,
Knut Staring