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