JAVA Oracle connectivity with Jdbc-odbc bridge

amansundar · #1 09-24-2007, 10: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 09-24-2007, 10: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 09-24-2007, 10: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 09-24-2007, 10: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 09-24-2007, 10: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());

        }

    }    

}

leveup2 · #6 03-24-2009, 06:19 AM

is really useful for me, I am glad to read it here.

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
java oracle database connectivity	aaratipatil	Java Programming	0	03-27-2009 09:43 PM
Difference between JDBC and ODBC?	vijayanand	Java Programming	0	09-20-2007 07:05 AM
Can the JDBC-ODBC Bridge be used with applets?	bluesky	Mobile Software Development	2	09-04-2007 07:04 AM
Parameters and Variables in Oracle through ODBC (VS2005)	$enthil	VB.NET Programming	2	08-17-2007 05:56 AM
Open Database Connectivity (ODBC)	Murali	Database Support	0	07-16-2007 03:02 AM