Name

global.ConnectionTestAjax

Description

No description available

Script

var ConnectionTestAjax = Class.create();

ConnectionTestAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
  	
  ajaxFunction_testConnectionJdbc: function() {	
  	
  	var grConnection = new GlideRecord("jdbc_connection");
  	
  	if(!grConnection.isValid()){
  		gs.logWarning("jdbc_connection doesnt exist.");
  		return;
  	}
  	if (!grConnection.canRead()) {
          gs.logWarning("Insufficient privileges to test JDBC connection.");
          return;
      }
  	
  	var credentialId = this.getParameter("sysparm_credential_id");
  	var url = this.getParameter("sysparm_url");
  	var dbDriver = this.getParameter("sysparm_db_driver");	
  	
  	var userName = "";
  	var pwd = ""; 
  	
  	var credentialData = this._getCredentialData(credentialId);		
  	if (!gs.nil(credentialData)) {		
  		userName = credentialData.user_name;		
  		pwd = credentialData.password;
  	}
  	
  	return SNC.ConnectionTest.testJdbc(dbDriver, url ,userName, pwd );
  },
  
  _getCredentialData: function(credSysId){	
  	var provider = new sn_cc.StandardCredentialsProvider(); 
  	var credential = provider.getCredentialByID(credSysId); 
  	if (gs.nil(credential))
  		return null;
  	
  	var credentialData = {};
  	credentialData["user_name"] = credential.getAttribute("user_name");
  	credentialData["password"] = credential.getAttribute("password");		
  			
  	return credentialData;		
  },
  
  type: 'ConnectionTestAjax'
});

Sys ID

e9db38502f173200350002d3c18c95fc

Offical Documentation

Official Docs: