[ https://issues.apache.org/jira/browse/TRAFODION-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039632#comment-15039632 ]
ASF GitHub Bot commented on TRAFODION-1668: ------------------------------------------- Github user robertamarton commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/203#discussion_r46643346 --- Diff: core/conn/spj_init/src/main/resources/init_spj.sql --- @@ -0,0 +1,156 @@ +#!/bin/bash +# @@@ START COPYRIGHT @@@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, +# software distributed under the License is distributed on an +# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +# KIND, either express or implied. See the License for the +# specific language governing permissions and limitations +# under the License. +# +# @@@ END COPYRIGHT @@@ + +SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar +CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog +SQLCI=${MY_SQROOT}/export/bin32/sqlci +CP=/bin/cp +MANAGEABILITY_CATALOG=TRAFODION +CIS_SCHEMA=DEFAULT_SPJ + + +function dropAndCreateSchema { + echo "Creating Schema for CI Server Component" + sqlci << sqlciEOF + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; + + DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE; + CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA; + --- End diff -- Do you want to add an authorization clause to the CREATE SCHEMA, for example AUTHORIZATION DB__ROOT. This will make sure DB__ROOT is the schema owner. > Cannot upload customer SPJ JARs > ------------------------------- > > Key: TRAFODION-1668 > URL: https://issues.apache.org/jira/browse/TRAFODION-1668 > Project: Apache Trafodion > Issue Type: Improvement > Reporter: Kevin Xu > Assignee: Kevin Xu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)