Title: Using a JNDI datasource under ServiceMix JBI
Category: documentation

## Overview

These instructions will help you configure a JNDI DataSource for Apache ODE when running inside the ServiceMix JBI container.

<a name="UsingaJNDIdatasourceunderServiceMixJBI-1.Edit-SERVICEMIX/conf/jndi.xml"></a>
## 1. Edit $SERVICEMIX/conf/jndi.xml

Declare a managed connection factory pointing to your database:

    :::xml
    <bean id="odeManagedConnectionFactory" class="org.jencks.tranql.DataSourceMCF">
        <property name="driverName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://hostname/databaseName"/>
        <property name="user" value="username"/>
        <property name="password" value="myPassword"/>
    </bean>



And register the DataSource in the JNDI registry by adding an `<entry>` under the `<util:map>` element:

    :::xml
    <util:map id="jndiEntries">

        <!-- ODE DataSource -->
        <entry key="java:comp/env/jdbc/ode">
            <bean id="odeDataSource" class="org.jencks.factory.ConnectionFactoryFactoryBean">
                <property name="managedConnectionFactory" ref="odeManagedConnectionFactory"/>
                <property name="connectionManager" ref="connectionManager"/>
            </bean>
        </entry>

        <!-- ... other entries follow... -->

    </util:map>



<a name="UsingaJNDIdatasourceunderServiceMixJBI-2.Editode-jbi.properties"></a>
## 2. Edit ode-jbi.properties

In ode-jbi.properties, set the following properties:

    :::properties
    ode-jbi.db.mode=EXTERNAL
    ode-jbi.db.ext.dataSource=java:comp/env/jdbc/ode


(Be sure to match the JNDI lookup name to the one defined in $SERVICEMIX/conf/jndi.xml)

<a name="UsingaJNDIdatasourceunderServiceMixJBI-3.Addjencks-2.0-alllibrary"></a>
## 3. Add jencks-2.0-all library

Copy [jencks-2.0-all.jar](http://repository.codehaus.org/org/jencks/jencks/2.0/jencks-2.0-all.jar) under $SERVICEMIX/lib

<a name="UsingaJNDIdatasourceunderServiceMixJBI-4.RestartServiceMix"></a>
## 4. Restart ServiceMix

And you're done!   Don't forget to redeploy your service assemblies since they need to be re-synchronized with ODE.

<a name="UsingaJNDIdatasourceunderServiceMixJBI-Extras"></a>
## Extras

<a name="UsingaJNDIdatasourceunderServiceMixJBI-ConnectionPoolParameters"></a>
### Connection Pool Parameters

If you want to manually configure the connection pool parameters, edit $SERVICEMIX/conf/tx.xml and update the "poolingSupport" object.  For example,

    :::xml
    <jencks:poolingSupport id="poolingSupport"
        connectionMaxIdleMinutes="5"
        connectionMaxWaitMilliseconds="10000"
        poolMaxSize="100"
        poolMinSize="20" />