>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
netad...@westmarine.com.
