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
in browser
after my tomcat start
Failed to extract Entity Resource Reference from URL [
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.mortagne(a)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.robbenhaar(a)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#HIssue…
)
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#HUnsupport…
)
> 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.mortagne(a)xwiki.com
>> wrote:
>
>> XWiki require Java 7 since 6.0.
>>
>> On Sun, Aug 16, 2015 at 3:11 PM, Mohit Gupta <motgupta(a)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(a)xwiki.org
>>>
http://lists.xwiki.org/mailman/listinfo/users
>>
>>
>>
>> --
>> Thomas Mortagne
>> _______________________________________________
>> users mailing list
>> users(a)xwiki.org
>>
http://lists.xwiki.org/mailman/listinfo/users
>>
>
>
> On Mon, Aug 17, 2015 at 11:52 AM, Thomas Mortagne <
thomas.mortagne(a)xwiki.com
>> wrote:
>
>> XWiki require Java 7 since 6.0.
>>
>> On Sun, Aug 16, 2015 at 3:11 PM, Mohit Gupta <motgupta(a)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(a)xwiki.org
>>
http://lists.xwiki.org/mailman/listinfo/users
>
>
>
> --
> Thomas Mortagne
> _______________________________________________
> users mailing list
> users(a)xwiki.org
>
http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users