Supporting MS Sql Server?

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:

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

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:

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

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

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

···

2009/8/27 Lars Helge Øverland larshelge@gmail.com

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:

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

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Cheers,
Knut Staring

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@gmail.com

2009/8/27 Lars Helge Øverland larshelge@gmail.com

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:

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

Post to : dhis2-devs@lists.launchpad.net

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

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.

As I recall 95% of it is really quick. Then we struggle with the details of the 5% of dialect incompatibility.

I think H2 was always pretty much there as it was used “internally”. What we tried to get up and running unsuccessfully was the derby database.

How important is MS SQL? I’d personally rather discourage people from using it at all …

Cheers
Bob

···

2009/8/27 Ola Hodne Titlestad olatitle@gmail.com

Ola

2009/8/27 Knut Staring knutst@gmail.com

2009/8/27 Lars Helge Øverland larshelge@gmail.com

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:

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

Post to : dhis2-devs@lists.launchpad.net

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


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

It seems to be crucial if we want to see DHIS 2 used in South Africa, as it is their standard platform.

Knut

···

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 …

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?

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

--
Cheers,
Knut Staring

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.


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

Cheers,

Knut Staring


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?

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

--
Cheers,
Knut Staring

_______________________________________________
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

--
Cheers,
Knut Staring

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

···

2010/5/4 Knut Staring <knutst@gmail.com>:

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

--
Cheers,
Knut Staring

_______________________________________________
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

--
Cheers,
Knut Staring

--
Cheers,
Knut Staring