[GitHub] [ofbiz-framework] sonarcloud[bot] commented on pull request #517: Codenarc integration
sonarcloud[bot] commented on PR #517: URL: https://github.com/apache/ofbiz-framework/pull/517#issuecomment-1182554450 SonarCloud Quality Gate failed. [![Quality Gate failed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/failed-16px.png 'Quality Gate failed')](https://sonarcloud.io/dashboard?id=apache_ofbiz-framework&pullRequest=517) [![Bug](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/bug-16px.png 'Bug')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=BUG) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=BUG) [0 Bugs](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=BUG) [![Vulnerability](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/vulnerability-16px.png 'Vulnerability')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=VULNERABILITY) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=VULNERABILITY) [0 Vulnerabilities](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=VULNERABILITY) [![Security Hotspot](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/security_hotspot-16px.png 'Security Hotspot')](https://sonarcloud.io/project/security_hotspots?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=SECURITY_HOTSPOT) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/security_hotspots?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=SECURITY_HOTSPOT) [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=SECURITY_HOTSPOT) [![Code Smell](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/code_smell-16px.png 'Code Smell')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=CODE_SMELL) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=CODE_SMELL) [0 Code Smells](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=CODE_SMELL) [![No Coverage information](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/CoverageChart/NoCoverageInfo-16px.png 'No Coverage information')](https://sonarcloud.io/component_measures?id=apache_ofbiz-framework&pullRequest=517) No Coverage information [![9.4%](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/Duplications/10-16px.png '9.4%')](https://sonarcloud.io/component_measures?id=apache_ofbiz-framework&pullRequest=517&metric=new_duplicated_lines_density&view=list) [9.4% Duplication](https://sonarcloud.io/component_measures?id=apache_ofbiz-framework&pullRequest=517&metric=new_duplicated_lines_density&view=list) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@ofbiz.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [ofbiz-framework]: Workflow run "Java CI with Gradle" failed!
The GitHub Actions job "Java CI with Gradle" on ofbiz-framework.git has failed. Run started by GitHub user gilPts (triggered by gilPts). Head commit for run: 340701a06a7fa5af21f0d41f0007caff7c914de1 / Gil Portenseigne Customize SpaceAroundMapEntryColon rule to respect community opinion Map in OFBiz groovy should respect [key: value] syntax Report URL: https://github.com/apache/ofbiz-framework/actions/runs/2659199349 With regards, GitHub Actions via GitBox
[GitHub] [ofbiz-framework] sonarcloud[bot] commented on pull request #517: Codenarc integration
sonarcloud[bot] commented on PR #517: URL: https://github.com/apache/ofbiz-framework/pull/517#issuecomment-1182473497 SonarCloud Quality Gate failed. [![Quality Gate failed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/failed-16px.png 'Quality Gate failed')](https://sonarcloud.io/dashboard?id=apache_ofbiz-framework&pullRequest=517) [![Bug](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/bug-16px.png 'Bug')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=BUG) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=BUG) [0 Bugs](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=BUG) [![Vulnerability](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/vulnerability-16px.png 'Vulnerability')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=VULNERABILITY) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=VULNERABILITY) [0 Vulnerabilities](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=VULNERABILITY) [![Security Hotspot](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/security_hotspot-16px.png 'Security Hotspot')](https://sonarcloud.io/project/security_hotspots?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=SECURITY_HOTSPOT) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/security_hotspots?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=SECURITY_HOTSPOT) [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=SECURITY_HOTSPOT) [![Code Smell](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/code_smell-16px.png 'Code Smell')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=CODE_SMELL) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=CODE_SMELL) [0 Code Smells](https://sonarcloud.io/project/issues?id=apache_ofbiz-framework&pullRequest=517&resolved=false&types=CODE_SMELL) [![No Coverage information](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/CoverageChart/NoCoverageInfo-16px.png 'No Coverage information')](https://sonarcloud.io/component_measures?id=apache_ofbiz-framework&pullRequest=517) No Coverage information [![9.4%](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/Duplications/10-16px.png '9.4%')](https://sonarcloud.io/component_measures?id=apache_ofbiz-framework&pullRequest=517&metric=new_duplicated_lines_density&view=list) [9.4% Duplication](https://sonarcloud.io/component_measures?id=apache_ofbiz-framework&pullRequest=517&metric=new_duplicated_lines_density&view=list) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@ofbiz.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[jira] [Commented] (OFBIZ-12666) Integration tests fail with Postgres DB
[ https://issues.apache.org/jira/browse/OFBIZ-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17565473#comment-17565473 ] Jacques Le Roux commented on OFBIZ-12666: - Hi Johannes, Michael, I kinda replicate the issue locally on Win7 using trunk with Postgres 9.1. I never tried before but was hoping that uploading a folder (runtime\logs\test-results\html) would replicate the structure. It does not and you have to remove files one by one, so please forget that. I said I kinda replicate the issue because I have only 2 errors: assetmainttests test::UpdateFixedAssetMaintAndWorkEffort entitytests::testFieldTypes same error than Johannes. I have also the same failure facilitytests testCalculateQuantityBreakShipmentCostFlatValue Failure expected:<13.0> but was:<12.0> For entitytests::testFieldTypes Postgres suggests to rewrite or cast the expression, maybe a way for this one. Note that the succes rate is 99.81% not perfect, but not so bad :) > Integration tests fail with Postgres DB > --- > > Key: OFBIZ-12666 > URL: https://issues.apache.org/jira/browse/OFBIZ-12666 > Project: OFBiz > Issue Type: Bug > Components: framework/entity >Affects Versions: 22.01.01 > Environment: Have been testing this in a vm running Debian 11 and in > Docker using openjdk:11-jdk-slim as the base image. >Reporter: Johannes Schreiber >Priority: Critical > Attachments: 0_MinilangTests.html, 10_facilitytests-fails.html, > 10_facilitytests.html, 11_finaccounttests.html, 12_fixedassettests.html, > 13_groupordertests.html, 14_invoicetests.html, 15_lucenetests.html, > 16_marketingtests.html, 17_ordertests.html, 18_partycontactmechtests.html, > 19_partystatuschangetests.html, 1_accountingtests.html, 20_partytests.html, > 21_paymentappltests.html, 22_paymenttests.html, 23_performfindtests.html, > 24_productConfigTests.html, 25_productPromoTests.html, > 26_productcosttests.html, 27_productionruntests.html, > 28_producttagtests.html, 29_producttests.html, 2_assetmainttests-errors.html, > 2_assetmainttests.html, 30_quotetests.html, 31_ratetests.html, > 32_scrumtests.html, 33_servicetests.html, 34_shoppingcarttests.html, > 35_shoppinglisttests.html, 36_solrtests.html, 37_userlogintests.html, > 38_widgettests.html, 39_workefforttests.html, 3_basetests.html, > 4_catalogtests.html, 5_contenttests.html, 6_custrequesttests.html, > 7_ecommercetests.html, 8_entitytests-errors.html, 8_entitytests.html, > 9_example-tests.html, all-tests.html, allclasses-frame.html, > alltests-errors.html, alltests-fails.html, alltests-skipped.html, index.html, > overview-frame.html, overview-summary.html, package-frame.html, > package-summary.html, test_results_assetmaint_entity_invoice.jpg, > test_results_facilitytests.jpg, test_results_overview.jpg > > > When using Postgres as the main database for OFBiz a couple of integration > tests consistently fail (see below). This does not happen when using derby as > the database. This is really unfortunate when trying to integrate OFBiz using > CI/CD. > Steps to test: > # clone [https://github.com/apache/ofbiz-framework.git] and checkout > release22.01 > # run ./gradlew pullAllPluginsSource > # make adjustments to build.gradle and entityengine.xml (see below) > # run ./gradlew cleanAll loadAll "ofbiz --test" > I did not make any changes to OFBiz other then those made to the two file > mentioned before. > build.gradle diff: > {code:java} > diff --git a/build.gradle b/build.gradle > index 6f2d644c43..5bb96902c1 100644 > --- a/build.gradle > +++ b/build.gradle > @@ -193,6 +193,7 @@ configurations { > } > > dependencies { > + > implementation 'xerces:xercesImpl:2.12.2' > implementation 'com.google.zxing:core:3.4.1' > implementation > 'com.googlecode.concurrentlinkedhashmap:concurrentlinkedhashmap-lru:1.4.2' > @@ -267,6 +268,7 @@ dependencies { > runtimeOnly 'org.apache.logging.log4j:log4j-web:2.17.2' //??? > runtimeOnly 'org.apache.logging.log4j:log4j-jcl:2.17.2' // need to > constrain to version to avoid classpath conflict (ReflectionUtil) > runtimeOnly > 'org.codeartisans.thirdparties.swing:batik-all:1.8pre-r1084380' > + runtimeOnly 'org.postgresql:postgresql:42.2.5' > > // Dependencies defined by the plugins > subprojects.each { subProject -> {code} > entityengine.xml diff: > {code:java} > diff --git a/framework/entity/config/entityengine.xml > b/framework/entity/config/entityengine.xml > index e9abf07632..7b36749061 100644 > --- a/framework/entity/config/entityengine.xml > +++ b/framework/entity/config/entityengine.xml > @@ -52,20 +52,20 @@ access. For a detailed description see the > core/docs/entityconfig.html file. > > > entity-group-reader="main" entity-eca-reader="main" > di
[jira] [Updated] (OFBIZ-12666) Integration tests fail with Postgres DB
[ https://issues.apache.org/jira/browse/OFBIZ-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-12666: Attachment: (was: stylesheet.css) > Integration tests fail with Postgres DB > --- > > Key: OFBIZ-12666 > URL: https://issues.apache.org/jira/browse/OFBIZ-12666 > Project: OFBiz > Issue Type: Bug > Components: framework/entity >Affects Versions: 22.01.01 > Environment: Have been testing this in a vm running Debian 11 and in > Docker using openjdk:11-jdk-slim as the base image. >Reporter: Johannes Schreiber >Priority: Critical > Attachments: 0_MinilangTests.html, 10_facilitytests-fails.html, > 10_facilitytests.html, 11_finaccounttests.html, 12_fixedassettests.html, > 13_groupordertests.html, 14_invoicetests.html, 15_lucenetests.html, > 16_marketingtests.html, 17_ordertests.html, 18_partycontactmechtests.html, > 19_partystatuschangetests.html, 1_accountingtests.html, 20_partytests.html, > 21_paymentappltests.html, 22_paymenttests.html, 23_performfindtests.html, > 24_productConfigTests.html, 25_productPromoTests.html, > 26_productcosttests.html, 27_productionruntests.html, > 28_producttagtests.html, 29_producttests.html, 2_assetmainttests-errors.html, > 2_assetmainttests.html, 30_quotetests.html, 31_ratetests.html, > 32_scrumtests.html, 33_servicetests.html, 34_shoppingcarttests.html, > 35_shoppinglisttests.html, 36_solrtests.html, 37_userlogintests.html, > 38_widgettests.html, 39_workefforttests.html, 3_basetests.html, > 4_catalogtests.html, 5_contenttests.html, 6_custrequesttests.html, > 7_ecommercetests.html, 8_entitytests-errors.html, 8_entitytests.html, > 9_example-tests.html, all-tests.html, allclasses-frame.html, > alltests-errors.html, alltests-fails.html, alltests-skipped.html, index.html, > overview-frame.html, overview-summary.html, package-frame.html, > package-summary.html, test_results_assetmaint_entity_invoice.jpg, > test_results_facilitytests.jpg, test_results_overview.jpg > > > When using Postgres as the main database for OFBiz a couple of integration > tests consistently fail (see below). This does not happen when using derby as > the database. This is really unfortunate when trying to integrate OFBiz using > CI/CD. > Steps to test: > # clone [https://github.com/apache/ofbiz-framework.git] and checkout > release22.01 > # run ./gradlew pullAllPluginsSource > # make adjustments to build.gradle and entityengine.xml (see below) > # run ./gradlew cleanAll loadAll "ofbiz --test" > I did not make any changes to OFBiz other then those made to the two file > mentioned before. > build.gradle diff: > {code:java} > diff --git a/build.gradle b/build.gradle > index 6f2d644c43..5bb96902c1 100644 > --- a/build.gradle > +++ b/build.gradle > @@ -193,6 +193,7 @@ configurations { > } > > dependencies { > + > implementation 'xerces:xercesImpl:2.12.2' > implementation 'com.google.zxing:core:3.4.1' > implementation > 'com.googlecode.concurrentlinkedhashmap:concurrentlinkedhashmap-lru:1.4.2' > @@ -267,6 +268,7 @@ dependencies { > runtimeOnly 'org.apache.logging.log4j:log4j-web:2.17.2' //??? > runtimeOnly 'org.apache.logging.log4j:log4j-jcl:2.17.2' // need to > constrain to version to avoid classpath conflict (ReflectionUtil) > runtimeOnly > 'org.codeartisans.thirdparties.swing:batik-all:1.8pre-r1084380' > + runtimeOnly 'org.postgresql:postgresql:42.2.5' > > // Dependencies defined by the plugins > subprojects.each { subProject -> {code} > entityengine.xml diff: > {code:java} > diff --git a/framework/entity/config/entityengine.xml > b/framework/entity/config/entityengine.xml > index e9abf07632..7b36749061 100644 > --- a/framework/entity/config/entityengine.xml > +++ b/framework/entity/config/entityengine.xml > @@ -52,20 +52,20 @@ access. For a detailed description see the > core/docs/entityconfig.html file. > > > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > > entity-group-reader="main" entity-eca-reader="main"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbyt
[jira] [Updated] (OFBIZ-12666) Integration tests fail with Postgres DB
[ https://issues.apache.org/jira/browse/OFBIZ-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-12666: Attachment: 0_MinilangTests.html 10_facilitytests-fails.html 10_facilitytests.html 11_finaccounttests.html 12_fixedassettests.html 13_groupordertests.html 14_invoicetests.html 15_lucenetests.html 16_marketingtests.html 17_ordertests.html 18_partycontactmechtests.html 19_partystatuschangetests.html 1_accountingtests.html 20_partytests.html 21_paymentappltests.html 22_paymenttests.html 23_performfindtests.html 24_productConfigTests.html 25_productPromoTests.html 26_productcosttests.html 27_productionruntests.html 28_producttagtests.html 29_producttests.html 2_assetmainttests-errors.html 2_assetmainttests.html 30_quotetests.html 31_ratetests.html 32_scrumtests.html 33_servicetests.html 34_shoppingcarttests.html 35_shoppinglisttests.html 36_solrtests.html 37_userlogintests.html 38_widgettests.html 39_workefforttests.html 3_basetests.html 4_catalogtests.html 5_contenttests.html 6_custrequesttests.html 7_ecommercetests.html 8_entitytests-errors.html 8_entitytests.html 9_example-tests.html all-tests.html allclasses-frame.html alltests-errors.html alltests-fails.html alltests-skipped.html index.html overview-frame.html overview-summary.html package-frame.html package-summary.html stylesheet.css > Integration tests fail with Postgres DB > --- > > Key: OFBIZ-12666 > URL: https://issues.apache.org/jira/browse/OFBIZ-12666 > Project: OFBiz > Issue Type: Bug > Components: framework/entity >Affects Versions: 22.01.01 > Environment: Have been testing this in a vm running Debian 11 and in > Docker using openjdk:11-jdk-slim as the base image. >Reporter: Johannes Schreiber >Priority: Critical > Attachments: 0_MinilangTests.html, 10_facilitytests-fails.html, > 10_facilitytests.html, 11_finaccounttests.html, 12_fixedassettests.html, > 13_groupordertests.html, 14_invoicetests.html, 15_lucenetests.html, > 16_marketingtests.html, 17_ordertests.html, 18_partycontactmechtests.html, > 19_partystatuschangetests.html, 1_accountingtests.html, 20_partytests.html, > 21_paymentappltests.html, 22_paymenttests.html, 23_performfindtests.html, > 24_productConfigTests.html, 25_productPromoTests.html, > 26_productcosttests.html, 27_productionruntests.html, > 28_producttagtests.html, 29_producttests.html, 2_assetmainttests-errors.html, > 2_assetmainttests.html, 30_quotetests.html, 31_ratetests.html, > 32_scrumtests.html, 33_servicetests.html, 34_shoppingcarttests.html, > 35_shoppinglisttests.html, 36_solrtests.html, 37_userlogintests.html, > 38_widgettests.html, 39_workefforttests.html, 3_basetests.html, > 4_catalogtests.html, 5_contenttests.html, 6_custrequesttests.html, > 7_ecommercetests.html, 8_entitytests-errors.html, 8_entitytests.html, > 9_example-tests.html, all-tests.html, allclasses-frame.html, > alltests-errors.html, alltests-fails.html, alltests-skipped.html, index.html, > overview-frame.html, overview-summary.html, package-frame.html, > package-summary.html, stylesheet.css, > test_results_assetmaint_entity_invoice.jpg, test_results_facilitytests.jpg, > test_results_overview.jpg > > > When using Postgres as the main database for OFBiz a couple of integration > tests consistently fail (see below). This does not happen when using derby as > the database. This is really unfortunate when trying to integrate OFBiz using > CI/CD. > Steps to test: > # clone [https://github.com/apache/ofbiz-framework.git] and checkout > release22.01 > # run ./gradlew pullAllPluginsSource > # make adjustments to build.gradle and entityengine.xml (see below) > # run ./gradlew cleanAll loadAll "ofbiz --test" > I did not make any changes to OFBiz other then those made to the two file > mentioned before. > build.gradle diff: > {code:java} > diff --git a/build.gradle b/build.gradle > index 6f2d644c43..5bb96902c1 100644 > --- a/build.gradle > +++ b/build.gradl
[jira] [Comment Edited] (OFBIZ-12666) Integration tests fail with Postgres DB
[ https://issues.apache.org/jira/browse/OFBIZ-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17565354#comment-17565354 ] Johannes Schreiber edited comment on OFBIZ-12666 at 7/12/22 8:09 AM: - Hi Michael, i am pretty certain that remains in the database are not the problem, i made sure to test using a clean database. I tried against just now just to be sure and still got the same result. Hope someone can figure this out. Best regards was (Author: JIRAUSER292619): Hi Michael, i am pretty certain that remains in the database are not the problem, i made sure to test using a clean database. I tried against just now just to be sure and still got the same result. Hope someone can figure this out. Best regards, Johannes > Integration tests fail with Postgres DB > --- > > Key: OFBIZ-12666 > URL: https://issues.apache.org/jira/browse/OFBIZ-12666 > Project: OFBiz > Issue Type: Bug > Components: framework/entity >Affects Versions: 22.01.01 > Environment: Have been testing this in a vm running Debian 11 and in > Docker using openjdk:11-jdk-slim as the base image. >Reporter: Johannes Schreiber >Priority: Critical > Attachments: test_results_assetmaint_entity_invoice.jpg, > test_results_facilitytests.jpg, test_results_overview.jpg > > > When using Postgres as the main database for OFBiz a couple of integration > tests consistently fail (see below). This does not happen when using derby as > the database. This is really unfortunate when trying to integrate OFBiz using > CI/CD. > Steps to test: > # clone [https://github.com/apache/ofbiz-framework.git] and checkout > release22.01 > # run ./gradlew pullAllPluginsSource > # make adjustments to build.gradle and entityengine.xml (see below) > # run ./gradlew cleanAll loadAll "ofbiz --test" > I did not make any changes to OFBiz other then those made to the two file > mentioned before. > build.gradle diff: > {code:java} > diff --git a/build.gradle b/build.gradle > index 6f2d644c43..5bb96902c1 100644 > --- a/build.gradle > +++ b/build.gradle > @@ -193,6 +193,7 @@ configurations { > } > > dependencies { > + > implementation 'xerces:xercesImpl:2.12.2' > implementation 'com.google.zxing:core:3.4.1' > implementation > 'com.googlecode.concurrentlinkedhashmap:concurrentlinkedhashmap-lru:1.4.2' > @@ -267,6 +268,7 @@ dependencies { > runtimeOnly 'org.apache.logging.log4j:log4j-web:2.17.2' //??? > runtimeOnly 'org.apache.logging.log4j:log4j-jcl:2.17.2' // need to > constrain to version to avoid classpath conflict (ReflectionUtil) > runtimeOnly > 'org.codeartisans.thirdparties.swing:batik-all:1.8pre-r1084380' > + runtimeOnly 'org.postgresql:postgresql:42.2.5' > > // Dependencies defined by the plugins > subprojects.each { subProject -> {code} > entityengine.xml diff: > {code:java} > diff --git a/framework/entity/config/entityengine.xml > b/framework/entity/config/entityengine.xml > index e9abf07632..7b36749061 100644 > --- a/framework/entity/config/entityengine.xml > +++ b/framework/entity/config/entityengine.xml > @@ -52,20 +52,20 @@ access. For a detailed description see the > core/docs/entityconfig.html file. > > > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > > entity-group-reader="main" entity-eca-reader="main"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Comment Edited] (OFBIZ-12666) Integration tests fail with Postgres DB
[ https://issues.apache.org/jira/browse/OFBIZ-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17565354#comment-17565354 ] Johannes Schreiber edited comment on OFBIZ-12666 at 7/12/22 8:08 AM: - Hi Michael, i am pretty certain that remains in the database are not the problem, i made sure to test using a clean database. I tried against just now just to be sure and still got the same result. Hope someone can figure this out. Best regards, Johannes was (Author: JIRAUSER292619): Hi Michael, i am pretty certain that remains in the database are not the problem, i made sure to test using a clean database. I tried against just now just to be sure and still got the same result. Hope someone can figure this out. > Integration tests fail with Postgres DB > --- > > Key: OFBIZ-12666 > URL: https://issues.apache.org/jira/browse/OFBIZ-12666 > Project: OFBiz > Issue Type: Bug > Components: framework/entity >Affects Versions: 22.01.01 > Environment: Have been testing this in a vm running Debian 11 and in > Docker using openjdk:11-jdk-slim as the base image. >Reporter: Johannes Schreiber >Priority: Critical > Attachments: test_results_assetmaint_entity_invoice.jpg, > test_results_facilitytests.jpg, test_results_overview.jpg > > > When using Postgres as the main database for OFBiz a couple of integration > tests consistently fail (see below). This does not happen when using derby as > the database. This is really unfortunate when trying to integrate OFBiz using > CI/CD. > Steps to test: > # clone [https://github.com/apache/ofbiz-framework.git] and checkout > release22.01 > # run ./gradlew pullAllPluginsSource > # make adjustments to build.gradle and entityengine.xml (see below) > # run ./gradlew cleanAll loadAll "ofbiz --test" > I did not make any changes to OFBiz other then those made to the two file > mentioned before. > build.gradle diff: > {code:java} > diff --git a/build.gradle b/build.gradle > index 6f2d644c43..5bb96902c1 100644 > --- a/build.gradle > +++ b/build.gradle > @@ -193,6 +193,7 @@ configurations { > } > > dependencies { > + > implementation 'xerces:xercesImpl:2.12.2' > implementation 'com.google.zxing:core:3.4.1' > implementation > 'com.googlecode.concurrentlinkedhashmap:concurrentlinkedhashmap-lru:1.4.2' > @@ -267,6 +268,7 @@ dependencies { > runtimeOnly 'org.apache.logging.log4j:log4j-web:2.17.2' //??? > runtimeOnly 'org.apache.logging.log4j:log4j-jcl:2.17.2' // need to > constrain to version to avoid classpath conflict (ReflectionUtil) > runtimeOnly > 'org.codeartisans.thirdparties.swing:batik-all:1.8pre-r1084380' > + runtimeOnly 'org.postgresql:postgresql:42.2.5' > > // Dependencies defined by the plugins > subprojects.each { subProject -> {code} > entityengine.xml diff: > {code:java} > diff --git a/framework/entity/config/entityengine.xml > b/framework/entity/config/entityengine.xml > index e9abf07632..7b36749061 100644 > --- a/framework/entity/config/entityengine.xml > +++ b/framework/entity/config/entityengine.xml > @@ -52,20 +52,20 @@ access. For a detailed description see the > core/docs/entityconfig.html file. > > > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > > entity-group-reader="main" entity-eca-reader="main"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (OFBIZ-12666) Integration tests fail with Postgres DB
[ https://issues.apache.org/jira/browse/OFBIZ-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17565354#comment-17565354 ] Johannes Schreiber commented on OFBIZ-12666: Hi Michael, i am pretty certain that remains in the database are not the problem, i made sure to test using a clean database. I tried against just now just to be sure and still got the same result. Hope someone can figure this out. > Integration tests fail with Postgres DB > --- > > Key: OFBIZ-12666 > URL: https://issues.apache.org/jira/browse/OFBIZ-12666 > Project: OFBiz > Issue Type: Bug > Components: framework/entity >Affects Versions: 22.01.01 > Environment: Have been testing this in a vm running Debian 11 and in > Docker using openjdk:11-jdk-slim as the base image. >Reporter: Johannes Schreiber >Priority: Critical > Attachments: test_results_assetmaint_entity_invoice.jpg, > test_results_facilitytests.jpg, test_results_overview.jpg > > > When using Postgres as the main database for OFBiz a couple of integration > tests consistently fail (see below). This does not happen when using derby as > the database. This is really unfortunate when trying to integrate OFBiz using > CI/CD. > Steps to test: > # clone [https://github.com/apache/ofbiz-framework.git] and checkout > release22.01 > # run ./gradlew pullAllPluginsSource > # make adjustments to build.gradle and entityengine.xml (see below) > # run ./gradlew cleanAll loadAll "ofbiz --test" > I did not make any changes to OFBiz other then those made to the two file > mentioned before. > build.gradle diff: > {code:java} > diff --git a/build.gradle b/build.gradle > index 6f2d644c43..5bb96902c1 100644 > --- a/build.gradle > +++ b/build.gradle > @@ -193,6 +193,7 @@ configurations { > } > > dependencies { > + > implementation 'xerces:xercesImpl:2.12.2' > implementation 'com.google.zxing:core:3.4.1' > implementation > 'com.googlecode.concurrentlinkedhashmap:concurrentlinkedhashmap-lru:1.4.2' > @@ -267,6 +268,7 @@ dependencies { > runtimeOnly 'org.apache.logging.log4j:log4j-web:2.17.2' //??? > runtimeOnly 'org.apache.logging.log4j:log4j-jcl:2.17.2' // need to > constrain to version to avoid classpath conflict (ReflectionUtil) > runtimeOnly > 'org.codeartisans.thirdparties.swing:batik-all:1.8pre-r1084380' > + runtimeOnly 'org.postgresql:postgresql:42.2.5' > > // Dependencies defined by the plugins > subprojects.each { subProject -> {code} > entityengine.xml diff: > {code:java} > diff --git a/framework/entity/config/entityengine.xml > b/framework/entity/config/entityengine.xml > index e9abf07632..7b36749061 100644 > --- a/framework/entity/config/entityengine.xml > +++ b/framework/entity/config/entityengine.xml > @@ -52,20 +52,20 @@ access. For a detailed description see the > core/docs/entityconfig.html file. > > > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > > > > entity-group-reader="main" entity-eca-reader="main"> > - datasource-name="localderby"/> > + datasource-name="localpostgres"/> > datasource-name="localderbyolap"/> > datasource-name="localderbytenant"/> > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)