Forum Discussion

Andrew_Shirshac's avatar
Andrew_Shirshac
New Contributor
16 years ago

Re: Specifying 1 of many JDBC connections and end point at project level

We have several environments that our services run in and I want to specify which environment is under test at the project level, so  I don't have to change each test suite individuall.  Each envirion...
Andrew_Shirshac's avatar
Andrew_Shirshac
New Contributor
16 years ago
That's exactly it and would be ideal.

I think a version of it already works. I tried using the following in the 'ConnectionString' property.

jdbc:oracle:thin:userid1/PASS_VALUE@${#Project#projectHost}:${#Project#projectPort}:${#Project#projectSid}

of a ConnectionSource called: ProjectConnectionSource

and then separately set the values for:

${#Project#projectHost}
${#Project#projectPort}
${#Project#projectSid}

and that worked as a simple test. Next I would need to conditionally set them (and the endpoint) based on some 'EnvironmentProperty'.

Then I should be able to use ProjectConnectionSource in all the data steps.