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