You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by gabriel <ga...@gmail.com> on 2014/01/29 20:20:11 UTC
no new deploys, with ode+mysql
hi friends, pleasure to greet you.
I'm new in ode.
i can deploy somes process using embed derby db, but when i try to point ode
persistence to mysql, without errors, my processes disappears, and new
process can't deployed.
i'm ussing bellow configuration:
<Context path="/ode" docBase="ode" debug="5" reloadable="true"
crossContext="true">
<Resource name="jdbc/ODEDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
</Context>
in server.xml->host
ode database exist, schema with: ode-1.3.4-jpa-mysql55.sql
, and
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ODEDB
in ode-axis2.properties under webapps/ode/WEB-INF/conf
i restart catalina without errors/problems
catalina.out don't say me any error/trouble. when i restart tomcat, the logs
don't reports no ode services starts.
any idea can help me?
tomcat 7.0.4, mysql 5.5, ubuntu 12.04, openjdk7.
i hope your response. best regards friends!
--
View this message in context: http://apache-ode.996305.n3.nabble.com/no-new-deploys-with-ode-mysql-tp17020.html
Sent from the Apache Ode Dev mailing list archive at Nabble.com.
Re: no new deploys, with ode+mysql
Posted by 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.
Re: no new deploys, with ode+mysql
Posted by Sathwik B P <sa...@gmail.com>.
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 <ga...@gmail.com>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.
>
Re: no new deploys, with ode+mysql
Posted by gabriel <ga...@gmail.com>.
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.
Re: no new deploys, with ode+mysql
Posted by Sathwik B P <sa...@gmail.com>.
No more use of datasource configured with tomcat.
You need to embed a transaction manager (bitronix or any TM of your choice)
within tomcat and hence shared the link which does it.
On Thu, Jan 30, 2014 at 6:38 PM, gabriel <ga...@gmail.com>wrote:
> Thanks for your attention Sathwik.
>
> Before use your suggestions, i need configure apache ode with mysql.
>
> I note/look (in catalina.out) that, when "Add the following stanza to
> conf/server.xml inside the <Host> element:
> <Context path="/ode" docBase="ode" debug="5" reloadable="true"
> crossContext="true">
> <Resource name="jdbc/ODEDB" auth="Container"
> type="javax.sql.DataSource"
> maxActive="100" maxIdle="30" maxWait="10000"
> username="root" password="pass"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
> </Context>, "
>
> ode.war don't deploy! (catalina.out simply don't say nothin about it)
>
> but, when i comment <context> element, all works fine!! what can be
> happening?
>
>
>
> --
> View this message in context:
> http://apache-ode.996305.n3.nabble.com/no-new-deploys-with-ode-mysql-tp17020p17022.html
> Sent from the Apache Ode Dev mailing list archive at Nabble.com.
>
Re: no new deploys, with ode+mysql
Posted by gabriel <ga...@gmail.com>.
Thanks for your attention Sathwik.
Before use your suggestions, i need configure apache ode with mysql.
I note/look (in catalina.out) that, when "Add the following stanza to
conf/server.xml inside the <Host> element:
<Context path="/ode" docBase="ode" debug="5" reloadable="true"
crossContext="true">
<Resource name="jdbc/ODEDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
</Context>, "
ode.war don't deploy! (catalina.out simply don't say nothin about it)
but, when i comment <context> element, all works fine!! what can be
happening?
--
View this message in context: http://apache-ode.996305.n3.nabble.com/no-new-deploys-with-ode-mysql-tp17020p17022.html
Sent from the Apache Ode Dev mailing list archive at Nabble.com.
Re: no new deploys, with ode+mysql
Posted by Sathwik B P <sa...@gmail.com>.
Kindly follow the instructions if you want a packaged deployment.
Apache ODE Tomcat Bundle <https://github.com/vanto/apache-ode-tomcat-bundle>:
Build script that creates a fully configured bundle with Tomcat 7, Apache
ODE, Hibernate and Bitronix.
On Thu, Jan 30, 2014 at 12:50 AM, gabriel <ga...@gmail.com>wrote:
> hi friends, pleasure to greet you.
>
> I'm new in ode.
>
> i can deploy somes process using embed derby db, but when i try to point
> ode
> persistence to mysql, without errors, my processes disappears, and new
> process can't deployed.
>
> i'm ussing bellow configuration:
>
> <Context path="/ode" docBase="ode" debug="5" reloadable="true"
> crossContext="true">
> <Resource name="jdbc/ODEDB" auth="Container"
> type="javax.sql.DataSource"
> maxActive="100" maxIdle="30" maxWait="10000"
> username="root" password="pass"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
> </Context>
>
> in server.xml->host
>
> ode database exist, schema with: ode-1.3.4-jpa-mysql55.sql
>
> , and
>
> ode-axis2.db.mode=EXTERNAL
> ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ODEDB
>
> in ode-axis2.properties under webapps/ode/WEB-INF/conf
>
> i restart catalina without errors/problems
>
> catalina.out don't say me any error/trouble. when i restart tomcat, the
> logs
> don't reports no ode services starts.
>
> any idea can help me?
>
> tomcat 7.0.4, mysql 5.5, ubuntu 12.04, openjdk7.
>
> i hope your response. best regards friends!
>
>
>
> --
> View this message in context:
> http://apache-ode.996305.n3.nabble.com/no-new-deploys-with-ode-mysql-tp17020.html
> Sent from the Apache Ode Dev mailing list archive at Nabble.com.
>