trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hzel...@apache.org
Subject [09/37] incubator-trafodion git commit: replace schema with prefix DB__
Date Tue, 01 Mar 2016 22:35:55 GMT
replace schema with prefix DB__


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/0c4f84b6
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/0c4f84b6
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/0c4f84b6

Branch: refs/heads/master
Commit: 0c4f84b6ed3e1976e7aebe0d8701ec60413b767e
Parents: e4ea1ca
Author: Kevin Xu <kaihua.xu@esgyn.cn>
Authored: Wed Dec 23 13:34:59 2015 +0800
Committer: Kevin Xu <kaihua.xu@esgyn.cn>
Committed: Wed Dec 23 13:34:59 2015 +0800

----------------------------------------------------------------------
 .../lib_mgmt/src/main/resources/init_libmgmt.sh | 23 ++++++++++----------
 1 file changed, 12 insertions(+), 11 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/0c4f84b6/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh
----------------------------------------------------------------------
diff --git a/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh b/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh
index 9dd16b1..821590a 100644
--- a/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh
+++ b/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh
@@ -23,11 +23,12 @@
 SERVER_JAR=${MY_SQROOT}/export/lib/spj_mgmt.jar
 CI=sqlci
 CATALOG_NAME=TRAFODION
-CIS_SCHEMA="_LIBMGR_"
+LIB_SCHEMA="DB__LIBMGR"
 DB__LIBMGRROLE=DB__LIBMGRROLE
+LIB_NAME=DB__LIBNAME
 
 function dropAndCreateSchema {
-    echo "Creating Schema for SPJ_MGMT"
+    echo "Creating Schema for ${LIB_SCHEMA}"
     ${CI} << sqlciEOF
 
       cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
@@ -54,15 +55,15 @@ function createProcedures {
       -- Creating Procedures 
       set schema $CATALOG_NAME.$CIS_SCHEMA; 
 
-      DROP LIBRARY SPJMGMT CASCADE;
-      CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}';
+      DROP LIBRARY ${LIB_NAME} CASCADE;
+      CREATE LIBRARY ${LIB_NAME} FILE '${SERVER_JAR}';
       CREATE ROLE ${DB__LIBMGRROLE};
    
       CREATE PROCEDURE HELP (
       INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.help (java.lang.String[])'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA
@@ -75,7 +76,7 @@ function createProcedures {
       IN CREATEFLAG INTEGER)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.put(java.lang.String,java.lang.String,int)'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA
@@ -87,7 +88,7 @@ function createProcedures {
       OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.ls(java.lang.String,java.lang.String[])'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA
@@ -98,7 +99,7 @@ function createProcedures {
       OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.lsAll(java.lang.String[])'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA
@@ -109,7 +110,7 @@ function createProcedures {
       IN FILENAME VARCHAR(256) CHARACTER SET ISO88591)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.rm(java.lang.String)'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA
@@ -121,7 +122,7 @@ function createProcedures {
       OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.rmRex(java.lang.String, java.lang.String[])'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA
@@ -135,7 +136,7 @@ function createProcedures {
       OUT DATALENGTH LARGEINT)
       EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.get (java.lang.String,int,java.lang.String[],long[])'
       EXTERNAL SECURITY DEFINER
-      LIBRARY SPJMGMT
+      LIBRARY ${LIB_NAME}
       LANGUAGE JAVA
       PARAMETER STYLE JAVA
       READS SQL DATA


Mime
View raw message