Using a WebSphere® Application Server API or trace function, you can pass unique client information about every connection that originates from the same data source.
Application Server offers two methods of passing client information that provide the necessary connection management flexibility. Either method is used to set client information about some connections and not others, as well as set different client information about different database connections from the same data source.
Example: Setting client information with the setClientInformation(Properties) APIYou can set WebSphere Application Server client information on connections to pass that information to your database with this API.
The following example code calls setClientInformation(Properties) on the com.ibm.websphere.rsadapter.WSConnection object.
import com.ibm.websphere.rsadapter.WSConnection; ..... try { InitialContext ctx = new InitialContext(); //Perform a naming service lookup to get the DataSource object. DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/jdbc/myDS"); }catch (Exception e) {System.out.println("got an exception during lookup: " + e);} WSConnection conn = (WSConnection) ds.getConnection(); Properties props = new properties(); props.setProperty(WSConnection.CLIENT_ID, "user123"); props.setProperty(WSConnection.CLIENT_LOCATION, "127.0.0.1"); props.setProperty(WSConnection.CLIENT_ACCOUNTING_INFO, "accounting"); props.setProperty(WSConnection.CLIENT_APPLICATION_NAME, "appname"); props.setProperty(WSConnection.CLIENT_OTHER_INFO, "cool stuff"); conn.setClientInformation(props); conn.close()
Exceptions: This API creates an SQL exception if the database issues an exception when setting the data.
In this information ... | IBM Redbooks, demos, education, and more(Index) |