[xwiki-devs] [Solution] xWiki 1.5 on MSSQL 2000 & 2005
Hi I'm just managed to install xWiki 1.5 against Microsoft SQL Server 2005 It wasn't trivial so i have few things to say: 1) hbm.xml file (Hibernate mapping) file which is as a download on http://n2.nabble.com/file/n841396/xwiki.mssql_1.5.hbm.xml xwiki.mssql_1.5.hbm.xml http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL is outdated. It works only for xWiki 1.4 and required some modifications (based on http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... ) to work with 1.5 I'm attaching mapping to my post. 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 HTH -- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p8413... Sent from the XWiki- Dev mailing list archive at Nabble.com.
I forget to mention one thing. Before updating mssql mapping for 1.5 i was getting same error as described http://xwiki.markmail.org/message/y4ft577j7sd4xshp?q=xwiki%2Emssql%2Ehbm%2Ex... here on user list So I think updated mapping solves the issue http://jira.xwiki.org/jira/browse/XWIKI-2623 http://jira.xwiki.org/jira/browse/XWIKI-2623 Bye Liwoj wrote:
Hi
I'm just managed to install xWiki 1.5 against Microsoft SQL Server 2005 It wasn't trivial so i have few things to say:
1) hbm.xml file (Hibernate mapping) file which is as a download on http://n2.nabble.com/file/n841396/xwiki.mssql_1.5.hbm.xml xwiki.mssql_1.5.hbm.xml http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL is outdated. It works only for xWiki 1.4 and required some modifications (based on http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... ) to work with 1.5 I'm attaching mapping to my post.
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
HTH
-- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p8414... Sent from the XWiki- Dev mailing list archive at Nabble.com.
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:
I forget to mention one thing. Before updating mssql mapping for 1.5 i was getting same error as described http://xwiki.markmail.org/message/y4ft577j7sd4xshp?q=xwiki%2Emssql%2Ehbm%2Ex... here on user list So I think updated mapping solves the issue http://jira.xwiki.org/jira/browse/XWIKI-2623 http://jira.xwiki.org/jira/browse/XWIKI-2623
Bye
Liwoj wrote:
Hi
I'm just managed to install xWiki 1.5 against Microsoft SQL Server 2005 It wasn't trivial so i have few things to say:
1) hbm.xml file (Hibernate mapping) file which is as a download on http://n2.nabble.com/file/n841396/xwiki.mssql_1.5.hbm.xml xwiki.mssql_1.5.hbm.xml http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL is outdated. It works only for xWiki 1.4 and required some modifications (based on http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... ) to work with 1.5 I'm attaching mapping to my post.
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
HTH
-- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p8414... Sent from the XWiki- Dev mailing list archive at Nabble.com.
On Fri, Sep 5, 2008 at 5:23 PM, Liwoj <[email protected]> wrote:
Hi
I'm just managed to install xWiki 1.5 against Microsoft SQL Server 2005 It wasn't trivial so i have few things to say:
1) hbm.xml file (Hibernate mapping) file which is as a download on http://n2.nabble.com/file/n841396/xwiki.mssql_1.5.hbm.xml xwiki.mssql_1.5.hbm.xml http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL is outdated. It works only for xWiki 1.4 and required some modifications (based on http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... ) to work with 1.5 I'm attaching mapping to my post.
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.
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 <[email protected]> wrote:
Hi
I'm just managed to install xWiki 1.5 against Microsoft SQL Server 2005 It wasn't trivial so i have few things to say:
1) hbm.xml file (Hibernate mapping) file which is as a download on http://n2.nabble.com/file/n841396/xwiki.mssql_1.5.hbm.xml xwiki.mssql_1.5.hbm.xml http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL is outdated. It works only for xWiki 1.4 and required some modifications (based on http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... ) to work with 1.5 I'm attaching mapping to my post.
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 [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p8415... Sent from the XWiki- Dev mailing list archive at Nabble.com.
On Fri, Sep 5, 2008 at 6:16 PM, Liwoj <[email protected]> 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.
participants (2)
-
Jean-Vincent Drean -
Liwoj