OrientDB connection pools

2
votes

I'm using OrientDB 2.2.5 for the backend for a multi threaded Java web application and I've tried numerous different connection methods. Each method seems to have a problem.

I essentially need something that I can call concurrently to use the OrientDB database, be it a static method or object instance.

I've tried various methods and had issues with record locking, or various other exceptions. The documentation shows a depreciated connection pool method (ODatabaseDocumentPool), and various other sources on the internet show a mixtures of ways (ODatabaseDocumentTx, OPartitionedDatabasePool).

Please could someone provide a reusable method for connecting to the instance (currently just a plocal) and issuing a basic query. Please also include any connection cleanup logic (I think it's this that has caused me issues with records being locked, even several seconds after the last update).

Any help/ pointers would be greatly appreciated.

2
javamultithreadingconnection-poolingorientdborientdb2.2

2 Answers

2
votes

To work with a recyclable pool of instances with minimum 1, maximum 10 instances:

OrientGraphFactory factory = new OrientGraphFactory("plocal:/temp/mydb").setupPool(1, 10);

Once the factory is configured you can get a Graph instance to start working. OrientGraphFactory has 2 methods to retrieve a Transactional and Non-Transactional instance:

OrientGraph txGraph = factory.getTx();

OrientGraphNoTx noTxGraph = factory.getNoTx();

Hope it helps.

0
votes

If you use the document API, OPartitionedDatabasePool is the pool of your choice. Note that this is the pool implementation used internally by OrientGraphFactory.