generator-jhipster: ManyToMany relationship generates wrong relationship table name

Overview of the issue

I use JDL file

entity Material {
    name String
}
entity MaterialOrigin {
    name String
}
relationship ManyToMany {
    Material{origin} to MaterialOrigin{material}
}

This wrongly generates relationship table name as “material_origin” instead of “material_origin_material” in files:

• .../domain/Material.java
• .../changelog/..._added_entity_constraints_Material.xml
• .../changelog/..._added_entity_Material.xml

The issue reveals itself on ./mvnw with the error

WARN 26590 --- [  restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'servletEndpointRegistrar' defined in class path resource [org/springframework/boot/actuate/autoconfigure/endpoint/web/ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.actuate.endpoint.web.ServletEndpointRegistrar]: Factory method 'servletEndpointRegistrar' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'auditEventsEndpoint' defined in class path resource [org/springframework/boot/actuate/autoconfigure/audit/AuditEventsEndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method 'auditEventsEndpoint' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'customAuditEventRepository' defined in file [.../target/classes/com/company/app/repository/CustomAuditEventRepository.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'persistenceAuditEventRepository': Cannot create inner bean '(inner bean)#1c95bc62' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#1c95bc62': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.MappingException: Foreign key (FKipo7e0wsvsnrag9hoy1hnmeb6:material_origin [origin_id])) must have same number of columns as the referenced primary key (material_origin [material_id,origin_id])

Motivation for or Use Case

The app fails to run without a proper relation table. The material_origin_material is not even described anywhere despite being referenced from .../changelog/..._added_entity_MaterialOrigin.xml.

Reproduce the error

1. Initialize fresh app with jhipster and all the defaults (just hit enter like 10 times)
2. Save the JDL above to the jhipster-many-to-many-bug.jdl
3. Bootstrap models with jhipster import-jdl ./jhipster-many-to-many-bug.jdl --force
4. ./mvnw

Related issues

I didn’t find any.

Suggest a Fix

JHipster Version(s)

6.5.1

JHipster configuration

INFO! Using JHipster version installed locally in current project’s node_modules INFO! Executing jhipster:info INFO! Options: from-cli: true

JHipster Version(s)

jhipster@0.0.1-SNAPSHOT /home/nikolay.seliverstov/Projects/jh-manytomany-bug
└── generator-jhipster@6.5.1 

JHipster configuration, a .yo-rc.json file generated in the root folder

{
  "generator-jhipster": {
    "promptValues": {
      "packageName": "com.janssen.fsra",
      "nativeLanguage": "en"
    },
    "jhipsterVersion": "6.5.1",
    "applicationType": "monolith",
    "baseName": "jhipster",
    "packageName": "com.janssen.fsra",
    "packageFolder": "com/janssen/fsra",
    "serverPort": "8080",
    "authenticationType": "jwt",
    "cacheProvider": "ehcache",
    "enableHibernateCache": true,
    "websocket": false,
    "databaseType": "sql",
    "devDatabaseType": "h2Disk",
    "prodDatabaseType": "mysql",
    "searchEngine": false,
    "messageBroker": false,
    "serviceDiscoveryType": false,
    "buildTool": "maven",
    "enableSwaggerCodegen": false,
    "jwtSecretKey": "bXktc2VjcmV0LXRva2VuLXRvLWNoYW5nZS1pbi1wcm9kdWN0aW9uLWFuZC10by1rZWVwLWluLWEtc2VjdXJlLXBsYWNl",
    "embeddableLaunchScript": false,
    "useSass": true,
    "clientPackageManager": "npm",
    "clientFramework": "angularX",
    "clientTheme": "none",
    "clientThemeVariant": "",
    "testFrameworks": [],
    "jhiPrefix": "jhi",
    "entitySuffix": "",
    "dtoSuffix": "DTO",
    "otherModules": [],
    "enableTranslation": true,
    "nativeLanguage": "en",
    "languages": ["en"],
    "blueprints": []
  }
}

JDL for the Entity configuration(s) entityName.json files generated in the .jhipster directory

entity Material {
  name String
}
entity MaterialOrigin {
  name String
}
relationship ManyToMany {
  Material{origin} to MaterialOrigin{material}
}

Environment and Tools

openjdk version “11.0.5” 2019-10-15 OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.5+10) OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.5+10, mixed mode)

git version 2.17.1

node: v8.15.1

npm: 6.4.1

yeoman: 3.1.1

Docker version 19.03.5, build 633a0ea838

docker-compose version 1.23.2, build 1110ad01

Entity configuration(s) entityName.json files generated in the .jhipster directory

{
    "name": "Material",
    "fields": [
        {
            "fieldName": "name",
            "fieldType": "String"
        }
    ],
    "relationships": [
        {
            "relationshipType": "many-to-many",
            "otherEntityName": "materialOrigin",
            "otherEntityRelationshipName": "material",
            "relationshipName": "origin",
            "otherEntityField": "id",
            "ownerSide": true
        }
    ],
    "changelogDate": "20191220115447",
    "entityTableName": "material",
    "dto": "no",
    "pagination": "no",
    "service": "no",
    "jpaMetamodelFiltering": false,
    "fluentMethods": true,
    "readOnly": false,
    "clientRootFolder": "",
    "applications": "*"
}

{
    "name": "MaterialOrigin",
    "fields": [
        {
            "fieldName": "name",
            "fieldType": "String"
        }
    ],
    "relationships": [
        {
            "relationshipType": "many-to-many",
            "otherEntityName": "material",
            "otherEntityRelationshipName": "origin",
            "relationshipName": "material",
            "otherEntityField": "id",
            "ownerSide": false
        }
    ],
    "changelogDate": "20191220115448",
    "entityTableName": "material_origin",
    "dto": "no",
    "pagination": "no",
    "service": "no",
    "jpaMetamodelFiltering": false,
    "fluentMethods": true,
    "readOnly": false,
    "clientRootFolder": "",
    "applications": "*"
}

Browsers and Operating System

Ubuntu 18.04 Firefox 71

• Checking this box is mandatory (this is just to show you read everything)