Re: ODE 1.3.3 inside ServiceMix with Oracle DB

[Jean-Baptiste Onofré]

Hi Andriotto,

do you have any stack trace (deployment or runtime) ?

Thanks,
Regards
JB

Andriotto Massimiliano wrote:

I need to use ode-jbi.1.3.3 inside ServiceMix and I want to use Oracle
DB instead of DerbyDB but I have same difficult to configure the system.

Can someone help me?

I do this:

1) I added

jencks-2.0-all.jar

tranq-connector-1.4.jar

tranq-connector-oracle-common-1.4.jar

ojdbc-1.4.jar

To ServiceMix\lib

This is my jndi.xlm:

<beans xmlns:jencks="http://jencks.org/2.0";

       xmlns:amq="http://activemq.apache.org/schema/core";

       xmlns:amqra="http://activemq.apache.org/schema/ra";

       xmlns:util="http://www.springframework.org/schema/util";>

<bean id="odeManagedConnectionFactory"
class="org.tranql.connector.oracle.XAMCF">

    <property name="databaseName" value="SMM"/>

    <property name="userName" value="ode"/>

    <property name="password" value="ode"/>

    <property name="portNumber" value="1521"/>

    <property name="serverName" value="10.1.0.67"/>

    <property name="driverType" value="thin"/>

  </bean>

      <bean id="odeDataSource"
class="org.jencks.factory.ConnectionFactoryFactoryBean">

        <property name="managedConnectionFactory"
ref="odeManagedConnectionFactory"/>

        <property name="connectionManager" ref="connectionManager"/>

</bean>

  <bean id="jndi" depends-on="broker"

        class="org.apache.xbean.spring.jndi.SpringInitialContextFactory"


        factory-method="makeInitialContext"

        singleton="true">

    <property name="entries" ref="jndiEntries" />

  </bean>

  <util:map id="jndiEntries">

    <!-- PXE DB datasource -->

    <!--

    <entry key="java:comp/env/jdbc/pxe__pm">

      <bean class="org.hsqldb.jdbc.jdbcDataSource">

        <property name="database" value="jdbc:hsqldb:mem:pxe"/>

        <property name="user" value = "sa"/>

        <property name="password" value = ""/>

      </bean>

    </entry>

    -->

    <!-- wsn2005 jms connection factory -->

    <entry key="java:comp/env/jms/wsnotificationCF">

      <amq:connectionFactory brokerURL="${activemq.url}" />

    </entry>

    <!-- transaction manager -->

    <entry key="javax.transaction.TransactionManager"
value-ref="transactionManager" />

    <entry key="java:comp/env/smx/TransactionManager"
value-ref="transactionManager" />

    <!-- bootstrap context -->

    <entry key="java:comp/env/smx/BootstrapContext"
value-ref="bootstrapContext" />

    <!-- connection context -->

    <entry key="java:comp/env/smx/ConnectionManager"
value-ref="connectionManager" />

    <!-- Authentication service -->

    <entry key="java:comp/env/smx/AuthenticationService"
value-ref="authenticationService" />

    <!-- Keystore manager -->

    <entry key="java:comp/env/smx/KeystoreManager"
value-ref="keystoreManager" />

  </util:map>

  <!-- A managed JDBC DataSource for derby -->

  <!-- needs tranql derby

  <bean id="localDerbyMCF"
class="org.tranql.connector.derby.EmbeddedXAMCF">

    <property name="databaseName" value="data/derby"/>

    <property name="createDatabase" value="true"/>

  </bean>

  <bean id="localDerbyDataSource"
class="org.springframework.jca.support.LocalConnectionFactoryBean">

    <property name="managedConnectionFactory" ref="localDerbyMCF"/>

    <property name="connectionManager" ref="connectionManager"/>

  </bean>

  -->

  <!-- A managed JMS ConnectionFactory for ActiveMQ -->

<amqra:managedConnectionFactory

          id="activemqMCF"

          resourceAdapter="#activemqRA" />

<amqra:resourceAdapter

          id="activemqRA"

          serverUrl="vm://localhost"/>

<jencks:connectionFactory

          id="activemqCF"

          managedConnectionFactory="#activemqMCF"

          connectionManager="#connectionManager" />

</beans>

Thank you for any information

Massimiliano Andriotto