I vaguely remember reading good things about a framework on TSS that was useful for storing your SQL statements in XML and loading the fragments into your Java code. This was simply a way to keep your SQL statements outside your Java code, and was not intended as any sort of O-R mapping framework.
I cannot remember the name of this framework though, and searching for "sql, java, xml, framework" yields way too many results.
Does anyone remember which framework this is? Or, if you know of a framework that does this, please let me know.