Multiple RowSets redux...

ok, i think i'm getting a handle on the whole MVC thing and how i
should be constructing my db application.  But i am still confused on
one thing.  (well probably more, but one for now)

again, i am trying to build an app that displays data from multiple
tables in a single Derby database.  the tables will be displayed in
two different JTables with two different TableModels displayed on the
same frame.  Each TableModels will get their data from a JDBCRowSet
object.  My question is, should each TableModel have it's own
JDBCRowSet instance; which seems the most straight-forward, but
requires multiple connections--or is there a better way-- to somehow
use one connection and retrieve multiple result sets?

btw--this is going to be a multi-user client/server app.

tia
-mark