User Code List
SQL
---Recreate Caliburn
---Recreate pakis in dev-server2
---Customize servers
---Kill an oracle session
---New Snippet
---New Snippet
---New Snippet
JRuby
---Instance user
---Run test
---Receive replication messages
------New Snippet
---Send replication
---Replication unit scripts
New Snippet
PostgreSQL
---Create drop users
 
 
Customize servers
 

UPDATE "PAKI2"."CA_CONFIGURATIONVALUE" SET VALUE = 'RS1' WHERE KEY='currentServer';

UPDATE "PAKI3"."CA_CONFIGURATIONVALUE" SET VALUE = 'RS2' WHERE KEY='currentServer';

UPDATE "PAKI4"."CA_CONFIGURATIONVALUE" SET VALUE = 'CS1' WHERE KEY='currentServer';

UPDATE "PAKI1"."CA_CONFIGURATIONVALUE" SET VALUE = 'false' WHERE KEY='isBiometricLogin';

UPDATE "PAKI2"."CA_CONFIGURATIONVALUE" SET VALUE = 'false' WHERE KEY='isBiometricLogin';

UPDATE "PAKI3"."CA_CONFIGURATIONVALUE" SET VALUE = 'false' WHERE KEY='isBiometricLogin';

UPDATE "PAKI4"."CA_CONFIGURATIONVALUE" SET VALUE = 'false' WHERE KEY='isBiometricLogin';

UPDATE "PAKI4"."CA_CONFIGURATIONVALUE" SET VALUE = 'RS1' WHERE KEY='syncTarget';

UPDATE "PAKI1"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8081', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='HQ';

UPDATE "PAKI1"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8082', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS1';

UPDATE "PAKI1"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8083', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS2';

UPDATE "PAKI1"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8084', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='CS1';

UPDATE "PAKI2"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8081', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='HQ';

UPDATE "PAKI2"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8082', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS1';

UPDATE "PAKI2"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8083', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS2';

UPDATE "PAKI2"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8084', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='CS1';

UPDATE "PAKI3"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8081', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='HQ';

UPDATE "PAKI3"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8082', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS1';

UPDATE "PAKI3"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8083', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS2';

UPDATE "PAKI3"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8084', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='CS1';

UPDATE "PAKI4"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8081', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='HQ';

UPDATE "PAKI4"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8082', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS1';

UPDATE "PAKI4"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8083', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='RS2';

UPDATE "PAKI4"."CA_SERVERDATA" SET HOSTNAME = 'ws-rdecastro.biometrics.local', PORT = '8084', FACE_IDENT_HOSTNAME='dc-server', FACE_IDENT_SYNC_ELAPSE = '60' WHERE CA_SERVERDATA.KEY='CS1';

commit;
 
Sub-Article List