Could some interfaces in java.sql and javax.sql be

2019-09-10 09:46发布

问题:

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.

回答1:

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).



标签: java sql nosql