Greetings, Another one of these. A Java stacktrace looking very very much like the one reported Aug 10 2016 by Tom Neumann on the Forum, http://dev.xwiki.org/xwiki/bin/view/Community/Forum
However, his error was at line 233 of hibernate.cfg.xml, whereas mine is at line 244: Caused by: org.xml.sax.SAXParseException; lineNumber: 244; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)". The thing is, the file is only 245 lines long. I don't see the error. I have commented out the hsqldb section at line 90. I have uncommented the MySQL section by moving the closing comment from line 138 to line 124. Can anyone see what I've done wrong? Many thanks- #cat hibernate.cfg.xml <?xml version="1.0" encoding="UTF-8"?> <!-- * See the NOTICE file distributed with this work for additional * information regarding copyright ownership. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. --> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd";> <hibernate-configuration> <session-factory> <!-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) --> <!-- Generic parameters common to all Databases --> <property name="show_sql">false</property> <property name="use_outer_join">true</property> <!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. --> <property name="jdbc.use_scrollable_resultset">false</property> <!-- DBCP Connection Pooling configuration. Only some properties are shown. All available properties can be found at http://commons.apache.org/proper/commons-dbcp/configuration.html --> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxTotal">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWaitMillis">30000</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <!-- Setting "dbcp.poolPreparedStatements" to true and "dbcp.maxOpenPreparedStatements" will tell DBCP to cache Prepared Statements (it's off by default). Note that for backward compatibility the "dbcp.ps.maxActive" is also supported and when set it'll set "dbcp.poolPreparedStatements" to true and "dbcp.maxOpenPreparedStatements" to value of "dbcp.ps.maxActive". Note 1: When using HSQLDB for example, it's important to NOT cache prepared statements because HSQLDB Prepared Statements (PS) contain the schema on which they were initially created and thus when switching schema if the same PS is reused it'll execute on the wrong schema! Since HSQLDB does internally cache prepared statement there's no performance loss by not caching Prepared Statements at the DBCP level. See http://jira.xwiki.org/browse/XWIKI-1740. Thus we recommend not turning on this configuration for HSQLDB unless you know what you're doing :) Note 2: The same applies to PostGreSQL. --> <!-- BoneCP Connection Pooling configuration. <property name="bonecp.idleMaxAgeInMinutes">240</property> <property name="bonecp.idleConnectionTestPeriodInMinutes">60</property> <property name="bonecp.partitionCount">3</property> <property name="bonecp.acquireIncrement">10</property> <property name="bonecp.maxConnectionsPerPartition">60</property> <property name="bonecp.minConnectionsPerPartition">20</property> <property name="bonecp.statementsCacheSize">50</property> <property name="bonecp.releaseHelperThreads">3</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> --> <!-- Configuration for the default database. Comment out this section and uncomment other sections below if you want to use another database. Note that the database tables will be created automatically if they don't already exist. If you want the main wiki database to be different than "xwiki" (or the default schema for schema based engines) you will also have to set the property xwiki.db in xwiki.cfg file --> <!-- Commented out by DKL, 1/3/2017 <property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> <property name="hibernate.connection.charSet">UTF-8</property> <property name="hibernate.connection.useUnicode">true</property> <property name="hibernate.connection.characterEncoding">utf8</property> <property name="connection.url">jdbc:mysql://localhost/xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="hibernate.connection.charSet">UTF-8</property> <property name="hibernate.connection.useUnicode">true</property> <property name="hibernate.connection.characterEncoding">utf8</property> --> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> <!-- MySQL configuration. Uncomment if you want to use MySQL and comment out other database configurations. Notes: - if you want the main wiki database to be different than "xwiki" you will also have to set the property xwiki.db in xwiki.cfg file --> <property name="connection.url">jdbc:mysql://localhost/xwiki?useSSL=false</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.poolPreparedStatements">true</property> <property name="dbcp.maxOpenPreparedStatements">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> <!-- HSQLDB configuration. Uncomment if you want to use HSQLDB and comment out other database configurations. Notes: - if you want the main wiki schema to be different than "PUBLIC" (the default HSQLDB schema) you will also have to set the property xwiki.db in xwiki.cfg file <property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> --> <!-- PostgreSQL configuration. Uncomment if you want to use PostgreSQL and comment out other database configurations. Notes: - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 - "xwiki.virtual_mode" can be set to either "schema" or "database". Note that currently the database mode doesn't support database creation (see http://jira.xwiki.org/browse/XWIKI-8753) - if you want the main wiki database to be different than "xwiki" (or "public" in schema mode) you will also have to set the property xwiki.db in xwiki.cfg file <property name="connection.url">jdbc:postgresql:xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="xwiki.virtual_mode">schema</property> <mapping resource="xwiki.postgresql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> --> <!-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Notes: - the 2 properties named "connection.SetBigStringTryClob" and "jdbc.batch_size" are required to tell Oracle to allow CLOBs larger than 32K. - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 - if you want the main wiki schema to be different than "xwiki" you will also have to set the property xwiki.db in xwiki.cfg file <property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.SetBigStringTryClob">true</property> <property name="jdbc.batch_size">0</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="dbcp.poolPreparedStatements">true</property> <property name="dbcp.maxOpenPreparedStatements">20</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.oracle.hbm.xml"/> --> <!-- Derby configuration. Uncomment if you want to use Derby and comment out other database configurations. Notes: - if you want the main wiki schema to be different than "APP" (the default Derby schema) you will also have to set the property xwiki.db in xwiki.cfg file <property name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> <property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> <property name="dialect">org.hibernate.dialect.DerbyDialect</property> <property name="dbcp.poolPreparedStatements">true</property> <property name="dbcp.maxOpenPreparedStatements">20</property> <mapping resource="xwiki.derby.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> --> <!-- H2 configuration. Uncomment if you want to use H2 and comment out other database configurations. Notes: - if you want the main wiki schema to be different than "PUBLIC" (the default H2 schema) you will also have to set the property xwiki.db in xwiki.cfg file <property name="connection.url">jdbc:h2:${environment.permanentDirectory}/database/xwiki</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.h2.Driver</property> <property name="dialect">org.hibernate.dialect.H2Dialect</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> --> </session-factory> </hibernate-configuration> The information contained in this transmission may contain West Marine proprietary, confidential and/or privileged information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, please send an email to netad...@westmarine.com.
