JAVA Oracle connectivity with Jdbc-odbc bridge

amansundar · #1 (**permalink**) 09-24-2007, 11:43 PM

Hello,

I am newbie in JDBC. Can anybody provide me the code for connecting to oracle through Jdbc-Odbc bridge. I have already created a system dsn (Microsoft ODBC for Oracle) named "orajava".

mobilegeek · #2 (**permalink**) 09-24-2007, 11:45 PM

hi,

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc

dbc

rajava ","scott","tiger");

After this you can create statement or prepared Statement object depending on your application.

S.Vinothkumar · #3 (**permalink**) 09-24-2007, 11:48 PM

1step is: getdriver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

2 step is register the URL
Connection con=DriverManager.getConnection("jdbc

dbc

rajava ","scott","tiger");

3step is : create the statement

Statemnt st=con.createStatement();

4 step is: Execute the Query and get the results from resultset

4 step is: close the all connections

krishnakumar · #4 (**permalink**) 09-24-2007, 11:57 PM

hi aman,
this link provides you sll the necessary details for making connection to oracle through java....

Java Database Connectivity Guide

leoraja8 · #5 (**permalink**) 09-24-2007, 11:59 PM

The Following code will help u..............

PHP Code:

  import java.sql.*;

import javax.naming.*;

import javax.sql.DataSource;

 
public class Main 

{

    

    /** Creates a new instance of Main */

    public Main()

    {

        

    }

    

    /**

     * @param args the command line arguments

     */

    public static void main(String[] args) 

    {

         

        Connection con = null;

        Statement st = null;

        PreparedStatement pt = null;

        CallableStatement ct = null;

        try

        {

 
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            con = DriverManager.getConnection("jdbc:odbc:orajava", "scott","tiger");

            

            //Statement

            st = con.createStatement();

            st.executeUpdate("insert into sample values(1,'abcd')");

            

            //CallableStatement(pname->procedure name ,  parameter)

//            ct = con.prepareCall("{call pname(1)}");

//            ct.execute();

//            

            //PreparedStatement

            pt = con.prepareStatement("select * from sample");

            ResultSet rs = pt.executeQuery();

            

            System.out.println("Number\tName");

            System.out.println("------------");

            

            while(rs.next())

            {

                System.out.print(rs.getInt("num"));

                System.out.print("\t"+rs.getString("nam")+"\n");

            }

            System.out.println("------------");

        }

        catch(SQLException e)

        {

            System.out.println(e.getMessage());

        }

        catch(Exception  e)

        {

            System.out.println(e.getMessage());

        }

    }    

}

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Difference between JDBC and ODBC?	vijayanand	Java Programming	0	09-20-2007 08:05 AM
Which is the fastest type of JDBC driver in Java?	leoraja8	Java Programming	2	09-05-2007 08:31 AM
Can the JDBC-ODBC Bridge be used with applets?	bluesky	Mobile Software Development	2	09-04-2007 08:04 AM
Parameters and Variables in Oracle through ODBC (VS2005)	$enthil	VB.NET Programming	2	08-17-2007 06:56 AM
Open Database Connectivity (ODBC)	Murali	Database Support	0	07-16-2007 04:02 AM