JDBC

String url = "jdbc:oracle:thin:@myhost:1521:orcl";
import java.sql.*;
class Conn {
  public static void main (String args []) throws SQLException
  {
        DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

        Connection conn = DriverManager.getConnection
            ("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
                            // @machineName:port:SID,   userid,  password

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();
  }
}
 
  
  
  
  

   
   

    
    

     
     

     
     
JDBC

     
     

      
      
From Oracle FAQ

      
      


      
      

       
       Jump to: 
       
       navigation, 
       
       search
      
      
      
      

      
      
JDBC is a set of classes and interfaces written in Java that allows Java programs to send SQL statements to a database like Oracle. 

      
      
<script type=text/javascript> if (window.showTocToggle) { var tocShowText = "show"; var tocHideText = "hide"; showTocToggle(); } </script>

      
      

      
      
[edit] 
JDBC drivers

      
      
Oracle provides three categories of JDBC drivers: 

      
      
JDBC Thin Driver (no local SQL*Net installation required/ handy for applets) 
JDBC OCI for writing stand-alone Java applications 
JDBC KPRB driver (default connection) for Java Stored Procedures and Database JSP's. 

      
      
All three drivers support the same syntax and API's. Oracle needs three 
drivers to support different deployment options. Looking at the source code, 
they will only differ in the way you connect to the database. Remember, you must 
use a JDBC version that matches the version of your Java Development Kit. 
      
      

      
      
[edit] 
Thin driver 

      
      
Oracle's JDBC Thin driver uses Java sockets to connect directly to Oracle. It 
provides its own TCP/IP version of 
Oracle's SQL*Net protocol. Because 
it is 100% Java, this driver is platform independent and can also run from a Web 
Browser (applets). 

      
      
Sample connect string: 
      
      
String url = "jdbc:oracle:thin:@myhost:1521:orcl";


      
      
The connection string for Oracle XE (version 10g) is: 
      
      
String url = "jdbc:oracle:thin:@myhost:1521:xe";


      
      
You can find the SID name in your tnsnames.ora file: 
      
      
XE =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = XE)
   )
 )


      
      
Working example program (Conn.java): 
      
      
import java.sql.*;
class Conn {
  public static void main (String args []) throws SQLException
  {
        DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

        Connection conn = DriverManager.getConnection
            ("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
                            // @machineName:port:SID,   userid,  password

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();
  }
}

      
      

      
      
[edit] 
OCI driver 

      
      
Oracle's JDBC OCI drivers uses Oracle OCI 
(Oracle Call Interface) to interact with an Oracle database. You must use a JDBC 
OCI driver appropriate to your Oracle client installation. The OCI driver works 
through SQL*Net. 

      
      
The JDBC OCI drivers allow you to call the OCI directly from Java, thereby 
providing a high degree of compatibility with a specific version of Oracle. 
Because they use native methods, they are platform specific. 
      
      
String url = "jdbc:oracle:oci:@myhost:1521:orcl";


      
      
Here is an example connect class: 
      
      
import java.sql.*;
class dbAccess {
  public static void main (String args []) throws SQLException
  {
        try {
              Class.forName ("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
              e.printStackTrace();
        }

        Connection conn = DriverManager.getConnection
             ("jdbc:oracle:oci8:@hostname_orcl", "scott", "tiger");
                     // or oci7 @TNSNames_Entry,    userid,  password

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();
  }
}

      
      

      
      
[edit] 
KPRB driver 

      
      
Oracle's JDBC KPRB driver is mainly used for writing Java stored procedures, 
triggers and database JSPs. It uses the default/ current database session and 
thus requires no additional database username, password or URL. 

      
      
One can obtain a handle to the default or current connection (KPRB driver) by 
calling the OracleDriver.defaultConenction() method. Please note that you do not 
need to specify a database URL, username or password as you are already 
connected to a database session. Remember not to close the default Connection. 
Closing the default connection might throw an exception in future releases of 
Oracle. 
      
      
import java.sql.*;
class dbAccess {
  public static void main (String args []) throws SQLException
  {
        Connection conn = (new oracle.jdbc.driver.OracleDriver()).defaultConnection();

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();
  }
}