public class OracleDS {

    /**
     * @param args the command line arguments
     */
    public static void oracleConnection() throws SQLException {
        OracleDataSource ods = new OracleDataSource();
        ods.setTNSEntryName("orclTest");
        ods.setDriverType("oci8");

        ods.setUser("myUser");
        ods.setPassword("myPass");

        Connection conn = ods.getConnection();

        System.out.println("Oracle Connected");
    }

    public static void sqlServerConnection() throws SQLException {
        SQLServerDataSource ss = new SQLServerDataSource();


        ss.setServerName("myServer");
        ss.setDatabaseName("testDB");


        ss.setUser("myUser");
        ss.setPassword("myPass");

        Connection conn = ss.getConnection();

        System.out.println("SqlServer Connected");
    }

    public static void main(String[] args) throws SQLException {
        sqlServerConnection();
        oracleConnection();
    }
}

bcm@bcm-laptop:~$ cat Conn.java
import java.sql.*;
class Conn {
  public static void main (String[] args) throws Exception
  {
   Class.forName ("oracle.jdbc.OracleDriver");

   Connection conn = DriverManager.getConnection
     ("jdbc:oracle:thin:@//localhost:1521/v112", "scott", "tiger");
                        // @//machineName:port/SID,   userid,  password
   try {
     Statement stmt = conn.createStatement();
     try {
       ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
       try {
         while (rset.next())
           System.out.println (rset.getString(1));   // Print col 1
       } 
       finally {
          try { rset.close(); } catch (Exception ignore) {}
       }
     } 
     finally {
       try { stmt.close(); } catch (Exception ignore) {}
     }
   } 
   finally {
     try { conn.close(); } catch (Exception ignore) {}
   }
  }
}
bcm@bcm-laptop:~$ javac Conn.java
bcm@bcm-laptop:~$ export CLASSPATH=/u01/app/oracle/product/11.2.0/dbhome_1/owb/wf/lib/ojdbc14.jar:.
bcm@bcm-laptop:~$ java Conn
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
bcm@bcm-laptop:~$