Thin Driver in JDBC

Google Advertisements

Prev Tutorial Next Tutorial

Thin Driver in JDBC

The thin driver converts JDBC calls directly into the vendor-specific database protocol. That is why it is known as thin driver. It is fully written in Java language.

This thin driver uses the following three information to connect with a database.

  • Ip address of a machine (system), where the database server is running.
  • Port number of the database server.
  • Database name, also called SID (service ID).
thin driver

Advantage of Thin driver

  • Thin driver is the fastest driver among all Jdbc drivers.
  • No software is required at client side or server side.
  • It is portable driver because it is platform independent.
  • It can be used to connect an applet with the database.

Disadvantage of Thin driver

  • Thin driver is a database dependent driver.

Why thin driver is database dependent driver ?

Because thin driver internally uses native protocol. Native protocol is a server dependent protocol it means the protocol can establish connection with a particular server only.

Thin driver connect with database

Oracle corporation has provided two JDBC driver software for connection java application to a database of oracle server.

  • Oracle oci driver.
  • Oracle thin driver.

The following are the connection properties of oracle thin driver.

driver name: Oracle.Jdbc.OracleDriver
url: Jdbc:Oracle:thin@ipaddress:sid
namesystem
passwordtiger

Prev Tutorial Next Tutorial

Google Advertisements

Buy This Ad Space @$50 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 8076671483

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Cloud computing is the on demand availability of computer system resources, especially data storage and computing power, without direct active management by the user. Cloud Computing Tutorial

College Projects Related to Java, AWT, C Projects for College, C++ Projects for College, Android Projects. Download Java C C++ Projects

Download Projects

Adsense Advertisements


Buy This ads Space 8076671483

Buy This Ad Space @$120 per Month, Ad Size 300X600 Contact on: hitesh.xc@gmail.com or 8076671483 Try this Keyword C++ Programs