How to test JDBC connection from the command line?
Hi,
In various ad utilities log files I can see JDBC connections are made.
If it is possible; can someone let me know how to test the following from the command line?
JDBC URL: jdbc:oracle:thin:@testdbserver.testing.com:1521:TEST
Regards,
Richie.
For example: from an Autoconfig logfile
Database connection : Established
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL=''
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : testdbserver
sDbDomain : testing.com
sDbPort : 1521
sDbSid : TEST
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@testdbserver.testing.com:1521:TEST
In various ad utilities log files I can see JDBC connections are made.
If it is possible; can someone let me know how to test the following from the command line?
JDBC URL: jdbc:oracle:thin:@testdbserver.testing.com:1521:TEST
Regards,
Richie.
For example: from an Autoconfig logfile
Database connection : Established
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL=''
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : testdbserver
sDbDomain : testing.com
sDbPort : 1521
sDbSid : TEST
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@testdbserver.testing.com:1521:TEST
Tagged:
0