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/