28 Sep
2015
28 Sep
'15
8:42 a.m.
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
28 Sep
28 Sep
9:12 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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
9:48 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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:
--
Thomas Mortagne
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
9:49 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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/xwi…,
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 <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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
9:54 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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
10:11 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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:
--
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
10:26 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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:
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:
--
Thomas Mortagne
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:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users 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
11:33 a.m.
New subject: [xwiki-users] XWiki migration problem to 7.2: ORA-00904: "TRUE": invalid identifier
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
3196
days inactive
3196
days old
7 comments
2 participants
participants (2)
-
Miroslav Galajda -
Thomas Mortagne