//stored procedure to update project configuration.
String updateProjectCache="";
String connectQuery= ("CONNECT SERVER \"" +
server + "\" USER \"" + user + "\" PASSWORD \"" + password + "\" PORT 34952;");
execute(connectQuery);
ResultSet projectRS = executeCapture("LIST PROJECTS;" );
projectRS.moveFirst();
while (!projectRS.isEof() )
{
printOut("Applying Evolv Project Configuration On Project" + projectRS.getFieldValueString(DisplayPropertyEnum.NAME));
if (projectRS.getFieldValueString(2).equals("Loaded"))
{
updateProjectCache="ALTER PROJECT CONFIGURATION " +
"MAXNOREPORTRESULTROWS 100000 " +
"MAXNOELEMROWS 100000 " +
"MAXNOINTRESULTROWS 100000 " +
"MAXJOBSUSERACCT 1000 " +
"MAXJOBSUSERSESSION 1000 " +
"MAXEXECJOBSUSER 1000 " +
"MAXJOBSPROJECT 1000 " +
"MAXUSERSESSIONSPROJECT 500 " +
"IN PROJECT \"" +
projectRS.getFieldValueString(DisplayPropertyEnum.NAME) + "\"; ";
execute(updateProjectCache);
}
projectRS.moveNext();
}//end of project
execute("DISCONNECT SERVER;");
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment