I am trying to integrate unit test SQL developer with team city. i want to run test cases from command prompt on build server.Command to run test is having parameter called '-db' where we pass connection name of owner.As there will be a new user for each build so i can not graphically login every time to create a connection name. Can you give me better option by which that connection name will be automatically created or instead of connection name, schema name will work ? Is there any way by which for every new schema i can automatically create connection name ?
In the help document i found an option 'CREATE LOCAL CONNECTION' which will create connections for all unblocked users of an instance on local system. but that option is also not working.
If you're trying to do this in an automated fashion, then why use SQL Developer at all? You can use good old-fashioned SQL*Plus or SQL Developers new SQLCI.