why are using type4 driver in realtime projects?
Answers were Sorted based on User's Feedback
Answer / karthikeyan
we're using type 4 because we do not require to have client
side software to be present. db vendors will take care of it
| Is This Answer Correct ? | 28 Yes | 0 No |
Answer / venu
Type4 driver includes it's own implementation of a TCP/IP version of Oracle net8 written entirely in java.so it is platform independent. it can be downloaded to a browser at run time.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / dipanshu
We use type-4 driver in our project bcoz of the following reasons.
Type 4 Driver is a thin driver and it doesn't contain more layer like other (type-1 and type-2) drivers, it speed up the performance and moreover DB vendor library is automatically includes so explicitly our client application does not need to have DB vendor Library.
When we use type-4 driver to talk to Database then our JDBC code directly talks to the Database s/w without having the support of ODBC(like type-1) and DB Library(in type-1&type-2).
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raju pericheral
we never use 4 drivers in any project we use the Type3 and type4 combination.
in case of ms-access have to use type2 driver only.
| Is This Answer Correct ? | 3 Yes | 13 No |
What is the role of class.forname while loading drivers?
How does jdbc connect to database?
How can I get or redirect the log used by DriverManager and JDBC drivers?
What is connection pooling? What Method and class used for Connection pooling in Java?
Give an example of code used for setting up connection with a driver.
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
Prepared statements are faster. Why?
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?
What is use of connection pooling?
How to check null value in JDBC?
Explain different types of locks in jdbc?
What is the benefit of having jdbcrowset implementation?