This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Driver Performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Driver Performance" Watch "Driver Performance" New topic
Author

Driver Performance

vikasids sharma
Ranch Hand

Joined: Aug 01, 2003
Posts: 157
hi all
1. Is that Type 4 Driver is Advisable for every case?
2. If a client stresses for using Type 2 driver instead of using pure java Type 4 driver. What are possible reasons for demarcation of added platform independency characteristices of Type 4 in this case?

Thanks and Regards
Vikas Sharma


Thanks
Vikas Sharma
SCJP(1.4)
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
There is a good overview of drivers--with pros and cons--in ComputerWorld. Many more such web sites contain similar information and can easily be found by doing a web search. You might summarize this information for the client.
Also, ask why the client why they are so insistent on using a Type 2 driver? That is the best way of finding out, rather than having *us* theorize what their reasons are. Then you can deal with those specific issues.
vikasids sharma
Ranch Hand

Joined: Aug 01, 2003
Posts: 157
Originally posted by Wayne L Johnson:

Also, ask why the client why they are so insistent on using a Type 2 driver? That is the best way of finding out, rather than having *us* theorize what their reasons are. Then you can deal with those specific issues.

Thanks Wayne for ur reply..basically for second question,itwas asked in an interview by big Software tycoon as "Why do we have Type 2 Drivers ,when type 4 are better in every way i.e performance wise and platform independency characteristics?"
Thanks and Regards
Vikas Sharma
Loren Rosen
Ranch Hand

Joined: Feb 12, 2003
Posts: 156
One possible reason is that a type 4 driver might not support every feature of the underlying database. For example, Oracle's database protocol has some mechanisms for client to try connecting to another database if the server fails. Last I looked (which was with 8i) some of them were not supported with the type 4 driver.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Driver Performance
 
Similar Threads
applet & jdbc
Difference between Type II and Type IV driver
connection to database from an applet
Applets & JDBC Connection
jdbc drivers types and advantages