Hi Sathwik,
Thank you for your reply. I'm working on both Mysql and Postgres. The problem with isolation level happened on Postgres with openjpa. I tried the explicit setting of the isolation level, but it didn't solve the problem. So I used hibernate both on Mysql and Postgres. I slowed down all the requests on both databases, and they succeeded to function well most of the time except for some transaction-intensive periods. regards, Vito At 2014-04-18 13:33:24,"Sathwik B P" <[email protected]> wrote: >Hi Vito, > >I was on vacation and hence could not respond. > >Are you on Mysql or Postgres? > >I suspect that bitronix might be using the default isolation setting of the >underlying database. Try with explicit setting of the isolation level in >resource.properties file and let us know how it goes. > >regards, >sathwik > > >On Thu, Mar 27, 2014 at 10:38 PM, Tammo van Lessen <[email protected]>wrote: > >> Hi Vito, >> >> the PMAPI runs in a transaction as well, but actually I should run smoothly >> between process instances. Are your instances long or short running? Are >> you using a synchronous request response operation? Without the transaction >> manager you will probably run into weird situations like race conditions >> when using message correlation, so this is actually not an option. >> >> Best, >> Tammo >> >> >> On Thu, Mar 27, 2014 at 9:26 AM, Vito <[email protected]> wrote: >> >> > Hi all, >> > >> > These days I tried to invoke listInstancesSummary functions of Management >> > API after invoke many instances, but the functions were all blocked until >> > all the instances ran to the end. I thought of abandoning the bitronix >> > transaction manager, and it works. The functions are not blocked any >> more. >> > Do you know why bitronix block my functions, and can I do some >> modification >> > to the bitronix configuration in ODE? >> > >> > Regards, >> > Vito >> > >> > >> > >> > >> > >> > >> > At 2014-03-25 19:54:51,Vito <[email protected]> wrote: >> > >Hi Sathwik, >> > > >> > >Actually I did not solve the problem of combining openjpa and >> postgresql, >> > and the two communities also did not give me much information of the >> > problem. What I do is to use hibernate DAO to combine ODE and postgresql, >> > and it's working just fine. >> > > >> > >The listInstancesSummary function is already in the Management API. I >> > just invoked it and found it blocked sometimes when I had many instances >> > running. After looking into the ODE source code, I find that the function >> > listAllInstances() actually have little difference from >> > listInstancesSummary(), while the former function have few filters than >> the >> > latter. >> > > >> > >Have you met with the problem that the Management API be blocked? I >> think >> > it may be caused by some transaction problems. >> > > >> > >Regards, >> > >Vito >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > >At 2014-03-25 17:02:24,"Sathwik B P" <[email protected]> wrote: >> > >>Vito, >> > >> >> > >>Good to know you could solve the issue with Postgresql. It would be >> great >> > >>if you could help the community know about the changes you did to make >> it >> > >>work :) >> > >> >> > >>You might have a look at listAllInstances which will list all the >> > instances. >> > >> >> > >>What is the query that used in listInstancesSummary? >> > >> >> > >>regards, >> > >>sathwik >> > >> >> > >> >> > >>On Tue, Mar 25, 2014 at 11:33 AM, Vito <[email protected]> wrote: >> > >> >> > >>> Hi all, >> > >>> Thank you for your kindly help these days. I just make ODE up and >> > running >> > >>> with mysql and postgresql finally! But when I try some experiments, >> > other >> > >>> problems seem to come up. Actually, it may not be called an error >> > because >> > >>> there is no error or exception. >> > >>> The problem came out when I ran multiple instances. It met no problem >> > >>> until I try to list instances summary from ODE Management API to get >> > the >> > >>> instance number in the engine. The list function returned no results >> > until >> > >>> all the instances ran to the end. I think it may be blocked by the >> > >>> transactions of running instances. >> > >>> Do you think the transactions really block the management api >> > function? If >> > >>> this really happens, how can I get the number of instance number of >> the >> > >>> current engine? >> > >>> Best, >> > >>> Vito >> > >>> >> > >> >> >> >> -- >> Tammo van Lessen - http://www.taval.de >>
