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