Check if datasource is up in WebLogic

weblogic weblogic-10.x
Ahmet Karakaya picture Ahmet Karakaya · Nov 8, 2013 · Viewed 27k times · Source

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,

Answer

javabrett picture javabrett · Feb 19, 2015

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 questions

how to change listen port from default 7001 to something different?

Can anyone tell me how to change the default listening port of Weblogic 10.3 to something different? I saw some posts on discussion boards which say that change it under ...//config/config.xml. Even I thought so, but surprisingly, there is …

Read More
How to force Weblogic to start deployments in active state (i.e. not just prepared)

When I start a Weblogic instance with a deployed application, the deployment is sometimes left in prepared state, not in active state. I have to go to Weblogic Console and start the deployment manually, which is quite slow and annoying …

Read More
Where is WebLogic Jar containing javax.servlet in 10.3?

I am trying to configure my path to include javax.servlet with WebLogic. WebLogic has split out the Jar files, so which one contains javax.servlet?

Read More