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
04-30-2001, 01:58 PM
* 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
public static void main (String args )
// Load the Oracle JDBC driver
// 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 =
// 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));
05-01-2001, 12:14 PM
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 ("jdbc:oracle:thin:@dlsun511:1721:dbms733",
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?