This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC 2.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC 2.0" Watch "JDBC 2.0" New topic
Author

JDBC 2.0

Rajeev Iyer
Ranch Hand

Joined: Jun 19, 2002
Posts: 42
Hi...
though the JDBC 2.0 has many more methods for convinience, is it slower than the previous version?
Thanks...
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
What do you mean by "is it slower"? This will depend on exactly what statements you are executing, your database driver, etc.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by Rajeev Iyer:
Hi...
though the JDBC 2.0 has many more methods for convinience, is it slower than the previous version?
Thanks...
Remember, the jdbc 2.0 is only a specification, so there is no code written. The performance relies solely on the underlying implementation of the driver you are using. But in general, a scrollable resultset is slower than a non scrollable, and the more "convenience" stuff you use, the more chance that you are introducing more overhead ( slower code ). Using jdbc 1.0 methods on a jdbc 2.0 compliant driver should in theory run the same.
Jamie
 
Consider Paul's rocket mass heater.
 
subject: JDBC 2.0