--Check the previous name and the application url before executing the updates --
UPDATE evsc_validation_service SET name = REPLACE(name, 'Schematron Based Validator', 'Schematron Management') WHERE keyword = 'Gazelle';
UPDATE evsc_validation_service SET wsdl = REPLACE(wsdl, 'http://localhost:8280/SchematronValidator-ejb/GazelleObjectValidatorService/GazelleObjectValidator?wsdl', 'https://gazelle.ihe.net/SchematronValidator-ejb/SchematronService/Schematron?wsdl') WHERE keyword = 'Gazelle';

--Check the application url before doing the insert--
INSERT INTO evsc_validation_service(id, available, description, engine, keyword, name, provider, report_name, wsdl, xsl_location)
    VALUES (nextval('evsc_validation_service_id_seq'), true, 'SchematronValidator tool', 'schematron', 'Schematron', 'Schematron Based Validator', 'IHE Europe', NULL , 'https://gazelle.ihe.net/SchematronValidator-ejb/SchematronValidatorService/SchematronValidator?wsdl', 'https://gazelle.ihe.net/xsl/EVSClient/Schematron/schematronResultStylesheet4EVSC.xsl');