Finding a NoSQL Database with JTA Support

Question

Are there reliable and well-known NoSQL databases that support JTA transactions? In my application, I need to save some data in a DBMS and some data in a NoSQL database in one transaction, and I use JTA for RDBMS transactions.

Answer 1

Are there reliable and well-known NoSQL databases that support JTA transactions?

Neo4j supports XA protocol transactions, blocking detection, transaction recovery, JTA.

Update:. Reply to comment from OP:

Although Neo4j is not an RDBMS, I understand that NoSQL databases belong to these new generations of document-oriented databases such as CouchDB and MongoDB. But thanks for the answer.

Documented databases (CouchDB and MongoDB) are just ONE type of NoSQL databases, your understanding is wrong. Key / Value databases (Riak, Redis, Voldemort), column oriented databases (HBase and Cassandra), graphically oriented databases (Neo4j, HypergraphDB and FlockDB) belong to the NoSQL database family.

If you are looking for a document-oriented database, you may need to update your question because it is misleading.

Answer 2

Well, this is yes and there is no answer, yes, several NoSQL db offer atomic operations, but these are not transactions in the sense of RDMBS and, as a rule, affect only one document .

However, you have a big problem, your NoSQL connection resource will need to support XA transactions, which are in great demand. I cannot find XA transaction support links in the most popular offers. Can you always create your own XA resource or perhaps put things in a UserTransaction?