Technology Stack - EBS (MOSC)

MOSC Banner

How to test JDBC connection from the command line?

edited Apr 17, 2013 6:28AM in Technology Stack - EBS (MOSC) 5 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center