topic Selecting subscribers to a signal is not working in Postgres in Alfresco Archive

Selecting subscribers to a signal is not working in Postgres

jwestra — Wed, 18 May 2016 21:46:12 GMT

Hi!I have a process definition with a SignalStartEvent. When I execute signal received on it using the "in-memory DB", an event subscriber is found and fired, starting the process. However, when I run the application under Postgres using the same process definition, the query returns zero rows for

Re: Selecting subscribers to a signal is not working in Postgres

jwestra — Thu, 19 May 2016 00:24:39 GMT

I spun up a MySQL on AWS and tested against it as well. It runs fine. That makes H2 and MySQL as working fine. So, something is amiss in the way the Postgres DB is handling the PreparedStatement markers ("?") for this particular query.

Re: Selecting subscribers to a signal is not working in Postgres

jbarrez — Thu, 26 May 2016 13:25:10 GMT

That sounds _very_ odd … do you have a simple unit test that demonstrates this problem on postgres?

Re: Selecting subscribers to a signal is not working in Postgres

jwestra — Thu, 26 May 2016 14:12:50 GMT

Joram,

My team is under a tight deadline until mid-June. We definitely want Postgres long-term, so I will re-visit it and post a junit at that time. We have a reasonable workaround using MySQL until then.

Jason

Re: Selecting subscribers to a signal is not working in Postgres

jbarrez — Thu, 02 Jun 2016 17:49:16 GMT

ok, thanks.