Hi Bastian, On 4 Sep 2015 at 10:55:34, ruschhauptb ([email protected](mailto:[email protected])) 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

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.

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-t...):

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:[email protected]> 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 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"]}