What are the different JDBC drivers available ?

CuriousTab

Discussion

Home ‣ Interview ‣ Technology See What Others Are Saying!

Question
What are the different JDBC drivers available ?

Correct Answer

There are mainly four type of JDBC drivers available They are: Type 1 : JDBC-ODBC Bridge Driver - A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers Note that some ODBC native code and in many cases native database client code must be loaded on each client machine that uses this type of driver Hence, this kind of driver is generally most appropriate when automatic installation and downloading of a Java technology application is not important For information on the JDBC-ODBC bridge driver provided by Sun Type 2: Native API Partly Java Driver- A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine Type 3: Network protocol Driver- A net-protocol fully Java technology-enabled driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server This net server middleware is able to connect all of its Java technology-based clients to many different databases The specific protocol used depends on the vendor In general, this is the most flexible JDBC API alternative It is likely that all vendors of this solution will provide products suitable for Intranet use In order for these products to also support Internet access they must handle the additional requirements for security, access through firewalls, etc, that the Web imposes Several vendors are adding JDBC technology-based drivers to their existing database middleware products Type 4: JDBC Net pure Java Driver - A native-protocol fully Java technology-enabled driver converts JDBC technology calls into the network protocol used by DBMSs directly This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access Since many of these protocols are proprietary the database vendors themselves will be the primary source for this style of driver Several database vendors have these in progress

More questions

1. How would you automatically transfer your visitors to a new web page?

Discuss

Correct Answer: - You can do it with the help of meta tag mentioned below:

<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://wwwyoursitecom">

Place this tag between <HEAD></HEAD> - It will load yousitecom in 2 seconds

3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :
Options
A. Mutual Fund
B. Income Tax
C. Stock Exchange
D. Banking

Discuss