What I would like to select a database before starting up a server during development (using STS 2.6.1 on XP).
I have defined several data sources, using " File > New > Other > Connection Profiles > Connection Profile ". These are OracleThinDriver using an ojdbc14.jar . One of them has been designated to connect every time the workbench starts up. They show up in Data Source Explorer and I can Ping them OK. If I select "connect" one, it then does indicate it is in connected status.
However, it is not used by the server when it starts up. What is being used (and works) is the definition found in the META-INF\context.xml file in my Dynamic Web Project. Even when my project is running on the server, the Data Source Explorer indicates a different db is connected. So it is not in sync with the current server instance.
Now when I run this project in jDeveloper & oc4j, selecting a data source basically causes the jDev equivalent of context.xml to be rewritten.
Is there a similar linking mechanism in STS, so I could dynamically select a data source?