diff options
| author |   BT2983 <BT2983@att.com> | 2018-10-10 23:08:19 -0600 |
|---|---|---|
| committer | BT2983 <BT2983@att.com> | 2018-10-10 23:08:19 -0600 |
| commit | 7b06f9211f7900e09ab6b97f61205b96aef693c1 (patch) | |
| tree | 6729fbf2e2d135344a436b3ed52695a6bcd32a90 | |
| parent | 55b09d5184a5873c57fa09b65f4e2f38fe082603 (diff) | |
Naming micro-service code - sql issues.
Table names are case-sensitive in the version of Maria used in ONAP.
Change-Id: I0a38a35a48fd2a2c850af67b46f882f2e7c96047
Issue-ID: CCSDK-608
Signed-off-by: BT2983 <BT2983@att.com>
| -rw-r--r-- | ms/neng/src/main/java/org/onap/ccsdk/apps/ms/neng/persistence/repository/GeneratedNameRespository.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/ms/neng/src/main/java/org/onap/ccsdk/apps/ms/neng/persistence/repository/GeneratedNameRespository.java b/ms/neng/src/main/java/org/onap/ccsdk/apps/ms/neng/persistence/repository/GeneratedNameRespository.java index ed2ac531..cb98b5dd 100644 --- a/ms/neng/src/main/java/org/onap/ccsdk/apps/ms/neng/persistence/repository/GeneratedNameRespository.java +++ b/ms/neng/src/main/java/org/onap/ccsdk/apps/ms/neng/persistence/repository/GeneratedNameRespository.java @@ -44,7 +44,7 @@ public interface GeneratedNameRespository extends CrudRepository<GeneratedName, /* * Finds entities for a given external system ID and element type, ignoring any special characters in names. */ - @Query(value = "select * from Generated_Name g where g.external_Id=:externalId and " + @Query(value = "select * from GENERATED_NAME g where g.external_Id=:externalId and " + "REPLACE(REPLACE(REPLACE(element_type,'NAME',''),'-',''),'_','')=:elementType", nativeQuery = true) public GeneratedName findByExternalIdAndRelaxedElementType(@Param("externalId")String externalId, |