Hi Ashish,
I made an integration on Win7. It's quicker than Derby and successful.
Same on Ubuntu (22 min vs 32): https://ci2.apache.org/#/builders/46
Thanks
Jacques
Le 16/05/2026 à 15:50, Ashish Vijaywargiya a écrit :
Dear All,
There were no objections from community members to moving with the
H2 database.
https://www.h2database.com/html/main.html
I implemented the H2 database support and removed the Apache Derby from the
ofbiz trunk code.
Here is my commit for your kind reference:
https://github.com/apache/ofbiz-framework/commit/8306e7a10592ff93defb26d0ddaa8e0a4dbb8595
For historical purposes, I also created a JIRA ticket as well:
https://issues.apache.org/jira/browse/OFBIZ-13412
./gradlew cleanAll loadAll is working fine.
./gradlew ofbiz is working fine.
After the changes, I placed and completed a sales order. And then created a
customer in the ofbiz backend.
Everything seems to be working fine with the H2 database.
I will keep a close eye on the ofbiz mailing list and Jira for H2-related
issues.
If someone reports issues with the H2 database, we can fix them.
Thank you.
--
Kind Regards,
Ashish Vijaywargiya
Vice President of Operations
*HotWax Systems*
*Enterprise open source experts*
http://www.hotwaxsystems.com
On Sun, May 10, 2026 at 11:01 AM Ashish Vijaywargiya <
[email protected]> wrote:
For that reason, I think we should consider replacing Derby with another
embedded database for OFBiz’s out-of-the-box/demo setup.
Hello All,
I agree that we should consider replacing the Derby database with another
embedded database.
I also agree that H2 appears to be the best option at the current time.
I went ahead and replaced Apache Derby in my OFBiz trunk codebase with the
H2 database.
After the changes, I tested the ofbiz code base on H2 db by placing an
Order, completing it, and also created a new customer. These operations
are working fine for me.
I have pushed the H2-specific modified code to a branch in my forked
repository. Please take a look at the code below and let me know your
thoughts.
https://github.com/ashishvijaywargiya/ofbiz-framework/tree/default-h2-db-support-ofbiz-trunk
If there are no objections, I will create a PR sometime next week to merge
the code into the OFBiz project.
Thank you.
--
Kind Regards,
Ashish Vijaywargiya
Vice President of Operations
*HotWax Systems*
*Enterprise open source experts*
http://www.hotwaxsystems.com
On Thu, May 7, 2026 at 1:20 PM Jacopo Cappellato <
[email protected]> wrote:
Hi all,
Since Apache Derby is now retired, it will no longer receive updates for
bug fixes or security issues.
For that reason, I think we should consider replacing Derby with another
embedded database for OFBiz’s out-of-the-box/demo setup.
Would anyone be willing to volunteer in either of these areas?
* researching and suggesting suitable alternative products that would fit
OFBiz well;
* implementing the switch once we agree on a direction.
As an alternative, we could also consider no longer shipping a bundled
database at all, and instead relying on Docker images to make demo
instances easy to start.
That would be a more significant change for users, so perhaps not
something
for immediate adoption, but I think it is probably the right direction to
keep in mind for the future.
Thoughts?
Best,
Jacopo
On Thu, Dec 4, 2025 at 9:43 AM Jacques Le Roux <
[email protected]>
wrote:
Hi,
FYI, not a problem IMO. It works as is.
Jacques
-------- Message transféré --------
Sujet : Apache Derby is now retired
Date : Wed, 3 Dec 2025 09:38:15 -0800
De : Richard Hillegas <[email protected]>
Répondre à : [email protected]
Pour : [email protected]
The DB PMC announces the retirement of its Derby sub-project, due to
prolonged low activity. Derby is a small-footprint, pure-Java relational
database. Derby runs embedded in a local application as well as
client-server over a network. Databases can live on disk or in memory.
Existing,
official versions support JVMs from Java 1.3 up through Java 21. The
development mainline builds and tests cleanly on Java 25.
The project's resources remain available in a read-only state. This
includes the website (https://db.apache.org/derby/), mailing lists,
wiki
(https://cwiki.apache.org/confluence/display/DERBY/FrontPage),
Subversion
repository, and JIRA bug tracker. Official distributions remain
available
on
an as-is basis at https://db.apache.org/derby/derby_downloads.html.
