You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Deepak Dixit <de...@apache.org> on 2022/09/12 08:03:26 UTC
MySql8 issue with add missing on start
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
Re: MySql8 issue with add missing on start
Posted by Jacques Le Roux <ja...@les7arts.com>.
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<de...@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
>>
Re: MySql8 issue with add missing on start
Posted by Deepak Dixit <de...@apache.org>.
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 <de...@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
>