Help with Java

From: John Weatherman <john.weatherman_at_replacements.com>
Date: Tue, 03 Dec 2002 10:24:31 -0800
Message-ID: <F001.00510FF7.20021203102431@fatcity.com>

All,

I am beginning the journey into JAVA and have hit an odd behavior (well, probably not, but I can't see any reason for it). I am building a list of tablespaces and the datafiles that belong to them. The open to the database is working fine. When I use:

 ResultSet myTablespaces = myStatement.executeQuery(

"SELECT tablespace_name " +
"FROM dba_tablespaces " +
"WHERE contents = 'PERMANENT'"

  );

  while (myTablespaces.next()) {
    // retrieve the user from the row in the ResultSet using the     // getString() method
    ct = ct + 1;
    String tablespace = myTablespaces.getString(1);     System.out.println("Tablespace " + ct + " is: " + tablespace);   }
  myTablespace.close();

I am generating a list of tablespaces and the output is as expected. When I add a second result set, the first datafile of the first tablespace returns and then the program completes:

 ResultSet myTablespaces = myStatement.executeQuery(

"SELECT tablespace_name " +
"FROM dba_tablespaces " +
"WHERE contents = 'PERMANENT'"

  );
  while (myTablespaces.next()) {
    // retrieve the user from the row in the ResultSet using the     // getString() method
    ct = ct + 1;
    String tablespace = myTablespaces.getString(1);     System.out.println("Tablespace " + ct + " is: " + tablespace);  

    ResultSet myDataFiles = myStatement.executeQuery(

      "SELECT file_name " +
      "FROM   dba_data_files " +
      "WHERE  tablespace_name = '" + tablespace + "'"

    );   

    while (myDataFiles.next()) {

      String filename = myDataFiles.getString(1);
      System.out.println("  " + filename);

    }
    myDataFiles.close();
  }
  myTablespaces.close();

Anybody with some Java experience have any insite?

As always, TIA,

John P Weatherman
Database Administrator
Replacements Ltd.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: john.weatherman_at_replacements.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Dec 03 2002 - 12:24:31 CST