Error: Request for the permission of type ‘SqlStatementExecutePermission’ failed.

This error occurs when running  “statement.executeQuery(sqlString);” from a job.  Once the code is put in a class to run on the server, it works fine.  For example:server static void main(Args _args)
{
    Connection connection = new Connection();
    Statement statement = connection.createStatement();
    str sqlString = ‘select * from custTable’;
    ;

    new SqlStatementExecutePermission(sqlString).assert();
    statement.executeQuery(sqlString);
    CodeAccessPermission::revertAssert();
}

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: