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 |
List the common jdbc exceptions ?
What are the sailent features of JDBC 2.0?
Describe the steps needed to execute a sql query using jdbc.
how can we connect to db without using getConnection() method
Which type of driver provides jdbc access via one or more odbc drivers?
How to get a whole row of data at once?
What are the differences between setmaxrows(int) and setfetchsize(int)?
How many types of resultset are there in jdbc?
What is layer in communication?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
How to find total column from a resultset?
What is the difference between executing, executequery, executeupdate in jdbc?