Hello Jacques, Thank you for reporting. I have fixed those errors/warnings in the below commit:
https://github.com/apache/ofbiz-framework/commit/2bcbf32a7f4a45a408b858b852eb5ccc3f72746b -- Kind Regards, Ashish Vijaywargiya Vice President of Operations *HotWax Systems* *Enterprise open source experts* http://www.hotwaxsystems.com On Sun, May 17, 2026 at 12:37 AM Jacques Le Roux via dev < [email protected]> wrote: > Hi, > > We have just trivial names conflicts in log when loading all with an > existing H2 DB, like at least: > Column [ROOT_LOCATION] of table [TENANT.COMPONENT] of entity [Component] > is of type [CHARACTER VARYING] in the database, but is defined as type > [VARCHAR] in the entity definition. > Column [INTERNAL_NOTE] of table [OFBIZ.WORK_EFFORT_NOTE] of entity > [WorkEffortNote] is of type [CHARACTER] in the database, but is defined as > type > [CHAR] in the entity definition. > > Trivial, because that has no incidence on operations. Simple global > changes should do it. As it's mostly those kinds above (9134 lines at all), > changing them should show others if they exist. > > Have a good weekend > > Jacques > > Le 16/05/2026 à 17:25, Jacques Le Roux via dev a écrit : > > 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. > >>>>> >
