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 |
i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?
What are dml and ddl?
What are the differences between stored procedure and functions?
What is jndi lookup?
How data can be inserted into long row column of database?
Discuss the significances of jdbc.
Different statements in JDBC?
Where can I find ojdbc14 jar file?
How can you create jdbc statements?
Explain jdbc savepoint?
What is connection commit?
How to set NULL values in JDBC PreparedStatement?