RE: [Mockobjects-java-dev] Multiple ResultSet problem

[Goyal, G. (G. 097903) <L0...@ex...>]

Steve,
	Thanks for the response.=20
	I'm planning to implement the capability of holding multiple
resultsets within a statement. Its actually a crucial functionality =
that
we'll need to put in, before we go all out on using mock objects.=20
	Another thing that I'm planning to do is to make the MockResultSet
object serializable and then to implement some kind of a simple GUI, to
create these MockResultSet objects. This I think will save time while
actually writing test cases. Its a bit painful to type in the code to
instantiate the MockConnection,MockStatement, MockResultSet and the
MockResultSetMetaData in every test. What do you think about this?

Gaurav

-----Original Message-----
From: Steve Freeman [mailto:st...@m3...]
Sent: Thursday, September 20, 2001 5:00 PM
To: moc...@li...
Subject: Re: [Mockobjects-java-dev] Multiple ResultSet problem


Multiple ResultSet problemWe've just posted a fix that supports =
multiple
prepared statements -- it's in the CVS repository.

If you're using a plain Statement, do you really need 2 instances, =
shouldn't
you use the same one twice? (just asking).

Our mock statements probably do need support for multiple result sets.
Please feel free to contribute a fix ;-) Otherwise, I should get around =
to
it over the next couple of weeks (got some other things to work on).

Steve

----- Original Message -----=20
From: Goyal, Gaurav (GEA, 097903)=20
To: 'moc...@li...'=20
Sent: Thursday, September 20, 2001 9:30 PM
Subject: [Mockobjects-java-dev] Multiple ResultSet problem

Hi,=20
        Been working on implementing mock objects in our project. Was =
able
to use MockConnection and MockStatement, but needed to make minor
modifications on MockResultSet.
        The problem that I am facing now is this. One of the methods
executes two queries. Both of the queries have different types of =
result
sets(different column counts). So when I pass my database connection to =
this
method, I should be able to create two statements out of my connection =
which
will return two different result sets. As of now MockConnection allows =
me to
set only one statment. So should I change/extend MockConnection in some =
way
so that it supports multiple statements? Has anybody faced this kind of
problem? If yes, what solution did you go for??
Thanks,=20
Gaurav=20
2?$=A1=B8=DEr=DB#j=F6=9Dz=F9sSX=A7'X=AC=B4=CA=1C'?=E3y=CBl=8D=AB=DAu=EB=E5=
S=CBl=B2<=ABq=E7=E8=AE=07=A7z=D8m=B6>?=FEX=AC=B6=CB(=BA=B7=1E~S=E0zw=AD=FE=
X=AC=B6=CF=E5S
=CBb=9D=FA?s?$=A1=B8=DEr=DB#j=F6=9D