[MO-java-users] Question about MockStatement and expected query strings

[James H. <jw...@al...>]

I'm writing a test of a method which needs to make two SQL queries to get 
the result.  I can configure a MockStatement to return two different 
results, but as far as I can tell, I can't set two expected query values.  
It seems that if a MockStatement can return multiple result sets, you 
should be able to associate a specific expected query value with a 
particular result set.  In my case, I have a query which gets a count of 
something and then uses that count as part of the next query.  I would like 
to test that the count query was correct and also test that the second 
query was correct.   Has anyone run into this problem before, and if so, 
how did you get around it?

Thanks.

-- 
James Howe