[xwiki-users] Does XWIKI Support Oracle12c?

List overview All Threads
Download

newer

older

[xwiki-users] Do not import...

[xwiki-users] Problem trying to...

ruschhauptb

4 Sep 2015 4 Sep '15

10:55 a.m.

Hello, we try to run XWIKI with an Oracle 12c Database, but have not been succesful yet. We changed the property in the hibernate.cfg.xml to <property name="dialect">org.hibernate.dialect.Oracle12cDialect</property> but we only get this error: {"level":"ERROR","thread":"XWiki initialization","logger":"com.xpn.xwiki.internal.XWikiInitializerJob","context":"etu1appqk01_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: org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.Oracle12cDialect\n\tat org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:159)\n\tat org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99)\n\tat org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117)\n\tat org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)\n\tat org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)\n\tat org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:253)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:682)\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:827)\n\t... 11 common frames omitted\nCaused by: java.lang.ClassNotFoundException: org.hibernate.dialect.Oracle12cDialect\n\tat org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1714)\n\tat org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)\n\tat java.lang.Class.forName0(Native Method)\n\tat java.lang.Class.forName(Class.java:186)\n\tat org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)\n\tat org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156)\n\t... 19 common frames omitted\n","zeitstempel":"2015-0904T08:22:54.312Z","nachricht":"Exception thrown during job execution","korrelationsid":"none","marker":["xwiki.translation"]} Does XWIKI support oracle12c? This artikel <http://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy> says that only 11.x is supported, but the article was updated the in 2014 the last time. If there is a way to run xwiki with an oracle 12c database, what do we have to do? thanks for your help best regards Bastian -- View this message in context: http://xwiki.475771.n2.nabble.com/Does-XWIKI-Support-Oracle12c-tp7595891.ht… Sent from the XWiki- Users mailing list archive at Nabble.com.

Show replies by date

vincent＠massol.net

4 Sep 4 Sep

7:30 p.m.

Hi Bastian, On 4 Sep 2015 at 10:55:34, ruschhauptb (bastian.ruschhaupt@bva.bund.de(mailto:bastian.ruschhaupt@bva.bund.de)) wrote:

...

Hello, we try to run XWIKI with an Oracle 12c Database, but have not been succesful yet. We changed the property in the hibernate.cfg.xml to org.hibernate.dialect.Oracle12cDialect but we only get this error:

[snip]

...

11 common frames omitted\nCaused by: java.lang.ClassNotFoundException: org.hibernate.dialect.Oracle12cDialect\n\tat

This is because this hibernate dialect doesn’t exist in Hibernate 3.6.9 Final that we use. This Hibernate issue https://hibernate.atlassian.net/browse/HHH-9044 suggests that a Oracle 12c dialect has been introduced only in Hibernate 5.0.0. However maybe using org.hibernate.dialect.Oracle10gDialect will work. Have you tried using that dialect? [snip]

...

Does XWIKI support oracle12c? This artikel says that only 11.x is supported, but the article was updated the in 2014 the last time. If there is a way to run xwiki with an oracle 12c database, what do we have to do?

I personally haven’t tried XWiki with Oracle 12 so I don’t know. Let us know if the suggestion above works. Thanks -Vincent

...

thanks for your help best regards Bastian

ruschhauptb

8 Sep 8 Sep

10:17 a.m.

Hello Vincent, yes we tried Oracle10gDialect. In this case the get the Error number 3202 in 3: Exception while reading document [xwiki:AnnotationCode.AnnotationConfig] Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki Caused by: org.hibernate.QueryTimeoutException: error executing work Caused by: java.sql.SQLException: ORA-01435: *Benutzer ist nicht vorhanden.* The bold error message says *User does not exists * But we are sure we used a correct connection string. Because were able to connect from the server to our Database using the same connection string via sqlplus. Our concluse is that there is a problem using the Oracle10gDialect with a 12c Oracle Database. thank you for your help. best regards Bastian -- 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.

Paul Libbrecht

10:28 a.m.

Could it be something between localhost and 127.0.0.1 or a full hostname and address? I often met MySQL grants to be different between these and I am sure Oracle makes it even more safe. The fact that QueryTimeoutException is given seems to be more indicative or a connection problem. Can you paste the complete stack-trace? With some very clever logging adjustment I think you can even let hibernate log each of the SQL query. I doubt the very first query is something that is far from standard SQL. paul ruschhauptb wrote:

...

The bold error message says *User does not exists* But we are sure we used a correct connection string. Because were able to connect from the server to our Database using the same connection string via sqlplus. Our concluse is that there is a problem using the Oracle10gDialect with a 12c Oracle Database.

ruschhauptb

10:50 a.m.

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.

Paul Libbrecht

11:38 a.m.

Hey Bastian, you might be bitten by the same I was recently since you have this in the log:

...

com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while

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 can change it in xwiki.cfg (property xwiki.db).xwiki

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:

...

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

3393

days inactive

3397

days old

xwiki-users@xwiki.org

Manage subscription

5 comments

3 participants

tags (0)

participants (3)

Paul Libbrecht
ruschhauptb
vincent＠massol.net