[xwiki-users] Another Error number 11007 in 0: Failed to extract Entity blah blah from [http://localhost:8080/xwiki/bin/view/Main]
6 Jan
2017
6 Jan
'17
8:49 p.m.
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
netadmin(a)westmarine.com.
6 Jan
6 Jan
9:01 p.m.
Hi Douglas,
On 6 Jan 2017, at 20:49, Douglas Landau
<DouglasL(a)westmarine.com> wrote:
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*)”.
This means that you’ve modified hibernate.cfg.xml but you’re added elements at the wrong
place in the XML, not following the DTD at
http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd.
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”?
[snip]
<!-- 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”/>
I think that'd the error is here and those mappings need to be commented out too since
they’re defined in the mysql section but you made them be out of order and come before
properties…
"(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)”.
Means that property elements must come before mapping elements in the XML file...
Thanks
-Vincent
PS: Note that this is not specifically related to XWiki but more to Hibernate.
<!-- 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>
10 p.m.
This means that you’ve modified hibernate.cfg.xml but
you’re added elements at the wrong place in the XML, not following the DTD at
http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd.
...
I think that'd the error is here and those mappings
need to be commented out too since they’re defined in the mysql section but you made them
be out of order and come before properties…
Thanks, Vincent!! I commented out the mappings and am no longer getting the error at line
244.
I don't see a specific line number in hibernate.cfg.xml this time. I see this at line
80: (of catalina.err):
Caused by: org.hibernate.HibernateException: Could not create a DBCP pool. There is an
error in the Hibernate configuration file, please review it.
...and I see this at line 92:
Caused by: java.sql.SQLException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
It looks like I did copy the MySQL-connector jar to tomcat/webapps/xwiki/WEB_INF.
I don't know what to make of either msg, and am going back to the archives looking for
those. I guess even before those I don't know what to make of this:
org.xwiki.query.QueryException: Exception while executing query. Query statement = [
select doc.fullName from XWikiDocument as doc , BaseObject as panel WHERE 1=1 and
doc.fullName=panel.name and panel.className='Panels.PanelClass' ]
----------------------------------
[root@dwiki01 ~]# cd /opt
[root@dwiki01 opt]# find . | grep mysql-connector-java-5.1.40-bin.jar
./apache-tomcat-9.0.0.M15/webapps/xwiki/WEB-INF/mysql-connector-java-5.1.40-bin.jar
[root@dwiki01 opt]# cat catalina.err
06-Jan-2017 12:33:01.915 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Server version: Apache Tomcat/9.0.0.M15
06-Jan-2017 12:33:01.916 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Server built: Dec 5 2016 13:44:25 UTC
06-Jan-2017 12:33:01.916 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Server number: 9.0.0.0
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
OS Name: Linux
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
OS Version: 3.10.0-327.36.3.el7.x86_64
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Architecture: amd64
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Java Home: /usr/java/jdk1.8.0_25/jre
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
JVM Version: 1.8.0_25-b17
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
JVM Vendor: Oracle Corporation
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
CATALINA_BASE: /opt/apache-tomcat-9.0.0.M15
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
CATALINA_HOME: /opt/apache-tomcat-9.0.0.M15
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: -Dcatalina.home=/opt/apache-tomcat-9.0.0.M15
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: -Dcatalina.base=/opt/apache-tomcat-9.0.0.M15
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
06-Jan-2017 12:33:01.917 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument:
-Djava.util.logging.config.file=/opt/apache-tomcat-9.0.0.M15/conf/logging.properties
06-Jan-2017 12:33:01.918 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: -Dcommons.daemon.process.id=3733
06-Jan-2017 12:33:01.918 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: -Dcommons.daemon.process.parent=3732
06-Jan-2017 12:33:01.918 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: -Dcommons.daemon.version=1.0.15-dev
06-Jan-2017 12:33:01.918 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log
Command line argument: abort
06-Jan-2017 12:33:01.918 INFO [main]
org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat
Native library which allows optimal performance in production environments was not found
on the java.library.path:
/usr/java/jdk1.8.0_25/jre/lib/amd64/server:/usr/java/jdk1.8.0_25/jre/lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
06-Jan-2017 12:33:02.163 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing
ProtocolHandler ["http-nio-8080"]
06-Jan-2017 12:33:02.194 INFO [main]
org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for
servlet write/read
06-Jan-2017 12:33:02.235 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing
ProtocolHandler ["ajp-nio-8009"]
06-Jan-2017 12:33:02.236 INFO [main]
org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for
servlet write/read
06-Jan-2017 12:33:02.249 INFO [main] org.apache.catalina.startup.Catalina.load
Initialization processed in 991 ms
06-Jan-2017 12:33:02.282 INFO [main]
org.apache.catalina.core.StandardService.startInternal Starting service Catalina
06-Jan-2017 12:33:02.283 INFO [main] org.apache.catalina.core.StandardEngine.startInternal
Starting Servlet Engine: Apache Tomcat/9.0.0.M15
06-Jan-2017 12:33:02.332 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory
/opt/apache-tomcat-9.0.0.M15/webapps/ROOT
06-Jan-2017 12:33:30.650 INFO [localhost-startStop-1]
org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of
SecureRandom instance for session ID generation using [SHA1PRNG] took [27,850]
milliseconds.
06-Jan-2017 12:33:30.672 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application
directory /opt/apache-tomcat-9.0.0.M15/webapps/ROOT has finished in 28,339 ms
06-Jan-2017 12:33:30.672 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory
/opt/apache-tomcat-9.0.0.M15/webapps/docs
06-Jan-2017 12:33:30.726 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application
directory /opt/apache-tomcat-9.0.0.M15/webapps/docs has finished in 53 ms
06-Jan-2017 12:33:30.726 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory
/opt/apache-tomcat-9.0.0.M15/webapps/examples
06-Jan-2017 12:33:31.150 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application
directory /opt/apache-tomcat-9.0.0.M15/webapps/examples has finished in 424 ms
06-Jan-2017 12:33:31.150 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory
/opt/apache-tomcat-9.0.0.M15/webapps/host-manager
06-Jan-2017 12:33:31.184 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application
directory /opt/apache-tomcat-9.0.0.M15/webapps/host-manager has finished in 34 ms
06-Jan-2017 12:33:31.184 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory
/opt/apache-tomcat-9.0.0.M15/webapps/manager
06-Jan-2017 12:33:31.225 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application
directory /opt/apache-tomcat-9.0.0.M15/webapps/manager has finished in 41 ms
06-Jan-2017 12:33:31.225 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory
/opt/apache-tomcat-9.0.0.M15/webapps/xwiki
06-Jan-2017 12:33:52.799 INFO [localhost-startStop-1]
org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet
contained no TLDs. Enable debug logging for this logger for a complete list of JARs that
were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can
improve startup time and JSP compilation time.
06-Jan-2017 12:34:09.798 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application
directory /opt/apache-tomcat-9.0.0.M15/webapps/xwiki has finished in 38,572 ms
06-Jan-2017 12:34:09.801 INFO [main] org.apache.coyote.AbstractProtocol.start Starting
ProtocolHandler [http-nio-8080]
06-Jan-2017 12:34:09.819 INFO [main] org.apache.coyote.AbstractProtocol.start Starting
ProtocolHandler [ajp-nio-8009]
06-Jan-2017 12:34:09.819 INFO [main] org.apache.catalina.startup.Catalina.start Server
startup in 67570 ms
java.lang.ArrayIndexOutOfBoundsException: 0
at
com.xpn.xwiki.plugin.mailsender.MailSenderPlugin.initMailClass(MailSenderPlugin.java:226)
at
com.xpn.xwiki.plugin.mailsender.MailSenderPlugin.init(MailSenderPlugin.java:142)
at
com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:154)
at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:90)
at
com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:118)
at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1457)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1193)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1103)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:1076)
at
com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:189)
at java.lang.Thread.run(Thread.java:745)
org.xwiki.query.QueryException: Exception while executing query. Query statement = [
select doc.fullName from XWikiDocument as doc , BaseObject as panel WHERE 1=1 and
doc.fullName=panel.name and panel.className='Panels.PanelClass' ]
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:184)
at
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
at
org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:124)
at
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
at
org.xwiki.panels.internal.PanelWikiUIExtensionComponentBuilder.getDocumentReferences(PanelWikiUIExtensionComponentBuilder.java:98)
at
org.xwiki.component.wiki.internal.DefaultWikiComponentManagerEventListener.registerAllComponents(DefaultWikiComponentManagerEventListener.java:133)
at
org.xwiki.component.wiki.internal.DefaultWikiComponentManagerEventListener.onEvent(DefaultWikiComponentManagerEventListener.java:122)
at
org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:304)
at
org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:269)
at
com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:129)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:189)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1333)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1394)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:165)
... 14 more
Caused by: org.hibernate.HibernateException: Could not create a DBCP pool. There is an
error in the Hibernate configuration file, please review it.
at
com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:232)
at
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
at
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84)
at
org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1325)
... 16 more
Caused by: java.sql.SQLException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2139)
at
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033)
at
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
at
com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215)
... 26 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.xwiki.classloader.URIClassLoader$1.run(URIClassLoader.java:193)
at org.xwiki.classloader.URIClassLoader$1.run(URIClassLoader.java:180)
at java.security.AccessController.doPrivileged(Native Method)
at org.xwiki.classloader.URIClassLoader.findClass(URIClassLoader.java:179)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at
org.xwiki.classloader.xwiki.internal.ContextNamespaceURLClassLoader.loadClass(ContextNamespaceURLClassLoader.java:176)
at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2131)
... 29 more
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
netadmin(a)westmarine.com.
10:02 p.m.
On 6 Jan 2017, at 22:00, Douglas Landau
<DouglasL(a)westmarine.com> wrote:
It’s WEB-INF/lib. Could you check that?
Thanks
-Vincent
This means that you’ve modified hibernate.cfg.xml
but you’re added elements at the wrong place in the XML, not following the DTD at
http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd.
...
I think that'd the error is here and those
mappings need to be commented out too since they’re defined in the mysql section but you
made them be out of order and come before properties…
Thanks, Vincent!! I commented out the mappings and am no longer getting the error at
line 244.
I don't see a specific line number in hibernate.cfg.xml this time. I see this at
line 80: (of catalina.err):
Caused by: org.hibernate.HibernateException: Could not create a DBCP pool. There is an
error in the Hibernate configuration file, please review it.
...and I see this at line 92:
Caused by: java.sql.SQLException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
It looks like I did copy the MySQL-connector jar to tomcat/webapps/xwiki/WEB_INF.
I don't know what to make of either msg, and am going back to the archives looking
for those. I guess even before those I don't know what to make of this:
org.xwiki.query.QueryException: Exception while executing query. Query statement = [
select doc.fullName from XWikiDocument as doc , BaseObject as panel WHERE 1=1 and
doc.fullName=panel.name and panel.className='Panels.PanelClass’ ]
[snip]
10:11 p.m.
Ha-HA :-) Thank you again sir! I am past the errors and on to the Distribution
Wizard.
Fantastic.
It looks like I did copy the MySQL-connector jar to
tomcat/webapps/xwiki/WEB_INF.
It’s WEB-INF/lib. Could you check that?
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
netadmin(a)westmarine.com.
2867
days inactive
2867
days old
4 comments
2 participants
participants (2)
-
Douglas Landau -
Vincent Massol