Re: [xwiki-users] Does XWIKI Support Oracle12c?

Hey Bastian, you might be bitten by the same I was recently since you have this in the log: switching to database xwiki Since a few versions, indeed, multi-hosting (aka wiki-farm) is activated by default, so that you can create a database per wiki. This means that the default database name is attempted instead of the one specified in the hibernate.cfg.xml. As Thomas suggested then (http://xwiki.475771.n2.nabble.com/database-name-using-the-standalone-jetty-…): You should uncomment and write PORTALHILFE there. And... yes, XWiki will initialize the DB-schema if it finds it empty then offer you upload the default xar. Hope it helps. paul > ruschhauptb <mailto:bastian.ruschhaupt@bva.bund.de> > 8 septembre 2015 10:50 > Hello Paul, > > thank you for your reply. At the end you find the complete error > messages. > > At the moment we have an empty database schema named PORTALHILFE. We > expected XWIKI to create all tables on the first startup. Is this correct? > > Here is our hibernate.cft.xml configuration. Our database schema is called > PORTALHILFE, could this be a problem? > > > <property > name="connection.url">jdbc:oracle:thin:@172.17.12.5:1521:etu1db12c</property> > <property name="connection.username">PORTALHILFE</property> > <property name="connection.password">PORTALHILFE</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.ps.maxActive">20</property> > <mapping resource="xwiki.oracle.hbm.xml"/> > <mapping resource="feeds.oracle.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > <mapping resource="instance.hbm.xml"/> > > Do you know how we can increase the log level? > > _________________________________________________________________________ > > {"level":"ERROR","thread":"XWiki > initialization","logger":"org.hibernate.util.JDBCExceptionReporter","context":"etu1appqk01_plis-portalhilfe","zeitstempel":"2015-0904T08:40:47.939Z","nachricht":"ORA-01435: > Benutzer ist nicht vorhanden.\n","korrelationsid":"none"} > {"level":"ERROR","thread":"XWiki > initialization","logger":"com.xpn.xwiki.doc.DefaultDocumentAccessBridge","context":"etu1appqk01_plis-portalhilfe","exception":"com.xpn.xwiki.XWikiException: > Error number 3202 in 3: Exception while reading document > [xwiki:AnnotationCode.AnnotationConfig]\n\tat > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)\n\tat > com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)\n\tat > com.xpn.xwiki.XWiki.getDocument(XWiki.java:1299)\n\tat > com.xpn.xwiki.XWiki.getDocument(XWiki.java:1347)\n\tat > com.xpn.xwiki.doc.DefaultDocumentAccessBridge.getProperty(DefaultDocumentAccessBridge.java:385)\n\tat > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyObject(AbstractDocumentConfigurationSource.java:146)\n\tat > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:135)\n\tat > org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:108)\n\tat > org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:121)\n\tat > org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67)\n\tat > com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:769)\n\tat > com.xpn.xwiki.XWiki.initXWiki(XWiki.java:733)\n\tat > com.xpn.xwiki.XWiki.initXWiki(XWiki.java:654)\n\tat > com.xpn.xwiki.XWiki.<init>(XWiki.java:643)\n\tat > com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)\n\tat > org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)\n\tat > org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)\n\tat > java.lang.Thread.run(Thread.java:722)\nCaused by: > switching to database xwiki\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)\n\tat > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)\n\t... > 17 common frames omitted\nCaused by: org.hibernate.QueryTimeoutException: > error executing work\n\tat > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)\n\tat > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)\n\tat > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)\n\tat > org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:753)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:719)\n\t... > 20 common frames omitted\nCaused by: java.sql.SQLException: ORA-01435: > Benutzer ist nicht vorhanden.\n\n\tat > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)\n\tat > oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)\n\tat > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)\n\tat > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)\n\tat > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)\n\tat > oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)\n\tat > oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)\n\tat > oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)\n\tat > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)\n\tat > oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)\n\tat > oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)\n\tat > oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:760)\n\tat > org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)\n\t... 22 > common frames > omitted\n","zeitstempel":"2015-0904T08:40:48.000Z","nachricht":"Failed to > get property","korrelationsid":"none"} > {"level":"ERROR","thread":"XWiki > initialization","logger":"org.hibernate.util.JDBCExceptionReporter","context":"etu1appqk01_plis-portalhilfe","zeitstempel":"2015-0904T08:40:48.004Z","nachricht":"ORA-01435: > Benutzer ist nicht vorhanden.\n","korrelationsid":"none"} > {"level":"ERROR","thread":"XWiki > initialization","logger":"com.xpn.xwiki.internal.XWikiInitializerJob","context":"etu2appqk01_plis-portalhilfe","exception":"com.xpn.xwiki.XWikiException: > Error number 3202 in 3: Exception while reading document > [xwiki:XWiki.XWikiComments]\n\tat > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)\n\tat > com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)\n\tat > com.xpn.xwiki.XWiki.getDocument(XWiki.java:1299)\n\tat > com.xpn.xwiki.XWiki.getDocument(XWiki.java:1347)\n\tat > com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:773)\n\tat > com.xpn.xwiki.XWiki.initXWiki(XWiki.java:733)\n\tat > com.xpn.xwiki.XWiki.initXWiki(XWiki.java:654)\n\tat > com.xpn.xwiki.XWiki.<init>(XWiki.java:643)\n\tat > com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)\n\tat > org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)\n\tat > org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)\n\tat > java.lang.Thread.run(Thread.java:722)\nCaused by: > switching to database xwiki\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)\n\tat > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)\n\t... > 11 common frames omitted\nCaused by: org.hibernate.QueryTimeoutException: > error executing work\n\tat > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)\n\tat > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)\n\tat > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)\n\tat > org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:753)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:719)\n\t... > 14 common frames omitted\nCaused by: java.sql.SQLException: ORA-01435: > Benutzer ist nicht vorhanden.\n\n\tat > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)\n\tat > oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)\n\tat > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)\n\tat > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)\n\tat > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)\n\tat > oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)\n\tat > oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)\n\tat > oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)\n\tat > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)\n\tat > oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)\n\tat > oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)\n\tat > oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:760)\n\tat > org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)\n\t... 16 > common frames > omitted\n","zeitstempel":"2015-0904T08:40:48.005Z","nachricht":"Exception > thrown during job > execution","korrelationsid":"none","marker":["xwiki.translation"]} > > {"level":"ERROR","thread":"XWiki > initialization","logger":"com.xpn.xwiki.internal.XWikiInitializerJob","context":"etu2appqk01_plis-portalhilfe","exception":"com.xpn.xwiki.XWikiException: > Error number 3202 in 3: Exception while reading document > [xwiki:XWiki.XWikiComments]\n\tat > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)\n\tat > com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)\n\tat > com.xpn.xwiki.XWiki.getDocument(XWiki.java:1299)\n\tat > com.xpn.xwiki.XWiki.getDocument(XWiki.java:1347)\n\tat > com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:773)\n\tat > com.xpn.xwiki.XWiki.initXWiki(XWiki.java:733)\n\tat > com.xpn.xwiki.XWiki.initXWiki(XWiki.java:654)\n\tat > com.xpn.xwiki.XWiki.<init>(XWiki.java:643)\n\tat > com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)\n\tat > org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)\n\tat > org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)\n\tat > java.lang.Thread.run(Thread.java:722)\nCaused by: > switching to database xwiki\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)\n\tat > com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)\n\t... > 11 common frames omitted\nCaused by: org.hibernate.QueryTimeoutException: > error executing work\n\tat > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)\n\tat > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)\n\tat > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)\n\tat > org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:753)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:719)\n\t... > 14 common frames omitted\nCaused by: java.sql.SQLException: ORA-01435: > Benutzer ist nicht vorhanden.\n\n\tat > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)\n\tat > oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)\n\tat > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)\n\tat > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)\n\tat > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)\n\tat > oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)\n\tat > oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)\n\tat > oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)\n\tat > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)\n\tat > oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)\n\tat > oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)\n\tat > oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat > com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:760)\n\tat > org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)\n\t... 16 > common frames > omitted\n","zeitstempel":"2015-0904T08:40:48.005Z","nachricht":"Exception > thrown during job > execution","korrelationsid":"none","marker":["xwiki.translation"]}