Hi Sathwik, I've run with Postgres with hibernate well for a couple of days, and delete my file and configuration of Postgres and openjpa. I may try to reproduce the problem next week. If the problem occurs again, I'll file a Jira and inform you of the issue.
Regards, Vito At 2014-04-21 15:28:48,"Sathwik B P" <[email protected]> wrote: >Hi Vito, > >Can you file a Jira for Postgres with openjpa. >Kindly include your configurations for bitronix, ode-axis2.properties along >with exact version of ODE, Postgres used and if possible the process >definition. Also the description of the problem you faced. > >Let me try replicating the environment. > >regards, >sathwik > > >On Mon, Apr 21, 2014 at 9:55 AM, Vito <[email protected]> wrote: > >> 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 >> >> >>
