Hi Deepak, I tried with Postgres, works like a charm with the old 9.1 version
Jacques Le 14/09/2022 à 07:37, Deepak Dixit a écrit :
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<[email protected]> 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
