This is an automated email from the ASF dual-hosted git repository.
ashishvijaywargiya pushed a commit to branch trunk
in repository https://gitbox.apache.org/repos/asf/ofbiz-framework.git
The following commit(s) were added to refs/heads/trunk by this push:
new d1b76f06b2 OFBIZ-13412 - Updated the following:
d1b76f06b2 is described below
commit d1b76f06b226f40917cb95758fb2f3b4ffa9e487
Author: Ashish Vijaywargiya <[email protected]>
AuthorDate: Fri May 22 19:39:20 2026 +0530
OFBIZ-13412 - Updated the following:
Based on the recommendations to get optimised performance, changing the
pool-minsize value to 2 same as we have this parameter value for Postgres and
MySQL. And adding CACHE_SIZE=65536 (64MB) for the h2 URI as this is also
recommended for optimised performance of the database.
---
framework/entity/config/entityengine.xml | 16 ++++++++--------
1 file changed, 8 insertions(+), 8 deletions(-)
diff --git a/framework/entity/config/entityengine.xml
b/framework/entity/config/entityengine.xml
index 47cfeb5340..61aa972600 100644
--- a/framework/entity/config/entityengine.xml
+++ b/framework/entity/config/entityengine.xml
@@ -179,11 +179,11 @@ access. For a detailed description see the
core/docs/entityconfig.html file.
<inline-jdbc
jdbc-driver="org.h2.Driver"
-
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE
SCHEMA IF NOT EXISTS OFBIZ\;SET SCHEMA OFBIZ"
+
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;CACHE_SIZE=65536;INIT=CREATE
SCHEMA IF NOT EXISTS OFBIZ\;SET SCHEMA OFBIZ"
jdbc-username="ofbiz"
jdbc-password-lookup="h2-ofbiz"
isolation-level="ReadCommitted"
- pool-minsize="0"
+ pool-minsize="2"
pool-maxsize="250"
pool-sleeptime="300000"
test-on-borrow="true"
@@ -207,11 +207,11 @@ access. For a detailed description see the
core/docs/entityconfig.html file.
<inline-jdbc
jdbc-driver="org.h2.Driver"
-
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE
SCHEMA IF NOT EXISTS ODBC\;SET SCHEMA ODBC"
+
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;CACHE_SIZE=65536;INIT=CREATE
SCHEMA IF NOT EXISTS ODBC\;SET SCHEMA ODBC"
jdbc-username="ofbiz"
jdbc-password-lookup="h2-ofbizodbc"
isolation-level="ReadCommitted"
- pool-minsize="0"
+ pool-minsize="2"
pool-maxsize="250"
pool-sleeptime="300000"
test-on-borrow="true"
@@ -240,11 +240,11 @@ access. For a detailed description see the
core/docs/entityconfig.html file.
<read-data reader-name="ext-demo"/>
<inline-jdbc
jdbc-driver="org.h2.Driver"
-
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE
SCHEMA IF NOT EXISTS OLAP\;SET SCHEMA OLAP"
+
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;CACHE_SIZE=65536;INIT=CREATE
SCHEMA IF NOT EXISTS OLAP\;SET SCHEMA OLAP"
jdbc-username="ofbiz"
jdbc-password-lookup="h2-ofbizolap"
isolation-level="ReadCommitted"
- pool-minsize="0"
+ pool-minsize="2"
pool-maxsize="250"
pool-sleeptime="300000"
test-on-borrow="true"
@@ -273,11 +273,11 @@ access. For a detailed description see the
core/docs/entityconfig.html file.
<inline-jdbc
jdbc-driver="org.h2.Driver"
-
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE
SCHEMA IF NOT EXISTS TENANT\;SET SCHEMA TENANT"
+
jdbc-uri="jdbc:h2:file:./runtime/data/h2/ofbiz;DB_CLOSE_ON_EXIT=FALSE;CACHE_SIZE=65536;INIT=CREATE
SCHEMA IF NOT EXISTS TENANT\;SET SCHEMA TENANT"
jdbc-username="ofbiz"
jdbc-password-lookup="h2-ofbiztenant"
isolation-level="ReadCommitted"
- pool-minsize="0"
+ pool-minsize="2"
pool-maxsize="250"
pool-sleeptime="300000"
test-on-borrow="true"
