EmbeddedSql in Java:
- http://www.sqlj.org/ - SQLJ reference information site [DeadLink]
- http://www.oracle.com/technology//tech/java/sqlj_jdbc/index.html - Oracle's SQLJ product.
- http://www.javaworld.com/javaworld/jw-05-1999/jw-05-sqlj.html - article: "SQLJ: The 'open sesame' of Java database applications", "The SQLJ standard now provides SQL-based database access from Java apps"
Oracle's JSQL tries to do EmbeddedSql for JavaLanguage. It is horribly buggy. I especially loved the time I gave it a ten-line anonymous PL/SQL procedure and it told me there was a missing semicolon on line 40.
It's too bad, because JSQL code is generally much shorter than the corresponding JDBC code.