GrouperShell (gsh) gc db access (GcDbAccess)
Use this class to get access to the global database connections, create a new connection, and execute sql against them.
Sample call
Timestamp lastSuccess = new GcDbAccess().sql("select max(ended_time) from grouper_loader_log where job_name = ?") .addBindVar("CHANGE_LOG_consumer_recentMemberships").select(Timestamp.class);
From a database external system
Integer theOne = new GcDbAccess().connectionName("externalSystemConfigId").sql("select 1 from dual") .select(Integer.class);