Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

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.

...

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.

...