Other folks have asked about using SQL and NoSQL together, and subsequently whether there's a clean way of defining the access objects in a clean, generic way.
My question is somewhat related -- which parts of java.sql and javax.sql can be re-used, and is there any plan for Oracle* to get into the NoSQL space and hopefully provide an API? I know that the various NoSQL options differ quite a lot, hence having a "JDBC" doesn't seem to make sense.
PS I like what David Pollack is doing for Lift with Record and DBRecord.
***** That's Oracle-who-now-owns-Java, not Oracle-the-database.
Now, each NoSQL engine (Cassandra, Neo4J, HBase, etc.) provides its own access API. Theses APIs are not unified, and are absolutely not based on "java.sql" nor "javax.sql".
So, now, I think it makes no sense to try using theses packages with NoSQL databases. But I'm hoping for a unification of theses products with a common API (and/or query language) by category (column-oriented, graph, document databases for example).