Getting Error while Saving Groovy Data Source

General
#1

Hi Team,
I am working on dynamic switching.
Test Connection is Successful
but while Saving Groovy Data Source,
I am getting following error
“Access Denied. You don’t have sufficient privileges to access the requested resource.”

groovy
groovy1059×569 51.1 KB

Can you provide solution for the same

#2

Hi team.
Can you explain or correct this.
I don’t understand Bold Statement.

<![CDATA[ import groovy.sql.Sql; import net.sf.json.JSONObject; import com.helicalinsight.adhoc.metadata.GroovyUsersSession; public JSONObject evalCondition() { JSONObject responseJson = new JSONObject(); String orgName = GroovyUsersSession.getValue('${org}.name'); orgName = orgName.replaceAll("'",""); **sql=Sql.newInstance('jdbc:mysql://localhost:3306/details', 'hiuser', 'hiuser', 'com.mysql.jdbc.Driver');** sql.eachRow( 'select * from details' ) { 
	   if(orgName.equalsIgnoreCase(it.organization)){
	     responseJson.put("driver",it.driver);
	     responseJson.put("url",it.url);
	     responseJson.put("user",it.user);
	     responseJson.put("password",it.password);
	   }
          }
          return responseJson;
      }
    ]]>
       </Condition>
#3

sql=Sql.newInstance(‘jdbc:mysql://localhost:3306/details’, ‘hiuser’, ‘hiuser’, ‘com.mysql.jdbc.Driver’);

#4

I have received this error while testing Groovy Data Source Connection.
Error: SQLException: No suitable driver found for jdbc:oracle:thin:@db.ezlytix.com:1526:EZTES