how many JDBC drivers ?name them?
Answers were Sorted based on User's Feedback
Answer / guest
There are 4 JDBC drivers are available:
*JDBC-ODBC Bridge Driver:-Popular name is Type-1 Driver.In
this connection some native code or native database client
code must be loaded on each client machine due to this
process it is slower than other drivers.It uses
JDBC-Bridge-ODBC means between JDBC and ODBC one bridge is
work that establise the connection between application and
DataBase... It is suitable for automatic installation and
downloading java technology application is not important.
*Native API partly Java Driver:-Known as Type-2 Driver.It
enables driver converts JDBC calls into calls on the client
API for Oracle or any other databases.This driver need to
load some binary code on client machine like JDBC-ODBC
Bridge Driver.
*Network Protocol Driver:-Known as Type-3 Driver.
*Jdbc net pure Java Driver:-Known as Type-4 Driver.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / naresh katakam
The JDBC Driver provides vendor-specific implementations of
the abstract classes provided by the JDBC API. This driver
is used to connect to the database.
there are:
Type 1 : JDBC-ODBC Bridge Driver
Type 2: Native API Partly Java Driver
Type 3: Network protocol Driver-
Type 4: JDBC Net pure Java Driver
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / kkkk
TYPE-1 : JDBC-ODBC BRIDGE DRIVER
TYPE-2 : NATIVE API PARTLY JAVA DRIVER
TYPE-3 : NETWORK PROTOCOL DRIVER
TYPE-4 : JDBC NET PURE JAVA DRIVER
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / priya
TYPE 1: JDBC AND ODBC Bridge
TYPE 2:Native API,partly java driver
TYPE 3:Networking protocol,all java driver
TYPE 4:Native potocol,all-java driver
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yazhini
JDBC drivers are divided into four types or levels.There are:
Type 1:JDBC-ODBC Bridge driver(Bridge)
Type 2:Native-API/partly java driver(Native)
Type 3:All java/Net-protocol driver(Middleware)
Type 4:All java/Native-protocol driver(Pure)
| Is This Answer Correct ? | 3 Yes | 0 No |
How can I get or redirect the log used by DriverManager and JDBC drivers?
What is the equivalent method for precompiled SQL Statement in JDBC?
i am user who logined the application..after that another valid user will also logind..so that is it neccessary to create jdbc connection for each and every user...plz explain it with proper answer...plz help me
What is execute(), executeUpdate() and executeQuery() methods?
What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?
What are the exceptions in jdbc?
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
can we create a own jdbc driver? how can we create?
What is the purpose of jdbc resultset interface?
java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
How transactions are performed using JDBC ?