orientdb-javaee

This project is an utilities set to use OrientDB in a JavaEE environment. Basically it solve 3 problems:

• Injecting the database instance.
• Handle the database connection for request.
• To avoid serialization issues it automatically detach the objects when return from a resource method (annotated wiht @GET, @POST, etc...)

This project was originally built to work with Jackson and RestEasy, but you can adapt to your needing.

If you want to create an application using this library you can use https://github.com/jesty/orientdb-microservices

Using this library, you can inject the database instance in your classes:

@Inject
OObjectDatabaseTx db;

And when you do a query, you don't need to detach the object:

@GET
public List<Chat> getAll()
{
  return db.command(new OSQLSynchQuery<Chat>("select * from Example")).execute();
}

Configuration

Download the source and install in your local repository using Maven

mvn install

Add the dependency to your pom file:

<dependency>
    <groupId>com.nutcore</groupId>
    <artifactId>orientdb-javaee</artifactId>
    <version>1.0</version>
</dependency>

Configure a provider that supports the conversion of a OrientDB proxed object to a stream.

ResteasyDeployment deployment = new ResteasyDeployment();
deployment.setProviderClasses(Arrays.asList(OrientDBJacksonProvider.class.getName()));

Add the servlet Filter in order to handle the database connection. Furthermore the database connection is also stored in a thread local, so you can inject or retrieve it using OrientDBUtil.getDatabase() static method.

deploymentInfo.addFilter(new FilterInfo("/api", OrientDBFilter.class))
.addFilterUrlMapping("/api", "/*", DispatcherType.REQUEST);

Create a properties file named orientdb.properties and configure the properties below.

orientdb.entitymanager.packagename=com.example.domain
orientdb.database.password=root
orientdb.database.username=root
orientdb.database.url=remote:localhost/yourdatabase

If you want to run OrientDB Server as embedded you must add this servlet listener:

deploymentInfo.addListener(Servlets.listener(OrientDBServletContextListener.class))

Create a db.config.xml file (in example folder there is a sample) in your classpath and use plocal protocol to connect to the database:

orientdb.database.url=plocal:your_database_folder/exampledb