<
From version < 21.2 >
edited by Vincent Massol
on 2021/02/17
To version < 22.1
edited by Zaheer Abid
on 2021/02/18
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.VincentMassol
1 +XWiki.ZaheerAbid
Content
... ... @@ -40,9 +40,9 @@
40 40  <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
41 41  <property name="connection.pool_size">2</property>
42 42  <property name="statement_cache.size">2</property>
43 -<mapping resource="xwiki.mssql.hbm.xml"/>
44 -<mapping resource="feeds.hbm.xml"/>
45 -<mapping resource="activitystream.hbm.xml"/>
43 +<mapping resource="xwiki.mssql.hbm.xml"></mapping>
44 +<mapping resource="feeds.hbm.xml"></mapping>
45 +<mapping resource="activitystream.hbm.xml"></mapping>
46 46  {{/code}}
47 47  
48 48  == MS JDBC driver ==
... ... @@ -60,9 +60,9 @@
60 60  <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
61 61  <property name="connection.pool_size">2</property>
62 62  <property name="statement_cache.size">2</property>
63 -<mapping resource="xwiki.mssql.hbm.xml"/>
64 -<mapping resource="feeds.hbm.xml"/>
65 -<mapping resource="activitystream.hbm.xml"/>
63 +<mapping resource="xwiki.mssql.hbm.xml"></mapping>
64 +<mapping resource="feeds.hbm.xml"></mapping>
65 +<mapping resource="activitystream.hbm.xml"></mapping>
66 66  {{/code}}
67 67  
68 68  = Troubleshooting =
... ... @@ -97,6 +97,21 @@
97 97  
98 98  For details see also [[Issue XWIKI-10606>>https://jira.xwiki.org/browse/XWIKI-10606]] on Jira.
99 99  
100 +
101 +== Fix Error Executing DDL with MSSQL Server 2019 ==
102 +
103 +If you see the following error message when deploying XWiki with MSSQL Server 2019 and Tomcat9: -
104 +
105 +{{{org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table xwiki.activitystream_events (ase_eventid varchar(48) not null, ase_requestid varchar(48), ase_stream varchar(255), ase_date datetime, ase_priority int, ase_type varchar(255), ase_application varchar(255), ase_user varchar(255), ase_wiki varchar(255), ase_space varchar(255), ase_page varchar(255), ase_hidden bit, ase_url text, ase_title text, ase_body text, ase_version varchar(30), ase_param1 text, ase_param2 text, ase_param3 text, ase_param4 text, ase_param5 text, primary key (ase_eventid))" via JDBC Statement
106 + }}}
107 +
108 +(% class="wikigeneratedid" %)
109 +This can be fixed by creating the Schema manually in your MSSQL database. Queries generated by Hibernate only create the tables, not Schema, so if you create a Schema manually and assign it to a relevant owner then it will fix the error mentioned above.
110 +
111 +(% class="wikigeneratedid" %)
112 +For details, please visit [[Issue XWiki-18318>>https://jira.xwiki.org/browse/XWIKI-18318]].
113 +
114 +
100 100  == Hints for upgrading to MS SQL 2005 ==
101 101  
102 102  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).

Get Connected