10 Mar
2010
10 Mar
'10
3:14 p.m.
Hi guys, have you ever experienced such an issue?
I had to set nullable "XWIKISTATSDOC"."XWS_CLASSNAME" to make
statistics
working, because I was receiving this:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
cannot
insert NULL into (...."XWIKISTATSDOC"."XWS_CLASSNAME")
Well, sometimes I'm getting anothererror message ROR
util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte
d - got CLOB
Any clue?
Cheers
Nicola
--
View this message in context:
http://n2.nabble.com/Statistics-flawed-in-my-case-Oracle-XE-10g-tp4709339p4…
Sent from the XWiki- Dev mailing list archive at Nabble.com.
10 Mar
10 Mar
3:49 p.m.
On Wed, Mar 10, 2010 at 15:14, NicolaNardino
<nicola.nardino(a)credit-suisse.com> wrote:
Hi guys, have you ever experienced such an issue?
I had to set nullable "XWIKISTATSDOC"."XWS_CLASSNAME" to make
statistics
working, because I was receiving this:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
cannot
insert NULL into (...."XWIKISTATSDOC"."XWS_CLASSNAME")
Indeed the value of XWS_CLASSNAME changed in 2.2M2, it used to be
"internal" and is can now be "" or null. But the mapping has not been
changed, i'm fixing that.
Well, sometimes I'm getting anothererror message ROR
util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte
d - got CLOB
Any clue?
Cheers
Nicola
--
View this message in context:
http://n2.nabble.com/Statistics-flawed-in-my-case-Oracle-XE-10g-tp4709339p4…
Sent from the XWiki- Dev mailing list archive at Nabble.com.
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
--
Thomas Mortagne
3:51 p.m.
On Mar 10, 2010, at 3:49 PM, Thomas Mortagne wrote:
On Wed, Mar 10, 2010 at 15:14, NicolaNardino
<nicola.nardino(a)credit-suisse.com> wrote:
Note that you can fix this on your instance by editing your oracle.hbm.xml file and remove
the not-null contraint.
It'll be fixed in XE 2.2.3
Thanks
-Vincent
Hi guys, have you ever experienced such an issue?
I had to set nullable "XWIKISTATSDOC"."XWS_CLASSNAME" to make
statistics
working, because I was receiving this:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
cannot
insert NULL into (...."XWIKISTATSDOC"."XWS_CLASSNAME")
Indeed the value of XWS_CLASSNAME changed in 2.2M2, it used to be
"internal" and is can now be "" or null. But the mapping has not
been
changed, i'm fixing that.
>
> Well, sometimes I'm getting anothererror message ROR
> util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte
> d - got CLOB
>
> Any clue?
>
> Cheers
> Nicola
3:51 p.m.
On 03/10/2010 03:14 PM, NicolaNardino wrote:
Hi guys, have you ever experienced such an issue?
I had to set nullable "XWIKISTATSDOC"."XWS_CLASSNAME" to make
statistics
working, because I was receiving this:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
cannot
insert NULL into (...."XWIKISTATSDOC"."XWS_CLASSNAME")
That is strange, this column should always have "internal" as the value,
which is definitely not NULL.
I looked at the code, and it looks like this is a bug in the core, the
"internal" value is set only when using a certain constructor.
Well, sometimes I'm getting anothererror message
ROR
util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte
d - got CLOB
This one comes from the fact that Oracle databases don't allow some SQL
stuff to be used with CLOB columns. For example:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3606
You should note which documents/actions generate this exception and
report them ( http://jira.xwiki.org/ ), so that they can be fixed.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
3:55 p.m.
On Wed, Mar 10, 2010 at 15:51, Sergiu Dumitriu <sergiu(a)xwiki.com> wrote:
--
Thomas Mortagne
On 03/10/2010 03:14 PM, NicolaNardino wrote:
Actually it has been done on purpose.
Hi guys, have you ever experienced such an issue?
I had to set nullable "XWIKISTATSDOC"."XWS_CLASSNAME" to make
statistics
working, because I was receiving this:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
cannot
insert NULL into (...."XWIKISTATSDOC"."XWS_CLASSNAME")
That is strange, this column should always have "internal" as the value,
which is definitely not NULL.
I looked at the code, and it looks like this is a bug in the core, the
"internal" value is set only when using a certain constructor. Well, sometimes I'm getting anothererror
message ROR
util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte
d - got CLOB
This one comes from the fact that Oracle databases don't allow some SQL
stuff to be used with CLOB columns. For example:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3606
You should note which documents/actions generate this exception and
report them ( http://jira.xwiki.org/ ), so that they can be fixed.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
3:55 p.m.
On Wed, Mar 10, 2010 at 15:55, Thomas Mortagne
<thomas.mortagne(a)xwiki.com> wrote:
--
Thomas Mortagne
--
Thomas Mortagne
On Wed, Mar 10, 2010 at 15:51, Sergiu Dumitriu
<sergiu(a)xwiki.com> wrote:
In http://jira.xwiki.org/jira/browse/XWIKI-4753. See the comment in
MySQL mapping file.
On 03/10/2010 03:14 PM, NicolaNardino wrote:
Actually it has been done on purpose.
Hi guys, have you ever experienced such an issue?
I had to set nullable "XWIKISTATSDOC"."XWS_CLASSNAME" to make
statistics
working, because I was receiving this:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
cannot
insert NULL into (...."XWIKISTATSDOC"."XWS_CLASSNAME")
That is strange, this column should always have "internal" as the value,
which is definitely not NULL.
I looked at the code, and it looks like this is a bug in the core, the
"internal" value is set only when using a certain constructor. Well, sometimes I'm getting anothererror
message ROR
util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte
d - got CLOB
This one comes from the fact that Oracle databases don't allow some SQL
stuff to be used with CLOB columns. For example:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3606
You should note which documents/actions generate this exception and
report them ( http://jira.xwiki.org/ ), so that they can be fixed.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
5357
days inactive
5357
days old
5 comments
4 participants
participants (4)
-
NicolaNardino -
Sergiu Dumitriu -
Thomas Mortagne -
Vincent Massol