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