Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
-
Objects (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. ChristianF1 +XWiki.jhaimerl - Content
-
... ... @@ -14,8 +14,7 @@ 14 14 15 15 = Install the JDBC driver = 16 16 17 -* Download the [[jtds jdbc driver>>http://sourceforge.net/projects/jtds/]] and install the jar file into your server's lib directory (for JBoss this could be ##server\default\lib\##, for Tomcat this might be ##common\lib\##) 18 -((( 17 +* Download the [[jtds jdbc driver>>http://sourceforge.net/projects/jtds/]] and install the jar file into your server's lib directory (for JBoss this could be ##server\default\lib\##, for Tomcat this might be ##common\lib\##)((( 19 19 {{info}} 20 20 The connection was successfully tested with version 1.2.1 of the driver and version 1.5 of XWiki. Some problems occurred when using drivers > 1.2.1 so it might be better to use the old one. 21 21 {{/info}} ... ... @@ -70,6 +70,28 @@ 70 70 71 71 Alternatively, you may want to use the [[Lucene search application>>extensions:Extension.Search Application]] instead of the default search. 72 72 72 + 73 +== Fix filter in Livetable Macro == 74 + 75 +The filter function in the [[Livetable Macro>>http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro]] is not working on MSSQL. The macro function livetable_addColumnToQuery (defined in XWiki.LiveTableResultsMacros) uses in an HQL Statement the function str (Line 576) with an string parameter. This function call is not correctly mapped to the SQL statement. 76 +A solution to fix the problem is to implement an extension of the SQLServerDialect class to be able to overwrite the registration of the STR function through the following one: 77 + 78 +{{code language="java"}} 79 +public class IWikiSQLServerDialect extends SQLServerDialect 80 +{ 81 + /** 82 + * constructor 83 + */ 84 + public WikiSQLServerDialect() 85 + { 86 + super(); 87 + registerFunction("str", new SQLFunctionTemplate(StandardBasicTypes.STRING, "cast(?1 as varchar)")); 88 + } 89 +} 90 +{{/code}} 91 + 92 +For details see also [[Issue XWIKI-10606>>http://jira.xwiki.org/browse/XWIKI-10606]] on Jira. 93 + 73 73 == Hints for upgrading to MS SQL 2005 == 74 74 75 75 In MS SQL 2005 the standard schema in all databases is dbo by default. However, if you upgrade your server with the standard Microsoft software, all tables in your xwiki database will be configured to use a schema whichs name is equivalent to the database name. (If your database name is "xwiki", the schema name will also be "xwiki" and the full qualified tablenames will be "xwiki.xwikidoc", and so on).
- XWiki.XWikiComments[9]
-
- Comment
-
... ... @@ -1,3 +1,3 @@ 1 -If you are trying to install on 2008, Inice workaround is to set compatibility level of your database to 2005:1 +If you are trying to install on 2008, a nice workaround is to set compatibility level of your database to 2005: 2 2 3 3 ALTER DATABASE xwiki SET COMPATIBILITY_LEVEL = 90 - Date
-
... ... @@ -1,1 +1,1 @@ 1 -2013-10-01 16:17:26. 4131 +2013-10-01 16:17:26.0