1 Reply Latest reply on Feb 26, 2010 8:41 AM by Gert Vanthienen

    ODE External Data Source

    Massimiliano Andriotto Newbie

      I'm using FUSE ESG 4.2.0-fuse with ODE feature installed.

      I want  ODE uses Oracle database instead of derby DB.I created the configuration file

      org.apache.ode.jbi.cfg with these parameters:

       

      ode-jbi.db.mode=EXTERNAL

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

      ode-jbi.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl

      ode-jbi.db.emb.name=hibdb

       

      ode-jbi.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl

       

      Now I need to configure the datasource and register it inside a jndi service. How can I configure the datasource and register it inside a jndi service?

       

      Thank you

       

      Massimiliano

        • 1. Re: ODE External Data Source
          Gert Vanthienen Novice

          Massimiliano,

           

          One option would be to create the datasource instance from e.g. a blueprint file and publish the instance in the OSGi service registry.

           

          ServiceMix 4.2.0 will allow you to get a reference to that instance in your org.apache.ode.jbi.cfg file with a special kind of JNDI URL: osgi:services/javax.sql.DataSource

           

          If you have multiple DataSource implementations in the OSGi Service Registry, you can append a filter to the URL that looks like an LDAP filter (something like (&(key=value))

           

          Regards,

           

          Gert

           

          Edited by: gertv on Feb 26, 2010 2:41 PM