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é
> > >
> >
>

Reply via email to