Sathwiki, nice to greet you again. Thanks for your time and orientation. I followed the link (https://github.com/vanto/apache-ode-tomcat-bundle) and my needs are solved! (close issue??) It's mean that i can redirect persistence from embed derby db to a mysql db.
But, no all my needs are satisfied. Specially one: response time of retrive state of process it's no the best. the scenario is: with 999 completed instances, and 99 actives, retrieve listInstances and then getScopeInfoWithActivity takes aprox 47 seconds! (even using filter='status=active') one approach to decrease the response time, is don't use a pmapi via web services, and query directly a persistence, but, i can't find in the schema (ode-1.3.4-hib-mysql55.sql) the scope info of a instances. I hope ypu can help me, and give some orientation (may be a new issue) Best regards Sathwik B P wrote > Hi Gabriel, > > I don't understand what are you trying to do. > > If you are trying to migrate from 1.3.2 to 1.3.6 > > Kindly follow the database migration first > http://ode.apache.org/upgrading-ode.html > > Then you need to use a TM instead of configuring a datasource in tomcat as > suggested in the link that I have shared. > > Kindly create separate posts for different problems. > > > On Thu, Jan 30, 2014 at 9:40 PM, gabriel < > gabriel.estivales@ > >wrote: > >> dear ODERes >> >> trying with mysql 5.5, tomcat7 and ODE 1.3.2 (with respective schema) >> works >> fine. >> >> I suspects that problem is in 1.3.6 version of ODE. >> >> additional information: from 1.3.2 to 1.3.6, pmapi doesn't work exactly, >> e.g.: >> >> calling listInstances, from php code with: >> >> >> $parameters = array( >> 'filter'=>'status=ACTIVE iid='.(string)$pid, >> 'order'=>'', >> 'limit'=>'99999'); >> >> works fine in 1.3.6, but in 1.3.2, it results with the follow error: >> java.lang.NumberFormatException: For input string: "status=ACTIVE; >> iid=251" >> >> some ideas? >> >> i hope 1.3.6 version can work with mysql soon! >> >> >> >> -- >> View this message in context: >> http://apache-ode.996305.n3.nabble.com/no-new-deploys-with-ode-mysql-tp17020p17023.html >> Sent from the Apache Ode Dev mailing list archive at Nabble.com. >> -- View this message in context: http://apache-ode.996305.n3.nabble.com/no-new-deploys-with-ode-mysql-tp17020p17036.html Sent from the Apache Ode Dev mailing list archive at Nabble.com.
