JDBC API communicates with database through JDBC Driver. This JDBC Driver is interface java.sql.Driver. JDBC Driver is a communication layer to interact between database and java program. This takes query from java program and send to database for further processing. After finish processing, it forward back to original java program where request was generated as in ResultSet. Drivers are available from third party or database product vendors. These common vendors are MySql, Oracle, Microsoft SQL server, Db2 (IBM), and PostgreSQL etc. These Drivers are bundled with database product or available by Third Party Software Company.
MySql jdbc Driver can be downloaded from
http://dev.mysql.com/downloads/connector/j/
Oracle JDBC driver can be downloaded from oracle site
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Microsoft SQL Server JDBC Driver
Microsoft provides jdbc driver and this can be downloaded from
http://msdn.microsoft.com/en-us/data/aa937724.aspx
After downloading driver file (jar file), it should be copied into either tomcat/lib folder of tomcat or your application deployment descriptor YourApplicationFolder/WEB-INF/lib folder.
|
