I have now included [1] some basic support for Derby in both the build.xml ant script and the createdb-raw.sql. I almost have a fully working version of Roller against Derby, but I'm having problems mostly with Hibernate. Hibernate 2.1 is really out of date and their dialects are not fully working for either db2 or derby. As a matter of fact, I had to write my own DerbyDialect (included in the patch) to get some of the queries working. Basically, I'm able to register a user, create a weblog and post entries. The dashboard is not working because of the use of LIMIT in the queries. I'm also encountering some problems with SQL functions (sum, etc) in Derby. I'll keep on hacking away until I get this working though.
Dave, let me know if I can help you with any questions you might have regarding the patch. Thanks again, Elias [1] http://torrez.us/2005/08/23/roller/patches/db2_derby_patches.tar.gz
