Q:

Oracle 10g connection with Java

what are the drivers which are used to connect with java for Desktop application. i have found many types like tiny and all but was not able to understand. 
Please help me out

A:

To make your life easier, I would recommend just using Oracle's Thin Driver.
First, download the driver from Oracle's site:
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

Then add JAR to your project and connect to database using:
Class.forName ("oracle.jdbc.driver.OracleDriver");

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

Of course, replace these parameters with the ones corresponding to your DB.

A:

Have you looked into official site
See Also 

JDBC kick start

