how to connect to an oracle database from a java source

[renjith.nair]

Please give me some sample codes to connect oracle database from a java program.

[Niheel]

Your are going to have to use an Oracle JDBC driver to connect to the database.

Below is the java code to use in conjunction with the driver and the oracle database.

 
Connection connection = null;
    try {
        // Load the JDBC driver
        String driverName = "oracle.jdbc.driver.OracleDriver";
        Class.forName(driverName);
 
        // Create a connection to the database
        String serverName = [color=#0066ff]"127.0.0.1"[/color];
        String portNumber = [color=#0066ff]"1521"[/color];
        String sid = [color=#0066ff]"mydatabase"[/color];
        String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
        String username = [color=#0066ff]"username"[/color];
        String password = [color=#0066ff]"password"[/color];
        connection = DriverManager.getConnection(url, username, password);
    } catch (ClassNotFoundException e) {
        // Could not find the database driver
    } catch (SQLException e) {
        // Could not connect to the database
    }
 

For more information please read this FAQ carefully.
http://www.orafaq.com/faqjdbc.htm#JDBC

Hope that helps. Let us know how it went.