Hi James,
Here is the query that i used,
select count(*) from ssg.published_service where routing_uri=${validateuri} and disabled="0";
validateuri is the uri i want to check for conflicts and this is sent through a post parameter.
${jdbcQuery.ResolutionCount} is returned to the UI using Return Template Response. ResolutionCount=0 means that the service resolves without any issues.
Thanks