Forum Discussion

robjahn's avatar
robjahn
Contributor
13 years ago

[Res] Groovy script to get and set project JDBC connections

Looking for references or example of how to get and set the connection string, driver and name within groovy script. please include how access entry the specific entry by Name, assuming have multiple...
robjahn's avatar
robjahn
Contributor
12 years ago
I may have answered by own question.....but here is snippet that worked for me

def env = testRunner.testCase.testSuite.project.activeEnvironment.name;

if (env=='Default')
{
myDatabaseConnection1 = testRunner.testCase.testSuite.project.databaseConnectionContainer.getDatabaseConnectionByName('MYDATABASE')
log.info 'Updated activeEnvironment value is:' + testRunner.testCase.testSuite.project.activeEnvironment.name;
log.info 'Active Connection String for MUP is:' + myDatabaseConnection1.getConnectionString()
}
else
{
myDatabaseConnection = testRunner.testCase.testSuite.project.activeEnvironment.databaseConnectionContainer.getDatabaseConnectionByName('MYDATABASE')
log.info 'Updated activeEnvironment value is:' + testRunner.testCase.testSuite.project.activeEnvironment.name;
log.info 'Active Connection String for MUP is:' + myDatabaseConnection.getConnectionString()
}