Hey,
I've played around with XWiki a little while ago (apologies for
vaugness, its kinda on the edge of my memory) and managed to configure
it to use a datasource (as described in this thread already) with a
servlet container (in this case Orion).
For the database I used postgres, and on hooking the two together, all
the tables where created automatically for me (I just added the db to
postgres and gave it rights - no bootstrap sql files run). Because I
wanted to bootstrap in some content, I just created an XWiki plugin that
on the plugin's startup event checks to see if pages like Main.WebHome
already exist, and if they dont copy in some template files I put in the
classpath (it was a case of if none of the template files exist, create
them all, if any exist, don't create any new if that makes sense).
If you're referring to populating the created
tables with initial
data, I've
been thinking about that lately. Xwiki needs a tool to
help improve
multiple
back-end database support. Perhaps something that
could pull data out
of a
development snapshot database into an XML format file,
and then
populate the
desired target database from the XML format file.
There's an XML-DBMS project that might work for this purpose:
http://www.rpbourret.com/xmldbms/index.htm For my plugin to do this I just created
a load of text files with the
names of the pages they where going to, and an index page. Put the
whole lot in a jar, read off each page name from the index page in a
loop, put each real page into xwiki using the internal XWiki API (even
gets round database schema changing issues). Simple :)
For my use case this works well enough for the moment (I havn't upgraded
to the latest version of the code since (well I wrote down) svn v499
(the project I was using XWiki for has been backburnered for a while),
not sure how relevant it still is?
Kindest regards,
Tristan Allwood
PS When are we really getting jsr 168 portlet compatibility? ;)
--
Tristan O. R. Allwood
Formicary - delivering quality financial technology solutions
www.formicary.net