[xwiki-devs] [Solution] xWiki 1.5 on MSSQL 2000 & 2005

And things are getting better ! I've modified the mapping to explicitly use new sql server 2005 data type "varchar(max)" (instead of implicit use of "text" data type) Result is that normal xWiki case insensitive search (using sql) works without error (only on 2005) Better solution would be to use (if exists) Hibernate dialect for SQL Server 2005 and do not modify mapping at all, but this is better than nothing. Here are both mappings: http://n2.nabble.com/file/n841498/xwiki.mssql2000_1.5.hbm.xml xwiki.mssql2000_1.5.hbm.xml http://n2.nabble.com/file/n841498/xwiki.mssql2005_1.5.hbm.xml xwiki.mssql2005_1.5.hbm.xml CY Liwoj wrote:

...

-- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p841… Sent from the XWiki- Dev mailing list archive at Nabble.com.

Jean-Vincent Drean

6:04 p.m.

New subject: [xwiki-devs] [Solution] xWiki 1.5 on MSSQL 2000 & 2005

On Fri, Sep 5, 2008 at 5:23 PM, Liwoj <michal.levy(a)mediaresearch.cz> wrote:

...

I've updated http://jira.xwiki.org/jira/browse/XWIKI-2623 The file you've provided has been commited and will be shipped with XE 1.5.1 and XE 1.6M2. Thanks!

...

2) First note on MSSQL Installation guide mentioned before is not correct. Text types wasn't depreciated in MSSQL 2005, only marked as obsoleted. So attached mapping works ok on both MSSQL 2000&2005

I've updated : http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL Does it look ok now ? Thanks, JV.

Liwoj

6:16 p.m.

New subject: [xwiki-devs] [Solution] xWiki 1.5 on MSSQL 2000 & 2005

Looks better....but.... :) 1) "This has been on MSSQL" should be "This has been tested on MSSQL", right? 2) Typo in the filename xwiki.mssql.hbm.sql --> xwiki.mssql.hbm.xml 3) "When using a downloaded .war" is missing text. Suggestion: "Place xwiki.mssql.hbm.sql to the WEB-INF\classes directory of our xWiki installation." 4) "Install the JDBC driver" section 1.2.1 version of the driver is now tested with xWiki 1.5 :) Bye Jean-Vincent Drean wrote:

...

On Fri, Sep 5, 2008 at 5:23 PM, Liwoj <michal.levy(a)mediaresearch.cz> wrote:

I've updated http://jira.xwiki.org/jira/browse/XWIKI-2623 The file you've provided has been commited and will be shipped with XE 1.5.1 and XE 1.6M2. Thanks!

2) First note on MSSQL Installation guide mentioned before is not correct. Text types wasn't depreciated in MSSQL 2005, only marked as obsoleted. So attached mapping works ok on both MSSQL 2000&2005

I've updated : http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL Does it look ok now ? Thanks, JV. _______________________________________________ devs mailing list devs(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/devs

-- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p841… Sent from the XWiki- Dev mailing list archive at Nabble.com.

Jean-Vincent Drean

6:31 p.m.

New subject: [xwiki-devs] [Solution] xWiki 1.5 on MSSQL 2000 & 2005

On Fri, Sep 5, 2008 at 6:16 PM, Liwoj <michal.levy(a)mediaresearch.cz> wrote:

...

1) "This has been on MSSQL" should be "This has been tested on MSSQL", right?

...

2) Typo in the filename xwiki.mssql.hbm.sql --> xwiki.mssql.hbm.xml 3) "When using a downloaded .war" is missing text.

I've removed the whole section since xwiki.mssql.hbm.xml is now shipped with XWiki.

...

4) "Install the JDBC driver" section 1.2.1 version of the driver is now tested with xWiki 1.5 :)

Modified. I've seen your 3rd email a bit too late, would you mind attaching the new mssql mapping files to : http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL and add a section about the benefits of xwiki.mssql2005.hbm.xml ? You can register from http://www.xwiki.org/xwiki/bin/view/Main/ If you think that shipping the 2 mapping files with XWiki is important, feel free to create a JIRA issue : http://jira.xwiki.org/ Thanks, JV.

5909

days inactive

5909

days old

xwiki-devs@xwiki.org

Manage subscription

5 comments

2 participants

tags (0)

participants (2)

Jean-Vincent Drean
Liwoj