Yeah I agree with Yannick, stick with Axis2 as it's much easier to play with ODE in that mode. For your datasource problem it's quite simple. Create a file named ode-axis2.properties in the conf directory of the ODE war with this content:
ode-axis2.db.mode=EXTERNAL ode-axis2.db.ext.dataSource=java:/DSNAME Replace DSNAME with the JNDI name of the datasource you created in your application server. Additionally you can put something like: ode-axis2.tx.factory.class=org.apache.ode.axis2.util.JBossFactory The factory depends on which application server you're using. If you're using something like Jetty / Tomcat you don't need to declare any, ODE will use the same transaction manager as with Geronimo. If you're using another app server you have a choice: org.apache.ode.axis2.util.JBossFactory org.apache.ode.axis2.util.GeronimoFactory I'll update the Confluence pages you mentioned. Cheers, Matthieu On 4/13/07, yannick guionnet <[EMAIL PROTECTED]> wrote:
if you use axis, stay there cause it s much more tested. I really think it's easy as in ode you just have to set EXTERNAL mode and the name of datasource it's java:comp/env/jpadb on jbi, the property file must looks like ode-config.properties. 2007/4/13, René Bos <[EMAIL PROTECTED]>: > > Hmmm... I'm using Axis at the moment. So I think I have to configure it at > an other place. > With the Intalio BPMS we succeeded using MySQL, but with the current SVN > version I can't find the right place to change the Datasource. Maybe I have > to start using JBI... > > René > > -----Original Message----- > From: yannick guionnet [mailto:[EMAIL PROTECTED] > Sent: vrijdag 13 april 2007 15:20 > To: [EMAIL PROTECTED] > Subject: Re: MySQL database > > > I don't know what is you goal, but I could give you my experience: > I want to test ode-jbi with an external datasource and I didn't find real > scripts that works on the trunk so I setup a derby server with a fresh > jpadb > db directory : you can find it in the target of jbi, i make following > setting in jndi.xml (servicemix): > > <bean id="odeJpaManagedConnectionFactory" class=" > org.jencks.tranql.DataSourceMCF"> > <property name="driverName" value=" > org.apache.derby.jdbc.ClientDriver"/> > <property name="url" value="jdbc:derby://localhost/jpadb"/> > <property name="user" value="SA"/> > <property name="password" value="SA"/> > </bean> > > <util:map id="jndiEntries"> > <!-- Ode DataSource --> > <entry key="java:comp/env/jdbc/ode"> > <bean id="odeDataSource" class=" > org.jencks.factory.ConnectionFactoryFactoryBean"> > <property name="managedConnectionFactory" > ref="odeJpaManagedConnectionFactory"/> > <property name="connectionManager" ref="connectionManager"/> > </bean> > </entry> > ... > unfortunately the jca flow of smx raises an error, so I remove this flow > in > servicemix.xml > > and It's works with the 2 jbi samples (RPC doesnot works for unknown > reasons) > > sure the jca flow pb must be resolved but it's a step by step work,I > notice > also some warning from jpa queries with default settings ! > > hope it helps > > cheers > > > 2007/4/13, René Bos <[EMAIL PROTECTED]>: > > > > Yeah I saw those pages but it looks like they are very deprecated.. > There > > is no /etc folder and Ode now uses OpenJPA in place of Hibernate... > > > > -----Original Message----- > > From: yannick guionnet [mailto:[EMAIL PROTECTED] > > Sent: vrijdag 13 april 2007 14:51 > > To: [EMAIL PROTECTED] > > Subject: Re: MySQL database > > > > > > have a look at : > > http://incubator.apache.org/ode/databases.html > > and also > > > > > http://incubator.apache.org/ode/user-guide.html#UserGuide-UsingaJNDIDataSourceunderServiceMixJBI > > > > 2007/4/13, René Bos <[EMAIL PROTECTED]>: > > > > > > Hi!! > > > > > > I was wondering if it is possible in the current SVN version to change > > the > > > database from Derby tot MySQL. It need this because I want direct > > database > > > access via JDBC. If I'm right this is not possible with the embedded > > Derby > > > database. > > > > > > René > > > > > >