Originally posted by eswar kumar: can any one of you tell me in what situation what JDBC driver is used ? and which one is fastest in those and what is the reason ?
Well the first criteria is does the driver work for this database! After that, preference would be given to those drivers that are free. Next, preference would be given to type 4 driver, with a proven track record. This is personal opinion, and your priorities may be different than mine. NOTE: A better question might be, what is the best driver for 'XXX' database? This would lead to specific answers such as 'YYY' driver.