JForum 2.1.7 Beta: SqlServer-Support-Fixes

[Migrated From Jforum.net]

I am just testing the 2.1.7Beta against a SqlServer2005-DBMS and found (by now) the following problems:

the new dbtable-columns
jforum_users.user_notify_always
and jforum_users.user_notify_text
were missing in the sqlserver-config-files
sqlserver.sql
and sqlserver_db_struct.sql

Maybe the attached files could be integrated in the cvs-repository ...




[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

Thank you very much. The files are in the cvs now.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Thanks Rafael,

but meanwhile i recognized the main problem with JForum and MS-SqlServer:

it's the ResultSet-Paging (via OFFSET, LIMIT) .........

By now all "paged"-selects do threw an exception !

I cannot understand, why the other users of jforum+sqlserver do not have this problem !?

I will try to change the sqlserver.sql to support resultset-paging .......



[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

To support the paging of SqlServer-resultsets I changed all "select*ByLimit"-statements in sqlserver.sql. According to these changes i had to modify some SqlServer DAO classes as well.
CAUTION: This implementation (SqlServer DAO classes and sqlserver.sql) is SqlServer2005 specific (because of ROW_NUMBER()) !!

The files i changed:

WEB-INF\config\database\sqlserver\sqlserver.sql
src\net\jforum\dao\sqlserver\SqlServerTopicDAO.java
src\net\jforum\dao\sqlserver\SqlServerUserDAO.java
src\net\jforum\dao\sqlserver\SqlServerPostDAO.java


[originally posted on jforum.net by xplane]

[Migrated From Jforum.net]

Thank you very much.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

how about sql server2000

how to fix
[originally posted on jforum.net by kiemhao]