Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-11399

MySQL connection URL not read in hibernate.cfg.xml

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • Major
    • None
    • 6.2.3
    • Old Core
    • None
    • CentOS 5.x, Oracle Java (latest), Tomcat 7.x, MySQL 5.0.x
    • Unknown
    • N/A
    • N/A

    Description

      Installed xwiki enterprise 6.2.3 in a dedicated tomcat 7.
      Created a MySQL database named 'abcd' for example.
      Changed the configuration file 'hibernate.cfg.xml' to access the created database :

          <property name="connection.url">jdbc:mysql://localhost/abcd</property>
          <property name="connection.username">abcd</property>
          <property name="connection.password">abcd</property>
          <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
          <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
          <property name="dbcp.ps.maxActive">20</property>
          <mapping resource="xwiki.hbm.xml"/>
          <mapping resource="feeds.hbm.xml"/>
          <mapping resource="activitystream.hbm.xml"/>
          <mapping resource="instance.hbm.xml"/>
      

      After starting the tomcat instance and accessing the webapp, an error is shown while xwiki trying to access a "xwiki" named database although been specified to access a "abcd" named database :

      Unknown database 'xwiki'
      class com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:AnnotationCode.AnnotationConfig]
          at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)
          at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)
          at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305)
          at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352)
          at com.xpn.xwiki.doc.DefaultDocumentAccessBridge.getProperty(DefaultDocumentAccessBridge.java:385)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyObject(AbstractDocumentConfigurationSource.java:146)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:135)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:108)
          at org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:121)
          at org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67)
          at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:775)
          at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739)
          at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660)
          at com.xpn.xwiki.XWiki.<init>(XWiki.java:649)
          at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)
          at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)
          at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)
          at java.lang.Thread.run(Thread.java:745)
      Caused by: class com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki
          at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)
          at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)
          at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)
          at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)
          at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)
          at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305)
          at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352)
          at com.xpn.xwiki.doc.DefaultDocumentAccessBridge.getProperty(DefaultDocumentAccessBridge.java:385)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyObject(AbstractDocumentConfigurationSource.java:146)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:135)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:108)
          at org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:121)
          at org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67)
          at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:775)
          at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739)
          at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660)
          at com.xpn.xwiki.XWiki.<init>(XWiki.java:649)
          at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)
          at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)
          at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)
          at java.lang.Thread.run(Thread.java:745)
      Caused by: class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'xwiki'
          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
          at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
          at com.mysql.jdbc.Util.getInstance(Util.java:383)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
          at com.mysql.jdbc.ConnectionImpl.setCatalog(ConnectionImpl.java:5456)
          at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374)
          at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374)
          at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setCatalog(PoolingDataSource.java:333)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:606)
          at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74)
          at com.sun.proxy.$Proxy47.setCatalog(Unknown Source)
          at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:729)
          at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)
          at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)
          at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)
          at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)
          at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305)
          at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352)
          at com.xpn.xwiki.doc.DefaultDocumentAccessBridge.getProperty(DefaultDocumentAccessBridge.java:385)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyObject(AbstractDocumentConfigurationSource.java:146)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:135)
          at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:108)
          at org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:121)
          at org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67)
          at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:775)
          at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739)
          at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660)
          at com.xpn.xwiki.XWiki.<init>(XWiki.java:649)
          at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)
          at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)
          at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)
          at java.lang.Thread.run(Thread.java:745)
      

      Attachments

        Activity

          People

            vmassol Vincent Massol
            hcross Hoani CROSS
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: