On Mar 23, 2007, at 5:59 AM, Ronald Borman wrote:

Vincent,

In a corporate environment XWiki will only be accepted if it conforms to company standards. Oracle is a big player in corporate data centers so it is vital that this database is supported. Our temporary XWiki implementation on MySQL is installed on a local server for now, but this situation is only tolerated because the use of XWiki is seen as innovation and backed by local management. Inevitably it has to move to our data center in the future.

Even manual tweaking after installation will deter potential users. So I think XWiki has to work on Oracle out-of-the-box.

In my past 6 years of consulting at big companies 90% of them were using Oracle so I really agree... :)

Now I am not an Oracle expert, but I like a good challenge. I will try to get Oracle working on a test machine and report on the results.

Spiffy

BTW Oracle has a free version of Oracle 10g called Oracle Express Edition. It has many features of the standard edition (the in-process JVM is missing though) with some limitations on memory, storage and processor use). The Windows package comes with a decent installer and it will run on a machine with 512MB. Ideal for testing...

Ok thanks. I'm on mac but I'll check if they have an install for it.

Thanks
-Vincent

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



--
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