/**
   JdbcTest - Test a JDBC connection

   Usage: java JdbcTest driver url user passwd
   Example: java JdbcTest org.postgresql.Driver jdbc:postgresql:sullivan \
                                 sullivan -not-required-

   Note the SQL currently hard-coded in the program assumes
   PostgreSQL. For something like Oracle, for example, you'ld have to
   do your select on dual.

   @author Martin Sullivan, ZOIS Ltd., January, 2003.
   @version $Id: JdbcTest.java,v 1.1 2003/01/15 17:03:40 sullivan Exp $
*/

/*
$Log: JdbcTest.java,v $
Revision 1.1  2003/01/15 17:03:40  sullivan
Initial revision

*/

import java.sql.*;

public class JdbcTest {
    static final String SQL = "select upper ('foo') as result";

    public static void main (String argv[]) {
	
	Connection con = null;

	if (argv.length != 4) {
	    System.err.println ("usage: JdbcTest driver url user passwd");
	    return;
	} // if 

	try {
	    Class.forName (argv[0]);
	} catch (Exception e) {
	    System.err.println ("Failed to load driver");
	    e.printStackTrace ();
	    return;
	} // catch

	try {
	    con = DriverManager.getConnection (argv[1], argv[2], argv[3]);
	    System.out.println ("connected");
	} catch (Exception e) {
	    System.err.println ("Failed to connect");
	    e.printStackTrace ();
	    return;
	} // catch

	try {
	    PreparedStatement sql = con.prepareStatement (SQL);
	    ResultSet results = sql.executeQuery ();
	    if (results.next () == false) {
	       	System.out.println ("No rows");
    	    } // if

	    System.out.println (results.getString ("result"));
	} catch (Exception e) {
	    System.err.println ("Failed to execute");
	    e.printStackTrace ();
	    return;
	} // catch

	
    } // main
} // JdbcTest