Re: [DISCUSSION] Do we start the R18 publish process ?

[Michael Brohl]

Hi Nicolas,

thanks for your message! I really would like to work on it but I am 
currently (over)occupied with client projects.


I'll try to organise some support with the ecomify team. I am also 
interested in getting the 18.12 release out as we have some projects 
based on it.


Thanks and regards,

Michael


Am 07.10.21 um 18:04 schrieb Nicolas Malin:

Hello Michael,

Any chance to work together on it soon ?

Nicolas

On 29/09/2021 09:20, Nicolas Malin wrote:

Hello Michael,

No problem to resolve these issue before.

Currently for jcenter, I tried to restart from scratch and from my part
I didn't see any issue but sure I missed something

Concerning the DiskFileItem, I tried to work on it, but without success
to spot the problem.

If you have some time to work on it together by VC it would be a pleasure !

Nicolas

On 28/09/2021 18:29, Michael Brohl wrote:

Hi Nicolas,

there a issues which I think should be fixed before an 18.12 release,
for example the JCenter migration problem [1] or the DiskFileItem
topic [2].

There are many more bugs also which I didn't check.

Regards,

Michael


[1] https://issues.apache.org/jira/browse/OFBIZ-12171

[2] https://issues.apache.org/jira/browse/OFBIZ-12016

Re: [DISCUSSION] Do we start the R18 publish process ?

[Nicolas Malin]

Hello Michael,

Any chance to work together on it soon ?

Nicolas

On 29/09/2021 09:20, Nicolas Malin wrote:
> Hello Michael,
>
> No problem to resolve these issue before.
>
> Currently for jcenter, I tried to restart from scratch and from my part
> I didn't see any issue but sure I missed something
>
> Concerning the DiskFileItem, I tried to work on it, but without success
> to spot the problem.
>
> If you have some time to work on it together by VC it would be a pleasure !
>
> Nicolas
>
> On 28/09/2021 18:29, Michael Brohl wrote:
>> Hi Nicolas,
>>
>> there a issues which I think should be fixed before an 18.12 release,
>> for example the JCenter migration problem [1] or the DiskFileItem
>> topic [2].
>>
>> There are many more bugs also which I didn't check.
>>
>> Regards,
>>
>> Michael
>>
>>
>> [1] https://issues.apache.org/jira/browse/OFBIZ-12171
>>
>> [2] https://issues.apache.org/jira/browse/OFBIZ-12016
>>

Re: Reserved words

[Michael Brohl]

Correcting myself: only DATABASE is a reserved name in MySQL, the other 
two are keywords.


Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.10.21 um 17:28 schrieb Michael Brohl:

Hi Pierre,

those words are reserved names in different databases, please check 
yourself: 
https://stackoverflow.com/questions/8339396/all-reserved-words-of-every-dbms#8341855


To me, the list seems pretty sophisticated for a variety of databases. 
It is not meant to be used only for a specific database.


For MySQL, all three words are reserved.

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.10.21 um 11:06 schrieb Pierre Smits:

Hi all,

While working on a solution that involves bringing existing tables 
from a
postgresql database into the entity group and model definitions, I 
noticed
that some of the column definitions were not acceptable by OFBiz and 
thus

entities would not get created in the underlying OFBiz database.

I found in ModelEntityChecker.java has a list of reserved words, 
including

words like:

    - password
    - database
    - type

Many of the words listed there are not reserved according to [1]

Does anyone know where these reserved words came from and when they got
into the java file?
It seems to me that a big brush was used to get to the list, and not 
much

consideration was given to the context (variations in database
applicability).

What are your thoughts on correcting this?


https://www.postgresql.org/docs/8.1/sql-keywords-appendix.html

Best regards,
Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

Re: Reserved words

[Michael Brohl]

Hi Pierre,

those words are reserved names in different databases, please check 
yourself: 
https://stackoverflow.com/questions/8339396/all-reserved-words-of-every-dbms#8341855


To me, the list seems pretty sophisticated for a variety of databases. 
It is not meant to be used only for a specific database.


For MySQL, all three words are reserved.

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.10.21 um 11:06 schrieb Pierre Smits:

Hi all,

While working on a solution that involves bringing existing tables from a
postgresql database into the entity group and model definitions, I noticed
that some of the column definitions were not acceptable by OFBiz and thus
entities would not get created in the underlying OFBiz database.

I found in ModelEntityChecker.java has a list of reserved words, including
words like:

- password
- database
- type

Many of the words listed there are not reserved according to [1]

Does anyone know where these reserved words came from and when they got
into the java file?
It seems to me that a big brush was used to get to the list, and not much
consideration was given to the context (variations in database
applicability).

What are your thoughts on correcting this?


https://www.postgresql.org/docs/8.1/sql-keywords-appendix.html

Best regards,
Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

Reserved words

[Pierre Smits]

Hi all,

While working on a solution that involves bringing existing tables from a
postgresql database into the entity group and model definitions, I noticed
that some of the column definitions were not acceptable by OFBiz and thus
entities would not get created in the underlying OFBiz database.

I found in ModelEntityChecker.java has a list of reserved words, including
words like:

   - password
   - database
   - type

Many of the words listed there are not reserved according to [1]

Does anyone know where these reserved words came from and when they got
into the java file?
It seems to me that a big brush was used to get to the list, and not much
consideration was given to the context (variations in database
applicability).

What are your thoughts on correcting this?


https://www.postgresql.org/docs/8.1/sql-keywords-appendix.html

Best regards,
Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services