Re: Management API issue while using ODE with mysql

Hi Alexis, Now that I am able to run ODE with mysql and hibernate, I like to know the issue with JPA dao implementation. I read from one of the threads in the mailing lists (link to thread) that hib

Re: Management API issue while using ODE with mysql

Hi Alexis, Thanks for this. I am able to generate the schema for mysql. Here are my observations which may be helpful to others. STORE_ table schemas are not included in the mysql.sql file. I have used store.sql to create these tables. I had to modify this sql file a bit to make it work on mysql

Re: Management API issue while using ODE with mysql

done in trunk as well. Alexis On Tue, Jan 6, 2009 at 10:59 AM, Alexis Midon wrote: > The Rakefile can generate the schema for you, I just added added mysql to > the list of databases (in branch 1.X). > If you're using a subversion checkout, simply update. Otherwise edit the > Rakefile and appl

Re: Management API issue while using ODE with mysql

The Rakefile can generate the schema for you, I just added added mysql to the list of databases (in branch 1.X). If you're using a subversion checkout, simply update. Otherwise edit the Rakefile and apply the patch manually. http://svn.apache.org/viewvc?view=rev&revision=732052 Then, after a build

Re: Management API issue while using ODE with mysql

Hi Alexis, I did a rake build to generate schemas using dao-hibernate-db module. However it doesn't generate schema for mysql. It generated for oracle, derby, hsql, firebird, postgres and sqlserver. I took derby.sql and modified the schema to make it work on mysql database. However I am getting th

Re: Management API issue while using ODE with mysql

Hi Alexis, Thanks for your reply. Good to know that JPA and hibernate uses different database schemas. Where can I find the sql statements to create hibernate compliant tables in mysql? Can you also please let me know why org.apache.ode.dao.jpa.BPELDAOConnectionImpl class doesn't implement bp

Re: Management API issue while using ODE with mysql

Hi Nagendra, you're getting that error because you cannot use Hibernate with a JPA database schema. Schemas are not the same for Hibernate and JPA. So to fix your issue, you have to point ODE to a database containing the Hibernate data model. The schemas files are generated by the module "dao-hib

Management API issue while using ODE with mysql

Hi, I am using ODE with mysql database. My ode-axis2.properties file has the following settings: ode-axis2.db.mode=EXTERNAL ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ODEDB Everything works fine with these settings. However when I try to use management API to receive events, I get the foll