Hi Florian,
What is the situation now?
TIA
Jacques
Le 28/10/2025 à 11:33, Florian Motteau a écrit :
Hi all,
I've been investigating a strange issue when running tests with OFBiz lately.
I'm running tests using Derby, through such commands : ./gradlew 'ofbiz -t
component=salesBU -t case=generateRecurrenceDate' --debug-jvm
So I'm using the "test" delegator, which uses the embedded Derby database.
In the logs, I noticed that OFBiz tries to connect to a postgresql datasource, which is not available. I found that it tries to connect to the
"default" delegator (group-name=org.apache.ofbiz). This connection fails while trying to delete ServiceSemaphore :
2025-10-28 10:27:50,542 |OFBiz-batch-4 |GenericDelegator |E| Failure in removeByCondition operation for entity [ServiceSemaphore]:
org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (Unable to establish a connection with
the database. (Unable to acquire a new connection from the pool)). Rolling back transaction.
org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (Unable to establish a connection with
the database. (Unable to acquire a new connection from the pool))
After some investigations, I found that, as far as I understand, OFBiz will force the use the "default" delegator whenever the
EntityExpr::makeWhereString is used. This method calls EntityExpr::checkRhsType, with "null" a second parameter, which causes "checkRhsType" to
fallback to the "default" delegator.
https://github.com/apache/ofbiz-framework/blob/82ed9a8d4dbf3259cb3d8bc219d36206d160b339/framework/entity/src/main/java/org/apache/ofbiz/entity/condition/EntityExpr.java#L199
At some point I thought that it was be related to the events, but I'm not sure
anymore :).
My goal was to find out why this connection was attempted during tests (and
clean my logs files), but I feel that it may be a bigger issue.
Is this behavior correct/intented ? Why would we choose a different delegator
in a method which role is to construct a SQL request ?
Thank you in advance for any feedback/guidance
Florian
