Framework Integration - NuoDB

This page is for internal use only.  It describes procedures used to test ABL and Openxava with NuoDB.

Versions

These instructions pertain to NuoDB Beta 8, OX 4.5.  These instructions were built for a Mac.

Installation

Install NuoDB - accept the standard locations.

Install BusLogicOX Quick Start, and verify operation for hsql.

Configuration

Re-configure the installed app as described below to use NuoDB.

Install Database drivers

Copy /opt/nuodb/jar/nuodbjdbc.jar ==> OX/Tomcat/lib

Copy /opt/nuodb/jar/nuodb-hibernate-1.0.jar ==> BusLogicOXQuickStart/web/WEB-INF/lib

Configure OX

Update persistence.xml with

           <property name="hibernate.dialect" value="com.nuodb.hibernate.NuoDBDialect"/>

Update hibernate-cfg.xml with

       <property name="hibernate.dialect">com.nuodb.hibernate.NuoDBDialect</property>

Update servers/context.xml with

<!-- nuodb -->

<Resource

    name="jdbc/BusLogicOXQuickStartDS" 

    auth="Container" 

    type="javax.sql.DataSource"

    maxActive="20" 

    maxIdle="5"

    maxWait="10000"

    username="dba"

    password="goalie"

    driverClassName="com.nuodb.jdbc.Driver"

    url="jdbc:com.nuodb://localhost/test?schema=abt"

/>

Admin

To start NuoDB on a Mac, presuming the default install location:

cd /opt/nuodb
./run-quickstart


This will start the sql command line processor, which you can use, then exit (this does not stop the server).


NuoDB provides a console, which you can use to stop the server.

java -jar /opt/nuodb/jar/nuodbconsole.jar
Then Discover Domains (default password is bird).

You can stop the server by opening a domain, select the Chorus, and select Shutdown Process from the left nav menu.



Comments