[xwiki-devs] Statistics flawed in my case (Oracle XE 10g)
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-tp4709339p47... Sent from the XWiki- Dev mailing list archive at Nabble.com.
On Wed, Mar 10, 2010 at 15:14, NicolaNardino <[email protected]> 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-tp4709339p47... Sent from the XWiki- Dev mailing list archive at Nabble.com. _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
On Mar 10, 2010, at 3:49 PM, Thomas Mortagne wrote:
On Wed, Mar 10, 2010 at 15:14, NicolaNardino <[email protected]> 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.
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
Well, sometimes I'm getting anothererror message ROR util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expecte d - got CLOB
Any clue?
Cheers Nicola
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/
On Wed, Mar 10, 2010 at 15:51, Sergiu Dumitriu <[email protected]> wrote:
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.
Actually it has been done on purpose.
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 [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
On Wed, Mar 10, 2010 at 15:55, Thomas Mortagne <[email protected]> wrote:
On Wed, Mar 10, 2010 at 15:51, Sergiu Dumitriu <[email protected]> wrote:
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.
Actually it has been done on purpose.
In http://jira.xwiki.org/jira/browse/XWIKI-4753. See the comment in MySQL mapping file.
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 [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
-- Thomas Mortagne
participants (4)
-
NicolaNardino -
Sergiu Dumitriu -
Thomas Mortagne -
Vincent Massol