2007/3/20, Vincent Massol <vincent@massol.net>:

On Mar 20, 2007, at 9:26 AM, Vincent Massol wrote:

>
> On Mar 19, 2007, at 1:55 PM, Ronald Borman wrote:
>
>> John,
>>
>> Even if the problems mentioned are solved, there could be more
>> incompatibilities when using Oracle. The organization I work for has
>> chosen to install XWiki on MySQL for the time being until a working
>> version under Oracle in a test environment has a track record.
>>
>> That won't help you if your company standards dictate using Oracle
>> though...
>>
>> For the problem regarding searching clobs I currently don't see a
>> solution with minimal impact. Oracle has a search engine (Oracle
>> Text)
>> but it seems to be an extra (external?) feature. Lucene could be an
>> option (there is even a XWiki plugin), but implementing this is also
>> no trivial task.
>>
>> A collegae of mine suggested living with the knowledge that only the
>> first 4K of a document is searched (if it works that way...).
>
> Yes that may be a good temporary solution and it's possible that
> drivers or hibernate support for Oracle improves over time.
>
> See also http://jira.xwiki.org/jira/browse/XWIKI-838. Might be good
> to use this issue to gather feedbacks and ideas on CLOBs. Eric Sun
> has provided a patch.
>
> It would be cool if someone could look at the patch, validate that
> it works and report back on the issue.

I've just checked the patch and it looks good. It uses listeners for
handling NULL/Empty string. Not sure what are the pros/cons with a
user type. Anyone knows?

On a minor note we should move the hbm files out of the XWiki core
jar and move them into WEB-INF next to the hibernate.cfg.xml file so
that it can be easily modified. This would allow to keep exactly the
same configuration for all databases and provide a hbm and
hibernate.cfg.xml files for Oracle.

WDYT?

I don't have an Oracle installation at hand. If someone could try the
patch that would be cool.

Thanks
-Vincent

>
> XWiki committers should also look into it.
>
>>
>> Regarding the problem with empty strings there may be a solution.
>> Hibernate lets you define a UserType and substitute a defined type in
>> a mapping file with this type. The URL
>> http://www.hibernate.org/169.html descibes a type that stores empty
>> strings by escaping or marking an empty string so that the value is
>> not converted into null.
>
> Ah funny... I just replied to you with this same link :)
>
>> If this works, you could at least install and start up XWiki on
>> Oracle.
>>
>> Regards,
>
> Thanks
> -Vincent
>
>
>
> --
> You receive this message as a subscriber of the xwiki-
> users@objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
> For general help: mailto:sympa@objectweb.org ?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/
> wws

--
You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto: sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws