WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

how to find which application is using which JDBC datasource?

  • 1.  how to find which application is using which JDBC datasource?

    Posted Wed August 11, 2010 10:37 AM
    how to find which application is using which JDBC datasource?

    --------------------------------

    i have this qurey where i want to know which applicaiton is accessing which database.
    Actully in my environment we have 45 applicaitons and each applicaiton is using diffent JDBC datasource
    Now we want to migrate some of the apps to our newer environment, but we dont have proper documnetation of apps and JDBC datasource flow.
    so could anyone help me find the which app is accessing which JDBC datasource.

    any help will be highly appreciated

    --------------------------------

    Posted By: joydebnath at Jun 23 2009 7:41PM


  • 2.  how to find which application is using which JDBC datasource?

    Posted Wed August 11, 2010 10:45 AM
    Hope this might help..

    You can find the list of datasources and its associated JVMs using wsadmin scripts below.

    run the wsadmin client from the WAS profiles bin directory.

    /wsadmin.sh -lang jython
    wsadmin>

    In the prompt type the following command, it is case sensitive.

    wsadmin>AdminConfig.list('DataSource')

    --------------------------------

    Posted By: nitsee at Jul 10 2009 3:52PM