Xpages and OrientDB - how to handle connection object properly?

Question

We would like to involve OrientDB (http://www.orientechnologies.com/) into the one of our Xpages projects. It suites well for our purposes using DocumentDatabase part of OrientDB.

Here we found a problem of how to deal with connection object. Instead of connecting and disconnecting manualy on every request we would like to use some shared connection for entire application. Documentation talks about it here https://github.com/orientechnologies/orientdb/wiki/Java-Web-Apps but its servlet filter, which is not suitable for Domino. Is there anyone having solution working properly with Domino and Xpages?

Answer 1

You need to write a custom datasource and within this datasource handle to connection pooling look at this presentation http://www.slideshare.net/NotesSensei/show107-the-datasource-session-take-xpages-data-boldly-where-no-xpages-data-has-been-taken-before

or check how it's done within the extension library sources. http://extlib.openntf.org/

a post about the connecting to jdbc using java http://lazynotesguy.net/blog/2013/08/09/subclassing-an-extlib-component/