25 November 2014

DBPING - a java-weblogic utility

There are ways to test DB connection from an application server, one of the most successful ways is to test as a java utility.

For running such utilities you need the proper environment to be set, You need to source the ssetWLSEnv.sh script in order to execute the script in the context of the running shell, and have the actual environment of the shell be set.

You have to execute as ". setWLSEnv.sh" and then you can check that the CLASSPATH is set with the "env" command.

and then you can begin dbping utility to check DB connectivity from the weblogic server

set domain environment as explained above & then initialize utility as:

 
 Usage: 
 java utils.dbping DB2B [-d dynamicSections] USER PASS HOST:PORT/DBNAME
 or     java utils.dbping DERBY        USER PASS HOST:PORT/DBNAME
 or     java utils.dbping JCONN2       USER PASS HOST:PORT/DBNAME
 or     java utils.dbping JCONN3       USER PASS HOST:PORT/DBNAME
 or     java utils.dbping JCONNECT     USER PASS HOST:PORT/DBNAME
 or     java utils.dbping INFORMIXB    USER PASS HOST:PORT/DBNAME/INFORMIXSERVER
 or     java utils.dbping MSSQLSERVERB USER PASS HOST:PORT/[DBNAME]
 or     java utils.dbping MYSQL        USER PASS [HOST][:PORT]/[DBNAME]
 or     java utils.dbping ORACLEB      USER PASS HOST:PORT/DBNAME
 or     java utils.dbping ORACLE_THIN  USER PASS HOST:PORT:DBNAME
 or     java utils.dbping POINTBASE    USER PASS HOST[:PORT]/DBNAME
 or     java utils.dbping SYBASEB      USER PASS HOST:PORT/DBNAME
 

--