Conexiones en java

[Nighter]

hola amigos, tengo una duda, como puedo usar una sola conexion a una base de datos y multiples result sets que utilicen esa unica conexion para hacer diferentes peticiones sin que ningun result set se cierre?

[GreenEyed]

De java.sql.Statement

By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists.

http://java.sun.com/j2se/1.4.2/docs/...Statement.html

S!