28 Sep
2015
28 Sep
'15
9:54 a.m.
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 <thomas.mortagne(a)xwiki.com>
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
<thomas.mortagne(a)xwiki.com> wrote:
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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
<miroslav.galajda(a)gmail.com> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne