title: How to set database connection name when connecting to Sybase with Websphere datasource
body: <p>We have created a web application which uses datasource defined in Websphere to connect to Sybase database. Since we have defined many jobs within the application, we need to monitor how many connections each job uses.</p>
  
  <p>When we check the sybase processes in database when the jobs were running, <code>SELECT * FROM master..sysprocesses</code>
  all the connections have <code>program_name</code> column value as <code>com.ibm.ws.util.ThreadPool</code> </p>
  
  <p>Is there anyway that we can set/change this value(like the <code>jobname</code> may be) while making connections to database so that we would know what connections are used by what jobs?</p>
  
  <pre><code>Database - Sybase ASE 15.7
  App Server - Websphere 7
  Application Runtime - Java 6
  Application Framework - Spring 3
  Database Driver - Jconnect 7
  </code></pre>
  
  <p>will the <code>setClientInfo</code> method of Connection class can be of any help to set the programe_name value?</p>