Forum Discussion
robjahn
14 years agoContributor
I can try that approach, but was looking to change the configurations established from the wizard. Using your example on the blog....I want to change the values for the connection "loadTestDB" from groovy Code. If I look in my project.XML (pro 4.01)....I see these configuaration infomation (in my case 2 oracle grid connections ... one called A and one called B)...I would think there is some what to get and set the various values like "connectionString" and "Password". how might I achieve this?
<con:databaseConnectionContainer>
<con:databaseConnection>
<con:name>A</con:name>
<con:driver>oracle.jdbc.driver.OracleDriver</con:driver>
<con:connectionString>jdbc:oracle:thin:user/password@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = server.com)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = servicename)))
</con:connectionString><con:password>password</con:password>
</con:databaseConnection><con:databaseConnection>
<con:name>B</con:name>
<con:driver>oracle.jdbc.driver.OracleDriver</con:driver>
<con:connectionString>jdbc:oracle:thin:muser/password@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = server.com)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = servicename)))</con:connectionString><con:password>password</con:password>
</con:databaseConnection>
</con:databaseConnectionContainer>
<con:databaseConnectionContainer>
<con:databaseConnection>
<con:name>A</con:name>
<con:driver>oracle.jdbc.driver.OracleDriver</con:driver>
<con:connectionString>jdbc:oracle:thin:user/password@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = server.com)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = servicename)))
</con:connectionString><con:password>password</con:password>
</con:databaseConnection><con:databaseConnection>
<con:name>B</con:name>
<con:driver>oracle.jdbc.driver.OracleDriver</con:driver>
<con:connectionString>jdbc:oracle:thin:muser/password@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = server.com)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = servicename)))</con:connectionString><con:password>password</con:password>
</con:databaseConnection>
</con:databaseConnectionContainer>