Re: no new deploys, with ode+mysql

[gabriel <ga...@gmail.com>]

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.