83 Advanced Java | JDBC 4 | without using Class forName(-) oracle thin driver | adv java

Advanced Java Tutorail : JDBC 4 0. adv java | Java Database Connectivity JDBC Application to test the database without using Class.forName(-) method. JDBC 4.0 Specification: The important feature of JDBC 4.0 specification is automatic loading of java driver class from java.sql. Driver File available from jar file of jdbc driver i.e. (ojdbc6.jar in oracle 11g). This makes programmers to avoid Class.forName(-) statement in his java application while writing jdbc code. - All the jdbc drivers thar are given based on jdbc 4.0 specification are giving java.sql.Driver File in there jar files, So when these jar files are added to the classpath the driver manager class automatically collects the driver class from java.sql.Driver File, loads the driver class & registers that driver automatically with DriverManager service. ojdbc14.jar (given by oracle 10g) is based on jdbc 3.0 specification so it does not contain java.sql.Driver File . ojdbc6.jar (given by oracle 11g) is based on jdbc 4.0 specification, so it contain java.sql.Driver File as shown below java.sql.Driver------oracle.jdbc.OracleDriver postgresql-8.4-701.jdbc4.jar of posgresql is based on jdbc 4.0 specification, so it contains java.sql.Driver File as shown below java.sql.Driver------org.postgresql.Driver JDBC application to test the connection with oracle database without using Class.forName(-) ===================================================== Step 1) Set the jar to the classpath ( ojdbc6.jar) Step 2) create the jdbc application import java.sql.*; public class WithoutClassForName { public static void main(String[] args) throws Exception { Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "boss"); Statement st=con.createStatement(); st.executeUpdate("insert into student values(1000,'patil','Omerga')"); } } compile & run