修改service_name

最新推荐文章于 2023-09-22 17:41:43 发布
转载 最新推荐文章于 2023-09-22 17:41:43 发布 · 183 阅读 · 0

本文详细介绍了如何使用ALTERSYSTEM命令设置Oracle数据库的服务名称，并通过SHOWPARAMETERS命令查看服务参数，提供了数据库管理员进行服务配置的实用指南。
alter system set service_names='orcl.254.145.111,orcl';
show parameter service_name;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30201626/viewspace-1813757/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30201626/viewspace-1813757/

ctrw1933
关注
Oracle-CDB容器数据库修改service_names踩坑
sinat_36757755的博客
12-04 1973
最近在对一套Oracle容器数据库进行迁移测试时，为了保持新环境与旧环境的服务名一致，需要在新环境添加旧环境的服务名，在CDB的根容器通过service_name参数添加旧环境的服务名之后，发现数据库PDB的服务名全部被注销，pdb容器也无法再正常的切换过去，因此，对容器数据库的服务名设置进行了测试，以下为测试的内容结果
Oracle创建PDB及配置SID与service_name
果果的小莴笋
09-05 4773
Oracle创建PDB及配置SID与service_name
如何修改 service_name
Lixora's DB Home
11-22 3461
如何修改 service_name 原有环境： sid： mynewdb global_name：mynewdb service_names： MYNEWDB db_domain  ： db_name：mynewdb 需要修改后如下： global_name：mynewdb service_names： test db_domain  ： db_name：mynewdb
ORACLE修改service_name服务名
m0_49562857的博客
09-22 2828
【代码】ORACLE修改service_name服务名。
修改 service_name
实施工程师从入门到放弃
10-30 1167
https://www.2cto.com/kf/201311/259856.html
修改 添加 service_name
热门推荐
食肉动物的专栏
06-08 1万+
1.db_name:数据库名称,数据库创建好后不可以修改,除非使用nid(9i之后的版本)更改.   2.oracle_sid: 数据库实例名称,同一个db_name可以对应多个oracle_sid,数据库创建好后会自动在$ORACLE_HOME/dbs创建init+oracle_sid,orapw+oracle_id,spfile+oracle_sid这些文件.   3.service_
oracle service_name参数
05-07
### Oracle Service_Name 参数详解 #### 一、概述 在Oracle数据库管理中，`service_name`是一个重要的参数，它用于标识数据库实例所提供的服务名称。通过设置正确的`service_name`，可以确保客户端应用程序能够...
oracle19c单机修改DB_NAME INSTANCE_NAME、PDB
qq_41270538的博客
06-05 2406
oracle 19C 单实例修改DB_NAME、INSTANCE_NAME、PDB
SERVICE _ NAME
07-14
其中 `SCOPE=BOTH` 表示同时修改内存和参数文件，使更改立即生效并持久化。 #### 在 TNS 配置中使用 SERVICE_NAME 在 `tnsnames.ora` 文件中配置连接描述时，可以使用 `SERVICE_NAME` 来指定目标数据库服务。例如...
配置servicename
rede
06-14 2025
运行db的sqlplus：sqlplus sys/sys as sysdba （sys/sys为“用户名”/“密码”） 或配置client的监听后运行Client的sqlplus 查看当前服务名：SQL> show parameter service_name 修改服务名：SQL> alter system set service_names=‘orcl’ scope=both; 修改...
service_names 参数更改方法
corq85834770的博客
08-11 521
-- 更改服务名的方法 点击(此处)折叠或打开 SQL> alter system set service_names = 'ORA11GR2'...
oracle修改global_name和service_name
liuno0的博客
03-09 1728
安装oracle的时候会制定db_domain，制定db_domain后service_name和global_name都会加上这个domain,此时在配置tns file以及easy connect的时候都要service_name很复杂 sqlplus / as sysdba 在自己的测试库上，感觉没有必要。 首先尝试修改global_name，因为service_name默认是global_name,而global_name=db_name.db_domain SQL> show pa
axis service没有配置namesapce 如何设置QName namesapce
dos_186的博客
08-27 623
QName opTest = new QName("","test");
Oracle修改SERVICE_NAME
木子李的博客
04-24 5496
查询参数 SQL> show parameter service_name; 修改新参数 SQL> alter system set service_names='mema_new'; 查看是否成功 [oracle@mematest ~]$ lsnrctl status;
Oracle，修改 GLOBAL_NAME 和 SERVICE_NAME
iw1210的专栏
08-22 6597
Oracle，修改 GLOBAL_NAME 和 SERVICE_NAME
UPDATE tbl_micro ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID' at line 1 ### The error may exist in com/huawei/it/gaia/apigc/infrastructure/mapper/IInvokeRelationMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID' at line 1 ; bad SQL grammar [解释下为什么报错
最新发布
11-18
WHERE PROVIDER_MICRO_SERVICE_NAME = #{microSvcRel.key} AND PROVIDER_MICRO_SERVICE_ID != #{microSvcRel.value} ; <!-- 另外两个表同理 --> 但是，这样写会在每个foreach循环结束后添加一个分号（因为...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值