Relationship between JDBC Connections, Statements, ResultSets and open data paths

Can anyone tell me whether there's an easy way of determining how JDBC
Connections, Statements (Prepared or otherwise) and ResultSets relate to
open files/ODPs?  For example, if I get a ResultSet from querying a
file, presumably that file will be opened.  If I run the same query
again, I would not expect it to be opened again; but if I run a
different query?  And if I close the ResultSet, should the file be
closed?

The background to all this is that one of our clients (we are a software
house) is experiencing extreme CPU usage by their QZDASOINIT jobs; on
looking at the jobs they find that they have many more files open than
seems right, including multiple opens of the same files.  The jobs are
being used by Connections from our application (which in this case is
running on Solaris, but being Java that need not always be so).

It may be that the high CPU usage and the multiple open files are not
related, but something strange is definitely going on, and I'd like to
find out how these things are related.  The archives, IBM's site, and
the web generally have not been illuminating so far.

TIA.

Cheers,

Martin.

--
Martin McCallion
Senior Technical Consultant
Work:  martin.mccallion@misys.com
Home: martin.mccallion@ukonline.co.uk
Misys International Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
www.misys.com
This email message is intended for the named recipient only. It may be
privileged and/or confidential. If you are not the  intended named
recipient of this email then you should not  copy it or use it for any
purpose, nor disclose its contents to any other person. You should
contact Misys International Banking Systems as shown below so that we
can take appropriate action at no cost to yourself.
Misys International Banking Systems Ltd,1 St
George's Road, London, SW19 4DR, UK. Email: ibs.postmaster@misys.com.
Tel: +44 (0) 20 8879 1188 Fax: +44 (0) 20 8947 3373
Misys International Banking Systems Ltd is
registered in England and Wales under company no. 971479