WHAT IS THE DISTINCTIVE CHARACTERISTIC OF TYPE 2 JDBC DRIVER FOR WINDOWS 7

Via JDBC you maintain the databases connection, issue database queries and updates and receive the results. Not good for the Web. We use cookies to understand site usage and to improve the content and offerings on our sites. This driver is server-based, so there is no need for any vendor database library to be present on client machines. There are many opportunities to optimize portability, performance, and scalability. Also, visit the helpful link: A performance issue is seen as a JDBC call goes through the bridge to the ODBC driver, then to the database, and this applies even in the reverse process.

Uploader: Majas
Date Added: 10 September 2005
File Size: 22.33 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 12019
Price: Free* [*Free Regsitration Required]

Usually not thread safe. The distinctive characteristic of type 2 jdbc drivers are that Type 2 drivers convert JDBC calls into database-specific calls i.

Explain about JDBC Type 2 Driver ?

This driver is very flexible allows access to multiple databases using one driver. Prepared Statements are used when you plan to use the SQL statements many times. It is most suitable for the web.

Some distinctive characteristic of type 2 jdbc drivers are shown below. What is the actual differance between type2 and type 4 driver in Jdbc Ask Question.

JDBC, JDBC in Java, JDBC Examples, JDBC Introduction

The what is the distinctive characteristic of type 2 jdbc characteristic of type 2 jdbc drivers are that Type 2 drivers convert JDBC calls into database-specific calls i. It is unique to your computer and can only be read by the server that gave it to you. They are the most efficient amongst all driver types. This driver is very flexible allows access to multiple databases using one driver.

For example- Oracle will have its own oracle native driver API. Disadvantage With type 4 drivers, the user needs a different driver for each database.

Join Stack Overflow to learn, share knowledge, and build your career. Java Techies- Solution for All. Jdgc up or log in Sign up using Google. A performance issue is seen as a JDBC call goes through the bridge to the ODBC driver, then to the database, and this applies even in the reverse process.

It is most suitable for the web. Sign up or log in Sign up using Google. This driver is fully written in Java and hence Portable. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

JDBC Driver Types

Off are the slowest of all driver types. Stack Overflow works best with JavaScript enabled. Not good for the Web. How to see cookies that you have accepted.

The type charactdristic driver typically provides support for features such as caching connections, query results, and so onload balancing, and advanced system administration such as logging and auditing. If the middle-tier server can in turn use Type1, Type 2 or Type 4 drivers.

Explain about JDBC Type 2 Driver ? |

The middle-tier then translates the request to the database. We will protect personal information by reasonable security safeguards against loss or theft, as well as unauthorized access, disclosure, wnat, use or modification.

The distinctive characteristic of type 2 jdbc drivers are that they are typically offer better performance than the JDBC-ODBC What is the distinctive characteristic of type 2 jdbc as the layers of communication tiers are less than that of Type-1 and also it uses Native api which is Database specific. We use cookies to understand site usage and to improve the content and offerings on our sites. Number of translation layers is very less i.

You may want to take a whar at it.

Spring Hibernate Android Php. They can alter the value of variables, generate output, process input, or respond to user mouse or keyboard actions.