I tried ODE with MySQL. There is bug in the schema(I don't know whether it works with some MySQL versions). That's why the following error has occured.
Unsuccessful: create table LARGE_DATA (ID bigin t not null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK intege r not null, primary key (ID)) 15:13:55,148 ERROR [SchemaUpdate] Unsuccessful: create table LARGE_DATA (ID bigi nt not null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK integ er not null, primary key (ID)) ERROR - GeronimoLog.error(104) | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to us e near '2G), INSERT_TIME datetime, MLOCK integer not null, primary key (ID))' at line 1 If you remove '2G' part from schema it'll work well. I have tested this with 2000 instances. create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob (2G), INSERT_TIME datetime, MLOCK integer not null, primary key (ID)) Remove the highlighted part from the schema. It'll work. When you remove it'll be like this. create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)) Thanks, Milinda. On Thu, Dec 4, 2008 at 10:52 PM, Matthieu Riou <[email protected]>wrote: > On Wed, Dec 3, 2008 at 8:57 PM, Rosalin Pattnaik < > [email protected] > > wrote: > > > Hi, > > > > I was trying to run ode with MYSQL and hibernate using hibernate-3.25ga > > jars ,with the following entries in t i came across the following > exception > > while trying to deploy any process:he ode-axis.properties : > > > > ode-axis2.db.mode=EXTERNAL > > ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ODEDB > > > > > ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl > > hibernate.dialect=org.hibernate.dialect.MySQL5Dialect > > hibernate.hbm2ddl.auto = update > > hibernate.current_session_context_class=jta > > > > > hibernate.transaction.manager_lookup_class=org.apache.ode.daohib.HibernateTransactionManagerLookup > > > > But i came across an Exception .Please find the error stack in the > attached > > file. > > > > It's a bit unusual, are you deploying in Tomcat? Also has your Tomcat other > webapps installed and/or additional libraries than the standard ones in its > lib directories? I'm thinking of some Xerces version mismatch here. > > Thanks, > Matthieu > > > > > > > > Regards, > > Rosalin > > > -- http://mpathirage.com http://wso2.org "Oxygen for Web Service Developers" http://wsaxc.blogspot.com "Web Services With Axis2/C"
