POS Hangs on processing sales

[ian tabangay]

Hi. I was playing around with the demo POS component that came with the
Ofbiz distribution (R651079). At first i was testing it using derby as my
database (the default configuration) and it worked fine. But when i tested
it using Postgresql 8.0, the POS hangs on processing sales. Here's where the
log stops:

*--- snip ---*
2008-05-13 13:02:52,109 (Thread-67) [      EntityEcaRule.java:128:INFO ]
Running Entity ECA Service: issueImmediatelyFulfilledOrder, triggered by
rule on Entity: OrderHeader
2008-05-13 13:02:52,203 (Thread-67) [                Log.java:94 :INFO ] Not
issuing inventory for orderId RSCO10040, no inventory information available.
2008-05-13 13:02:52,218 (Thread-67) [     ServiceEcaRule.java:133:INFO ] For
Service ECA [changeOrderStatus] on [commit] got false for condition:
[statusId][equals][ORDER_CANCELLED][true][String]
2008-05-13 13:02:52,218 (Thread-67) [     ServiceEcaRule.java:150:INFO ]
Running Service ECA Service: resetGrandTotal, triggered by rule on Service:
changeOrderStatus
2008-05-13 13:02:52,250 (Thread-67) [     ServiceEcaRule.java:150:INFO ]
Running Service ECA Service: sendOrderCompleteNotification, triggered by
rule on Service: changeOrderStatus
2008-05-13 13:02:52,671 (org.ofbiz.service.job.JobPoller@b6548) [
GenericDispatcher.java:59 :INFO ] Creating new dispatcher [JobDispatcher]
(org.ofbiz.service.job.JobPoller@b6548)
2008-05-13 13:02:52,671 (org.ofbiz.service.job.JobPoller@b6548) [
ServiceDispatcher.java:169:INFO ] Registered dispatcher: JobDispatcher
2008-05-13 13:02:52,671 (org.ofbiz.service.job.JobPoller@b6548) [
GenericDispatcher.java:129:INFO ] [LocalDispatcher] : Created Dispatcher
for: JobDispatcher
*--- ends here ---*

The only change that i did were the datasource name for delegators "default"
and "default-no-eca". Here's a snippet of my entityengine.xml:

*--- snip ---*
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
    <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
    <group-map group-name="org.ofbiz.olap"
datasource-name="localpostgresolap"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
    <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
    <group-map group-name="org.ofbiz.olap"
datasource-name="localpostgresolap"/>
</delegator>
*--- snip ---
*
No change has been done on the "localpostgres" datasource definition other
than the database's user and password. "localpostgresolap" is a copy of
"localpostgres" but uses a different database.

Thanks in advance for any ideas.


~ ian