Thanks Thomas and Clemens. I moved to java 7 and using ojdbc6.jar instead of ojdbc14.jar. But i am getting below error when i hit url http://localhost:8888/wiki/ in browser after my tomcat start
Failed to extract Entity Resource Reference from URL [ http://localhost:8888/wiki/bin/view/Main/]] with root cause java.sql.SQLException: ORA-01408: such column list already indexed at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) On Mon, Aug 17, 2015 at 2:46 PM, Thomas Mortagne <thomas.morta...@xwiki.com> wrote: > Yes the exact error looks more like jdbc issue but the first thing is > to move to Java 7 instead of Java 6 in any case. I'm even surprised it > went as far as trying to initialize the DB. > > On Mon, Aug 17, 2015 at 10:57 AM, Clemens Klein-Robbenhaar > <c.robbenh...@espresto.com> wrote: > > > > Alternatively it might have something to do with the JDBC driver. > > > > XWiki wants a JDBC-4 driver for the 7.x series > > (This information can be found somewhere in the release notes for 7.0: > > > http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki70#HIssuesspecifictoXWiki7.0 > ) > > > > Maybe you have a somewhat "older" Oracle JDBC driver? > > > > (Somehow your tomcat must have found a new java version, btw, or it > would fail to start up with a different error message than what you got: > > > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HUnsupportedmajor.minorversion51.0 > ) > > > > > > just a guess > > Clemens > > > > > >> But this issue does not seems to be related to java 6/7. Looking at logs > >> looks like its an issue related to database. Isn't it ? > >> > >> On Mon, Aug 17, 2015 at 11:52 AM, Thomas Mortagne < > thomas.morta...@xwiki.com > >>> wrote: > >> > >>> XWiki require Java 7 since 6.0. > >>> > >>> On Sun, Aug 16, 2015 at 3:11 PM, Mohit Gupta <motgu...@gmail.com> > wrote: > >>>> I download the xwiki war file i.e xwiki-enterprise-web-7.2-milestone-2 > >>> with > >>>> db as Oracle. > >>>> > >>>> Here the configuration in hibernate.cfg.file > >>>> > >>>> <property name="connection.url">jdbc:oracle:thin:@localhost > >>>> :1521:orcl</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"/> > >>>> > >>>> But when i hit the url in browser i get below error > >>>> > >>>> > >>>> > >>>> > >>>> XWiki initialization failed! > >>>> > >>>> Exception thrown during job execution > >>>> class java.lang.AbstractMethodError: null > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:283) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:357) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2287) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215) > >>>> 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:253) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:681) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:842) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:299) > >>>> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1562) > >>>> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1609) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getBaseObject(AbstractDocumentConfigurationSource.java:209) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getBaseProperty(AbstractDocumentConfigurationSource.java:219) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyValue(AbstractDocumentConfigurationSource.java:315) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:272) > >>>> at > >>>> > >>> > org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:120) > >>>> at > >>>> > >>> > org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67) > >>>> at > >>> com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1042) > >>>> at > >>> com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1021) > >>>> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:966) > >>>> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:887) > >>>> at com.xpn.xwiki.XWiki.<init>(XWiki.java:876) > >>>> at > >>>> > >>> > com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117) > >>>> 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:724) > >>>> > >>>> > >>>> I am using jdk 6, tomcat 7 > >>>> > >>>> > >>>> I am not sure what is missing here ? > >>>> > >>>> Thanks and Regards > >>>> Mohit > >>>> _______________________________________________ > >>>> users mailing list > >>>> users@xwiki.org > >>>> http://lists.xwiki.org/mailman/listinfo/users > >>> > >>> > >>> > >>> -- > >>> Thomas Mortagne > >>> _______________________________________________ > >>> users mailing list > >>> users@xwiki.org > >>> http://lists.xwiki.org/mailman/listinfo/users > >>> > >> > >> > >> On Mon, Aug 17, 2015 at 11:52 AM, Thomas Mortagne < > thomas.morta...@xwiki.com > >>> wrote: > >> > >>> XWiki require Java 7 since 6.0. > >>> > >>> On Sun, Aug 16, 2015 at 3:11 PM, Mohit Gupta <motgu...@gmail.com> > wrote: > >>>> I download the xwiki war file i.e xwiki-enterprise-web-7.2-milestone-2 > >>> with > >>>> db as Oracle. > >>>> > >>>> Here the configuration in hibernate.cfg.file > >>>> > >>>> <property name="connection.url">jdbc:oracle:thin:@localhost > >>>> :1521:orcl</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"/> > >>>> > >>>> But when i hit the url in browser i get below error > >>>> > >>>> > >>>> > >>>> > >>>> XWiki initialization failed! > >>>> > >>>> Exception thrown during job execution > >>>> class java.lang.AbstractMethodError: null > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:283) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:357) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2287) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038) > >>>> at > >>>> > >>> > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215) > >>>> 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:253) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:681) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:842) > >>>> at > >>>> > >>> > com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:299) > >>>> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1562) > >>>> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1609) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getBaseObject(AbstractDocumentConfigurationSource.java:209) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getBaseProperty(AbstractDocumentConfigurationSource.java:219) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyValue(AbstractDocumentConfigurationSource.java:315) > >>>> at > >>>> > >>> > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:272) > >>>> at > >>>> > >>> > org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:120) > >>>> at > >>>> > >>> > org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67) > >>>> at > >>> com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1042) > >>>> at > >>> com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1021) > >>>> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:966) > >>>> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:887) > >>>> at com.xpn.xwiki.XWiki.<init>(XWiki.java:876) > >>>> at > >>>> > >>> > com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117) > >>>> 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:724) > >>>> > >>>> > >>>> I am using jdk 6, tomcat 7 > >>>> > >>>> > >>>> I am not sure what is missing here ? > >>>> > >>>> Thanks and Regards > >>>> Mohit > >>>> _______________________________________________ > >>>> users mailing list > >>>> users@xwiki.org > >>>> http://lists.xwiki.org/mailman/listinfo/users > >>> > >>> > >>> > >>> -- > >>> Thomas Mortagne > >>> _______________________________________________ > >>> users mailing list > >>> users@xwiki.org > >>> http://lists.xwiki.org/mailman/listinfo/users > >>> > > _______________________________________________ > > users mailing list > > users@xwiki.org > > http://lists.xwiki.org/mailman/listinfo/users > > > > -- > Thomas Mortagne > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
