FreeKB - IBM WebSphere Create J2C alias
IBM WebSphere - Create J2C alias

  1. In the WebSphere admin console, expand Resources > JDBC or Resoruces > JMS.
  2. Select any resource.
  3. Select JAAS - J2C authentication data.
  4. Select New.
  5. Give the J2C alias a name and define the username and password. Select OK.
  6. Select Save.

 

In this example, a J2C alias named mySQL is created.

 

On the WebSphere server, the J2C aliases you've created will be in the security.xml file.

 


IBM WebSphere - JDBC data source and J2C alias

Configure a Java app to use a JDBC

Connect to a SQL database via DataSource

Connect to a SQL database via DriverManager

 


At Monitoring and Tuning > Performance Viewer > Current activity > your application server > Summary Reports > JDBC Connection Pools > your JDBC provider > your JNDI, the connection count should be 1 for the single connection to the database.



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter 72bc0 in the box below so that we can be sure you are a human.




Comments

Web design by yours truely - me, myself, and I   |   jeremy.canfield@freekb.net   |