Check if datasource is up in WebLogic

weblogicweblogic-10.x

How may I check if datasource is up in Weblogic 10.3 menu. Is there a "ping" button link Glassfish ?
in Monitoring->Testing menu there is no Server definition though there is a admin server in target defined,

Best Answer

In order to see a Server/State and Test Data Source action listed under Services -> Data Sources -> <your datasource> -> Monitoring (Tab) -> Testing (Tab), all of the following need to be true:

  • At least one server targeted by the Data Source needs to be running. If the AdminServer is not targeted, this might not be true - visit Environment -> Servers and check that the targeted server(s) are RUNNING.
  • The Data Source's Configuration -> Connection Pool -> (Advanced) "Test Connections On Reserve" must be checked/true
  • You need to have a table-name configured in Test Table Name or an SQL statement e.g. SQL SELECT 1 FROM DUAL.

You should then see the targeted servers listed in the Monitoring/Testing tab.

Related Topic