X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=jar%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fmusic%2Frest%2FRestMusicDataAPI.java;h=4b29f9a185495da15466d32f01645c5c174407fd;hb=881f14bc8676cedd68e17bd007a869fa85578fa1;hp=fc31cd9eb0f52344c577088b67edbebf29e38393;hpb=b146c72f951cdbcecf1e3e726956082d9d8cf4b0;p=music.git

diff --git a/jar/src/main/java/org/onap/music/rest/RestMusicDataAPI.java b/jar/src/main/java/org/onap/music/rest/RestMusicDataAPI.java
index fc31cd9e..4b29f9a1 100755
--- a/jar/src/main/java/org/onap/music/rest/RestMusicDataAPI.java
+++ b/jar/src/main/java/org/onap/music/rest/RestMusicDataAPI.java
@@ -218,12 +218,16 @@ public class RestMusicDataAPI {
 
         try {
             queryObject = new PreparedQueryObject();
-            queryObject.appendQueryString("CREATE ROLE IF NOT EXISTS '" + userId
-                            + "' WITH PASSWORD = '" + password + "' AND LOGIN = true;");
+//            queryObject.appendQueryString("CREATE ROLE IF NOT EXISTS '" + userId
+//                            + "' WITH PASSWORD = '" + password + "' AND LOGIN = true;");
+            queryObject.appendQueryString("CREATE ROLE IF NOT EXISTS ? "
+                + " WITH PASSWORD = ? AND LOGIN = true;");
+            queryObject.addValue(userId);
+            queryObject.addValue(password);
             MusicCore.nonKeyRelatedPut(queryObject, consistency);
             queryObject = new PreparedQueryObject();
             queryObject.appendQueryString("GRANT ALL PERMISSIONS on KEYSPACE " + keyspaceName
-                                + " to '" + userId + "'");
+                + " to '" + userId + "'");
             queryObject.appendQueryString(";");
             MusicCore.nonKeyRelatedPut(queryObject, consistency);
         } catch (Exception e) {
@@ -235,8 +239,8 @@ public class RestMusicDataAPI {
             String hashedpwd = BCrypt.hashpw(password, BCrypt.gensalt());
             queryObject = new PreparedQueryObject();
             queryObject.appendQueryString(
-                        "INSERT into admin.keyspace_master (uuid, keyspace_name, application_name, is_api, "
-                                        + "password, username, is_aaf) values (?,?,?,?,?,?,?)");
+                "INSERT into admin.keyspace_master (uuid, keyspace_name, application_name, is_api, "
+                + "password, username, is_aaf) values (?,?,?,?,?,?,?)");
             queryObject.addValue(MusicUtil.convertToActualDataType(DataType.uuid(), newAid));
             queryObject.addValue(MusicUtil.convertToActualDataType(DataType.text(), keyspaceName));
             queryObject.addValue(MusicUtil.convertToActualDataType(DataType.text(), ns));