Yes, it is possible. In fact
you should create different ResultSet objects for executing different queries, the other way round i.e. executing different queries with same resultset object before closing it will give an error. For specific solution supply your code.