You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by as...@apache.org on 2026/05/22 14:10:39 UTC
(ofbiz-framework) branch trunk updated: OFBIZ-13412 - Updated the following:
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 <as...@apache.org>
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"