Saturday, January 8, 2022

Rule to create a table in database

import org.apache.log4j.Logger;
import org.apache.log4j.Level;
import sailpoint.plugin.PluginBaseHelper;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


Logger log = Logger.getLogger("sailpoint.rules.CreatePluginDBTable");
log.setLevel(Level.DEBUG);
log.debug("-----------------------------------");

ResultSet resultSet = null;
PreparedStatement preparedStatement = null;
try{
Connection connection = PluginBaseHelper.getConnection();
log.debug("Connection established to DB: " + connection.getCatalog());
String createTableQuery = "CREATE TABLE Tablename(column1 varchar(255)); ";
preparedStatement = connection.prepareStatement(createTableQuery);
log.debug("Executing the query: " +createTableQuery);
preparedStatement.execute();
} catch(Exception e){
log.error("Exception occurred: " +e);
}
connection.close();

No comments:

Post a Comment

Form AllowedValues rule to filter Identities with Active Regular Active Directory accounts and identity is active and correlated

 The rule type is AllowedValues. import org.apache.log4j.Level ; import org.apache.log4j.Logger ; import sailpoint.object.Filter ; import sa...