Hi Michael,
Could you please take a look at http://abdulkadiryaman.blogspot.com/2011/07/servicemix-43-ode-backed-by-mysql.html?m=1and tell me if this one is what you are looking for? On Aug 14, 2011 1:24 AM, "Michael Smith" <[email protected]> wrote: > Hi, > > I've compiled ode trunk and deployed it successfully to ServiceMix 4.3 > and 4.4 on Linux. I'm using PostgreSQL as the database - I added an OSGi > fragment to pull in the dependency on org.tranql.connector.postgresql. > > With SMX 4.4 on Windows, using the same bundle binaries and > org.apache.ode.jbi.cfg, ode is trying to use the internal derby database > for some reason. Here's my config file: > > ################### > # C:\ServiceMix44\etc\org.apache.ode.jbi.cfg > ode-jbi.db.mode=INTERNAL > > ode-jbi.db.int.mcf=org.tranql.connector.postgresql.PGXAMCF > ode-jbi.db.int.mcf.databaseName=odedev > ode-jbi.db.int.mcf.userName=ode > ode-jbi.db.int.mcf.password=XXXXXXX > ode-jbi.db.int.mcf.serverName=w.x.y.z > > # Default is to use JPA > (org.apache.ode.dao.jpa.BPELDAOConnectionFactoryImpl) > # http://ode.apache.org/smx4-osgi-deployment.html recommends using > # (older) Hibernate code instead > ode-jbi.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl > > ode-jbi.event.listeners=org.apache.ode.bpel.common.evt.DebugBpelEventListener > ################### > > The properties show up in config:list on the ServiceMix console: > > ---------------------------------------------------------------- > Pid: org.apache.ode.jbi > BundleLocation: file:/C:/ServiceMix44/deploy/ode-jbi-bundle-1.4-SNAPSHOT.jar > Properties: > ode-jbi.event.listeners = > org.apache.ode.bpel.common.evt.DebugBpelEventListener > ode-jbi.db.mode = INTERNAL > service.pid = org.apache.ode.jbi > felix.fileinstall.filename = > file:/C:/ServiceMix44/etc/org.apache.ode.jbi.cfg > ode-jbi.dao.factory = > org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl > ode-jbi.db.int.mcf = org.tranql.connector.postgresql.PGXAMCF > ode-jbi.db.int.mcf.userName = ode > ode-jbi.db.int.mcf.password = XXXXXXX > ode-jbi.db.int.mcf.databaseName = odedev > ode-jbi.db.int.mcf.serverName = w.x.y.z > ---------------------------------------------------------------- > > Below is a snippet from the logs showing ODE trying to use Derby instead > of PostgreSQL. Any ideas where to look next? I'm new to ODE and > ServiceMix, and troubleshooting anything under Windows feels like > breathing underwater. > > 2011-08-12 18:37:27,697 DEBUG [SpringOsgiExtenderThread-20] > (TempFileManager.java:113) - Setting base working directory: > C:\ServiceMix44\data\jbi\OdeBpelEngine\workspace > 2011-08-12 18:37:27,697 DEBUG [SpringOsgiExtenderThread-20] > (OdeLifeCycle.java:118) - Applying properties. > 2011-08-12 18:37:27,713 DEBUG [SpringOsgiExtenderThread-20] > (OdeLifeCycle.java:122) - Initializing message mappers. > 2011-08-12 18:37:27,713 DEBUG [SpringOsgiExtenderThread-20] > (OdeLifeCycle.java:125) - Creating data source. > 2011-08-12 18:37:27,713 INFO [SpringOsgiExtenderThread-20] > (InternalDB.java:101) - ODE using internal database > "jdbc:derby://localhost/ode" with driver org.apache.derby.jdbc.ClientDriver. > 2011-08-12 18:37:27,713 DEBUG [SpringOsgiExtenderThread-20] > (InternalDB.java:108) - Creating connection pool for > jdbc:derby://localhost/ode with driver org.apache.derby.jdbc.ClientDriver > 2011-08-12 18:37:27,713 ERROR [SpringOsgiExtenderThread-20] > (OdeLifeCycle.java:191) - Database configuration error. > java.lang.RuntimeException: TransactionManager is not recoverable. > at > org.apache.ode.il.dbutil.InternalDB.initInternalDb(InternalDB.java:110)[247:org.apache.ode.ode-jbi-bundle:1.4.0.SNAPSHOT] > at > org.apache.ode.il.dbutil.InternalDB.initDataSource(InternalDB.java:102)[247:org.apache.ode.ode-jbi-bundle:1.4.0.SNAPSHOT] > at > org.apache.ode.il.dbutil.InternalDB.start(InternalDB.java:61)[247:org.apache.ode.ode-jbi-bundle:1.4.0.SNAPSHOT] > at > org.apache.ode.jbi.OdeLifeCycle.initDataSource(OdeLifeCycle.java:188)[247:org.apache.ode.ode-jbi-bundle:1.4.0.SNAPSHOT] > at > org.apache.ode.jbi.OdeLifeCycle.init(OdeLifeCycle.java:126)[247:org.apache.ode.ode-jbi-bundle:1.4.0.SNAPSHOT] > at > org.apache.servicemix.jbi.deployer.artifacts.ComponentImpl$ComponentWrapper.init(ComponentImpl.java:247)[145:org.apache.servicemix.jbi.deployer:1.5.0.fuse-00-43] > > > Thanks, > Mike
