...
To my surprise, though, I didn't find much of a community or existing code samples for handling cross-platform Spring-JDBC. Apparently most of its users focus on one or two database vendors rather than on Sakai-style multiple-vendor support. This meant taking on the labor of inventing our own idioms and helpers (source code). The project post-mortem will tell whether this additional cost was worthwhile.
...
At first I assumed I'd use an Eclipse plug-in (such as Azzurrri Azzurri Clay) or an ORM helper to handle initial schema generation. So far, however, I seem not to be slowed down by hand-coding DDL based on existing examples.
...
The only tricky aspect turned out to be support for the more complex DDL needed by Oracle. The sample parsing code assumed ";" as a SQL statement delimiter, but that wouldnwhich doesn't work for embedded PL/SQL. I added primitive support for Oracle's "SET SQLTERMINATOR" statement to work around that.
...