Driver
Name of driver
Driver class name
url
Jar file
Type 1
Java build in driver
Sun.jdbc.odbc.JdbcOdbcDriver
Jdbc:odbc:<dsn>
rt.jar file
Type 2
Oracle oci driver
Oracle.jdbc.driver.OracleDriver
Jdbc:oracle:oci8:@<sid>
Classiii.jar,classes12.jar,ojdbc14.jar
Type 4
Oracle thin driver
Oracle.jdbc.driver.OracleDriver
Jdbc:oracle:thin:@<host>:<port number>:<sid>


-         jdbc:oracle:oci8 is called protocol in database url
-         sid represents service id/ logical db name in oracle db s/w
-         host represents host name / ip address of a computer where the db s.w is installed
-         port number indicated the logical s/w port number where oracle s/w is residing in the computer the default port number is 1521
-         every s/w installed in the computer will reside on a logical port called s/w part this port will be identified with port number
-         total 65,535 s/w ports are available
-         port number  + ip address/host name of computer together is called socket number of certain s/w service
-         in order to communicate with a logic db in remote db s/w the following details are required
-         host name/ ip address of computer where oracle s/w is installed
-          port number of oracle db s/w
-         Logical db name / sid in oracle db s/w