Example: Setting client information with the setClientInformation(Properties) API
You 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()
Parameters
props contains the client information to be passed. Possible values are:
- WSConnection.CLIENT_ACCOUNTING_INFO
- WSConnection.CLIENT_LOCATION
- WSConnection.CLIENT_ID
- WSConnection.CLIENT_APPLICATION_NAME
- WSConnection.CLIENT_OTHER_INFO
- WSConnection.OTHER_CLIENT_TYPE
Exceptions
This API creates an SQL exception if the database issues an exception when setting the data.
Passing client info to a db cdat_clientinfo