[Opensource] DBConnection implementing ResultSet Interface??

[Michael Rimov]

Hey All,

I've been watching DBConnection lately, and some of the changes others and 
I have been putting into it.  The get/set methods are moving towards 
complaince with a full ResultSet.  So I'm thinking, since we store a 
resultset object internally, why don't we make DBConnection IMPLEMENT the 
ResultSet interface?

We do this simply by passing all the ResultSet calls internally to the 
ResultSet object we've stored from the last sql execution.  So it would be 
pretty trivial to implement... just repetitions.

The only catch I see is that the DBConnection interface contract would 
change slightly because ResultSet methods through java.sql.SQLException 
instead of DBExceptions.  But I _THINK_ that by catching those exceptions 
at the DBObject method level, we'd minimize migration coding.

What do you guys think?  Is this an idea worth pursuing?  Does it make 
DBConnection too complicated?  I won't modify this one without feedback 
since it changes too much of a fundamental piece of Expresso, and I won't 
do that to such a fundamental piece of Expresso this late in the dev cycle 
unless people don't think it will be too hard to migrate their code.

Thanks!
						-Mike