How to test JDBC thin client connections?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to test JDBC thin client connections?

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    How can I test the connections between a JDBC thin client and database?

    Is there a simple test to test the connections between a JDBC thin client to the database (on a database server). Because there is no Oracle Client on the Client PC, I can't use tnsping or sqlplus to test the connection. How to I test this connection? Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    /*
    * This sample shows how to list all the names from the EMP table
    *
    * It uses the JDBC THIN driver. See the same program in the
    * oci8 samples directory to see how to use the other drivers.
    */

    // You need to import the java.sql package to use JDBC
    import java.sql.*;

    class Employee
    {
    public static void main (String args [])
    throws SQLException
    {
    // Load the Oracle JDBC driver
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    // Connect to the database
    // You must put a database name after the @ sign in the connection URL.
    // You can use either the fully specified SQL*net syntax or a short cut
    // syntax as ::. The example uses the short cut syntax.
    Connection conn =
    DriverManager.getConnection ("jdbc:oracle:thin:@dlsun511:1721:dbms733",
    "scott", "tiger");

    // Create a Statement
    Statement stmt = conn.createStatement ();

    // Select the ENAME column from the EMP table
    ResultSet rset = stmt.executeQuery ("select ENAME from EMP");

    // Iterate through the result and print the employee names
    while (rset.next ())
    System.out.println (rset.getString (1));
    }
    }
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Thanks for this info. We have something similar to this, but if the connection fails to the database it just errors with:
    Cannot connect to DBstore ("jdbcracle:thin:@dlsun511:1721:dbms733",
    "scott", "tiger");

    We wanted a test to give a error like an ORA or TNS error number. Or something like tnsping or sqlplus. We wanted to do this test without loading Oracle Client. Is this the only solution?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width