[xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); } return query.toString(); } The raised error: java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106) at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more Mirec
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter). I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ? In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI. On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106) at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
After some digging looks like even if it's encapsulated by Hibernate the executed code is using low level SQL and not HQL. Taking care of it. On Mon, Sep 28, 2015 at 11:12 AM, Thomas Mortagne <[email protected]> wrote:
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter).
I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ?
In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI.
On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182) at com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106) at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne
Hi, I don't know if the code which I've pasted is old or not, but after searching for occurence in lib directory, I found this source file https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwik..., which seems very actual. In the call stack of the exception which I get is mentioned "R72001XWIKI12228DataMigration", which fails on the error ORA-00904: "TRUE": invalid identifier. Oracle doesn't support such configuration to know that TRUE means boolean true. Oracle doesn't have any knowledge or concept of booleans. You cannot use true in pure sql statement because it is not compatible whithin database you support. Hibernate allows through qyery.substitution property to provide custom mapping of those literals, but it works on HQLs not on SQLs. Mirec On 28 September 2015 at 11:12, Thomas Mortagne <[email protected]> wrote:
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter).
I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ?
In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI.
On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Yes, you are right, HQL would help. I've created the issue: http://jira.xwiki.org/browse/XWIKI-12625 Mirec On 28 September 2015 at 11:48, Thomas Mortagne <[email protected]> wrote:
After some digging looks like even if it's encapsulated by Hibernate the executed code is using low level SQL and not HQL. Taking care of it.
On Mon, Sep 28, 2015 at 11:12 AM, Thomas Mortagne <[email protected]> wrote:
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter).
I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ?
In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI.
On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, I see you have fixed it. When will be the 7.2.1 version available? Mirec On 28 September 2015 at 11:54, Miroslav Galajda <[email protected]> wrote:
Yes, you are right, HQL would help.
I've created the issue: http://jira.xwiki.org/browse/XWIKI-12625
Mirec
On 28 September 2015 at 11:48, Thomas Mortagne <[email protected]> wrote:
After some digging looks like even if it's encapsulated by Hibernate the executed code is using low level SQL and not HQL. Taking care of it.
On Mon, Sep 28, 2015 at 11:12 AM, Thomas Mortagne <[email protected]> wrote:
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter).
I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ?
In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI.
On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Not sure when 7.2.1 will be released yet but in the meantime you can replace the xwiki-platform-legacy-oldcore-7.2.jar file in WEB_INF/lib by the one attached on http://jira.xwiki.org/browse/XWIKI-12625. On Mon, Sep 28, 2015 at 12:11 PM, Miroslav Galajda <[email protected]> wrote:
Hi, I see you have fixed it. When will be the 7.2.1 version available?
Mirec
On 28 September 2015 at 11:54, Miroslav Galajda <[email protected]> wrote:
Yes, you are right, HQL would help.
I've created the issue: http://jira.xwiki.org/browse/XWIKI-12625
Mirec
On 28 September 2015 at 11:48, Thomas Mortagne <[email protected]> wrote:
After some digging looks like even if it's encapsulated by Hibernate the executed code is using low level SQL and not HQL. Taking care of it.
On Mon, Sep 28, 2015 at 11:12 AM, Thomas Mortagne <[email protected]> wrote:
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter).
I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ?
In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI.
On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
thank you, it did work for me. I've successfully upgraded xwiki to 7.2. Mirec On 28 September 2015 at 12:26, Thomas Mortagne <[email protected]> wrote:
Not sure when 7.2.1 will be released yet but in the meantime you can replace the xwiki-platform-legacy-oldcore-7.2.jar file in WEB_INF/lib by the one attached on http://jira.xwiki.org/browse/XWIKI-12625.
On Mon, Sep 28, 2015 at 12:11 PM, Miroslav Galajda <[email protected]> wrote:
Hi, I see you have fixed it. When will be the 7.2.1 version available?
Mirec
On 28 September 2015 at 11:54, Miroslav Galajda < [email protected]> wrote:
Yes, you are right, HQL would help.
I've created the issue: http://jira.xwiki.org/browse/XWIKI-12625
Mirec
On 28 September 2015 at 11:48, Thomas Mortagne < [email protected]> wrote:
After some digging looks like even if it's encapsulated by Hibernate the executed code is using low level SQL and not HQL. Taking care of it.
On Mon, Sep 28, 2015 at 11:12 AM, Thomas Mortagne <[email protected]> wrote:
I don't understand, the code you indicated is actually copy/pasted from hidden document filter which is very old (like that since 4.0 and even older in another form than a filter).
I'm really far from an Oracle expert, could this be related to some Oracle configuration to enable/disable boolean literal support ?
In the meantime would be great if you could create an issue on http://jira.xwiki.org/browse/XWIKI.
On Mon, Sep 28, 2015 at 10:42 AM, Miroslav Galajda <[email protected]> wrote:
Hi, when migrating XWiki from version 7.1.1 to 7.2, I get the error bellow. My XWiki runs on Oracle DB. It seems that there's error in using TRUE literal in sql statements, which is not supported on Oracle. Could you please fix this. I located the error in the following method in R72001XWIKI12228DataMigration.java
private String createSpaceQuery(boolean hidden) { StringBuilder query = new StringBuilder("select DISTINCT XWD_WEB from xwikidoc where"); if (hidden) { query.append(" XWD_WEB not in (" + createSpaceQuery(false) + ")"); } else { query.append(" XWD_HIDDEN <> *true *OR XWD_HIDDEN IS NULL"); }
return query.toString(); }
The raised error:
java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.getVisibleSpaces(R72001XWIKI12228DataMigration.java:129)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.createVisibleSpaces(R72001XWIKI12228DataMigration.java:182)
at
com.xpn.xwiki.store.migration.hibernate.R72001XWIKI12228DataMigration$R72001Work.execute(R72001XWIKI12228DataMigration.java:106)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) ... 28 more
Mirec _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
Miroslav Galajda -
Thomas Mortagne