Interested to Buy Any Domain ? << Click Here >> for more details...
Hi friends, In JDBC 4 drivers are there among this which
driver is best and why it is best.Which driver is most
commonly used in web applications.
- 6 Answers
- 9407 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
Type 4 Driver will be the best driver.Because the java
application will directly interacts with database without
middlewares. We want a jar file to connect directly(i.e
mysql connector jar file for mysql,ojdbc.jar to pracle
database).
| Is This Answer Correct ? | 9 Yes | 0 No |
ok , friend see ,there are three drivers and one protocol
which is type-3 ,ok.
My recommendation is to use type-4 dirver , why , because
it has seveal advantages than the predecessor drivers.
Advantages
----------
->It is directly interacting with database software.
->It does not need much conversions to be included.
->It is compatible with internet program and applet programs
like this many advantages are there list will go on.
ok, now , if you are developing 2-tier project than use
type-4 dirver , if it is web application than use type-3
with type-4 ok
for more information call 9989683928 , i belong to hyd
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vicky
Because Type IV driver classes are written purely in
java.and it interacts directly with the database we dont
need to specify any ODBC to interact with the database.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vinayak_ankam
alljava because it's have capability work with any data
base and cliet did not requeried to install any software.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / srinu
Among jdbc driver TYPE-III driver(or) Net protocol driver is
best. because their is no worry about connection object and
connection pooling,middleware services.THe jdbc connection
are over all taken by application server.A programer just
use the connection object.
In webapplication TYPE-III driver are mostly used.To work
with TYPE-III driver are in application server
| Is This Answer Correct ? | 2 Yes | 2 No |
What are temp tables ?
How the JDBC application works?
What are different types of transactions?
What is the equivalent method for precompiled SQL Statement in JDBC?
What are the sailent features of JDBC 2.0?
What happens if we don't close the connection in jdbc?
How can you use preparedstatement in jdbc?
Which package is used for jdbc application?
In JDBC, All the API?s are interfaces? Where is the actual implementation?
What are the classes and methods used for sending sql statements to database?
what is JDBC?
Can we use the one instance of Statment to execute more than one query ?
Core Java 
