Likely your DB session is set to autoCommit after each SQL command issued through JDBC. Any open resultSets on a given DB connection will reset after a commit (auto or manual). If you turn off...

I fixed a couple of problems I noticed after I submitted the posting....

// C is the collection type and I is the item type.
template<class I, class C<I>>
I& operator[](C<I>& someCollection,...

Not sure if you are doing templates or not, but templates provide the most reusable solution... Here is a simple solution using templates and will work on any collection having any type of data. ...

The infinite loop is caused by the fact that you never decrement your num_rooms variable. add
<TAB>num_rooms--;
to the end of your while loop.

Your number of tiles issue is located in the...

public String reverse(String normal)
{
//reverse the letters in string

int length = normal.length(); //length of string
StringBuffer result = new StringBuffer(length);
int i;

for(i =...

use memcmp

If you collect the result set from your first query into a coma separated string as follows:

16,27,95,97,90,89,65,45,44,78,87,93

then, you can then embed this string in the second query as...