Please let me know if it looks good, I'll merge this. This may cause issues with some of the databases.
I verified it's working fine with mysql and derby. Thanks & Regards -- Deepak Dixit ofbiz.apache.org On Mon, Sep 12, 2022 at 1:33 PM Deepak Dixit <dee...@apache.org> wrote: > > While working with mysql 8 database faced an issue with new ofbiz setup, > ofbiz fails to add new tables in database, > > Environment > Database server : mysql 8 > Database drive : mysql 8.0.30 > > Steps to regenerate: > > - Create new database named ofbiz, configure it with ofbiz and load > data (everything working fine) > - Create another database named ofbiz1, configure it with ofbiz and > load data > This process will fails > > After initial debugging found while check db DatabaseMetaData.getTables > returns a list of tables from the existing database, so it does not create > new tables hence fails to load data. > Created PR for the same [1], need to verify these changes with other > databases as well, as it may fail with others. > > > [1] https://github.com/apache/ofbiz-framework/pull/543/files > > [2] > https://stackoverflow.com/questions/7942520/relationship-between-catalog-schema-user-and-database-instance > > > > Thanks & Regards > -- > Deepak Dixit > ofbiz.apache.org >
