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