Specifying Serena Release Automation Queries

You may specify SQL queries for the information you want returned from Serena Release Automation.

To specify the Serena Release Automation connection information:

  1. Navigate to the Serena Release Manager common Tomcat Web server classes folder. For example:

    C:\Program Files\Serena\common\tomcat\6.0\webapps\rlm\WEB-INF\classes

  2. Open the nolio-client-queries.properties file.

  3. Set the properties for the queries as follows:

    Parameter

    Value

    query.get.applications

    SQL queries to return the set of applications, environments, processes, and servers you want for the automation deployment tasks. For the default queries, see the example.

    query.get.environments

    query.get.processes

    query.get.servers

    query.find.application

    query.get.job.status

    message.application.not.found

    Message to send if applications aren’t found.

    message.environment.not.found

    Message to send if environments aren’t found.

Example

This example shows the default SQL queries for Serena Release Automation.

nolio-client-queries.properties

 

query.get.applications = select app_name  from applications where id!=1

query.get.environments = select name  from environments where id!=1 and applicationId = ?

query.get.processes    = select process_name from process_container pc, process_in_env pe where pc.id = pe.process_id and pe.environment_id = ? order by process_name

query.get.servers      = select s.server_name, st.server_type_name from servers s, server_types st, server_type_instance sti where s.id = sti.mapped_server and st.id = sti.server_type and sti.environment_id = ?

 

query.find.application = select id from applications where app_name = ?

query.find.environment = select id from environments where name = ? and applicationId = ?

 

query.get.job.status = select step_title,step_state from step_events where id in (select MAX(id) from step_events where job_id=?)

 

message.application.not.found = Could not find specified application: {0}

message.environment.not.found = Could not find specified environment: {0}