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

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: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while 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: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while 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: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while 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"]} -- View this message in context: http://xwiki.475771.n2.nabble.com/Does-XWIKI-Support-Oracle12c-tp7595891p75… Sent from the XWiki- Users mailing list archive at Nabble.com.