Re: Database Support - xwiki-devs@xwiki.org

21 Apr 2005

Hi Bruce,

Nice to meet you.

The first test you need to do is start XWiki with an empty database 
connected to the Firebird database.
In xwiki.cfg you should setup "xwiki.superadminpassword=toto" that will 
activate the "superadmin" user with password "toto" which will be able

to setup rights.

 From there you should be able to access an empty wiki and create some 
pages to see if everythings works.
Features to test are:

1/ Pages
2/ Attachments
3/ Versions

One of the key features needed is the support for large text fields 
(without size limits).
Oracle can't do this (except in the latest versions) and required some 
specific hibernate hacks.

Converting the default Database to Firebird might be more complex.
You can download the default DB on Sourceforge. It is a zipped SQL file 
exported from Mysql.
However I think it is quite full of specific MySQL sql.
I think there are some improvement in MySQL 4.1 to the export with 
allows for "compatible" export so you might need to import/export in 
MySQL to create a more compatible file.

Ludovic

Bruce Bacheller a écrit :

...
 Thanks for the Quick response.

I am on the Firebird Foundation (FirebirdSQL.org) and will get you any support needed from
our THE FirebirdSQL side  to get it working.

I will host it on my site which is FirebirdXML.info or Infodes.org.
That is Linux/Apache/Tomcat.

We are having hosting our user conference in germany next Month May 15th and I would like
to have it operational for that event. I will make sure that XWiki gets good exposure to
the Firebird Community as well.

We are pretty close to Oracle in syntax.

Can you send me a copy of the SQL code in MySQL (table creation) so I can review it and
set up test.

Looks like XWiki has developed A VERY NICE piece of Open Source Software.

Regards,
Bruce

-----Original Message-----
From: Ludovic Dubost [mailto:ludovic@xwiki.org] 
Sent: Wednesday, April 20, 2005 3:54 PM
To: Bruce Bacheller; xwiki-dev(a)objectweb.org
Subject: Re: Database Support

Hi,

We haven't made any tests, but XWiki uses hibernate and JDBC so there is 
a good chance that it works.
You will need to try. We are open to requests in case of problems.

Ludovic

Bruce Bacheller a écrit :

 Do you have plans to Support Firebird the Open
Source DBMS ?

-- 
Ludovic Dubost
XPertNet: http://www.xpertnet.fr/
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic