0 Replies Latest reply on Oct 18, 2010 9:22 AM by prasadbirje

    Issues configuring BPEL persistence

    prasadbirje

      Hi,

       

      I am in the process of configuring BPEL persistence for ODE hosted on FUSE ESB. I have performed following steps to configure the database.

       

      1. Created a MySQL database named ode.

      2. Populated the ode database by using the mysql.sql script file available as part of the Apache ODE 1.3.4.

      3. Copied the MySQL Connector jar file to FUSE ESB lib directory.

      4. Modified org.apache.ode.jbi.properties file to configure the database.

      ode-jbi.db.mode=EXTERNAL

      ode-jbi.db.int.jdbcurl=jdbc:mysql://localhost:3306/ode?user=root&password=atos123&autoReconnect=true

      ode-jbi.db.int.driver=com.mysql.jdbc.Driver

       

      5. Restarted FUSE ESB.

       

      Upon restart I get following error in the log files.

       

      org.apache.servicemix.nmr.osgi - 1.3.0.fuse-00-00 | ServiceEvent REGISTERED

      14:56:58,437 | ERROR | ExtenderThread-6 | OdeLifeCycle                     | org.apache.ode.jbi.OdeLifeCycle   191 | 195 - ode-jbi-bundle - 1.3.4 | Database configuration error.

      org.apache.ode.il.dbutil.DatabaseConfigException: Failed to resolved external DataSource at "java:comp/env/jdbc/ode".     at org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:166)[195:ode-jbi-bundle:1.3.4]

           at org.apache.ode.il.dbutil.Database.initDataSource(Database.java:146)[195:ode-jbi-bundle:1.3.4]

           at org.apache.ode.il.dbutil.Database.start(Database.java:100)[195:ode-jbi-bundle:1.3.4]

           at org.apache.ode.jbi.OdeLifeCycle.initDataSource(OdeLifeCycle.java:188)[195:ode-jbi-bundle:1.3.4]

       

      Caused by: javax.naming.NotContextException: java:comp/env/jdbc/ode

      *     at org.apache.xbean.naming.context.AbstractContext.lookup*(AbstractContext.java:171)[76:org.apache.servicemix.naming:1.3.0.fuse-00-00]

           at org.apache.xbean.naming.context.AbstractContext.lookup(AbstractContext.java:611)[76:org.apache.servicemix.naming:1.3.0.fuse-00-00]

       

      Am I missing any steps?

       

      Regards,

      Prasad