No, it does not close. Eduardo
2007/12/17, Jim Newsham <[EMAIL PROTECTED]>: > > > OntologyDefinedValueString otValue = createOntologyDefinedValue(rs2); > > ...does the createOntologyDefinedValue(ResultSet) method close the result > set? > > Jim > > > > > -----Original Message----- > > From: Eduardo S.E. de Castro [mailto:[EMAIL PROTECTED] > > Sent: Monday, December 17, 2007 10:17 AM > > To: Derby Discussion > > Subject: Re: Two statement in while > > > > Hello Bryan, > > > > The code in use is > > > > private Map<Integer, List<OntologyDefinedValueString>> > > getSetConstituents(String tblConst, String tblSet) throws > > SQLException{ > > Map<Integer, List<OntologyDefinedValueString>> mapResult = new > > HashMap<Integer, List<OntologyDefinedValueString>>(); > > > > String strQuery = "SELECT PETRO_ID FROM CONSTITUENT_SET US > > ORDER BY ORDERING"; > > > > PreparedStatement pstmt = > > DataSourceManager.getPetroKnowDS().getConnection().prepareStatement(strQue > > ry); > > ResultSet rs = pstmt.executeQuery(); > > > > while (rs.next()){ > > Integer key = rs.getInt("PETRO_ID"); > > > > String strQuery2 = "SELECT PETRO_ID, " + KEY_VALUE_ENUS + > > ", " + KEY_VALUE_PTBR + ", ORDERING FROM CONSTITUENT_NAME " + > > " US WHERE ID_CONSTITUENT_SET = ? ORDER BY ORDERING"; > > > > PreparedStatement pstmt2 = > > DataSourceManager.getPetroKnowDS().getConnection().prepareStatement(strQue > > ry2); > > pstmt2.setInt(1, key); > > ResultSet rs2 = pstmt2.executeQuery(); > > > > List<OntologyDefinedValueString> lstConstituents = new > > ArrayList<OntologyDefinedValueString>(); > > > > while (rs2.next()){ > > OntologyDefinedValueString otValue = > > createOntologyDefinedValue(rs2); > > lstConstituents.add(otValue); > > } > > > > mapResult.put(key, lstConstituents); > > > > rs2.close(); > > pstmt2.close(); > > } > > rs.close(); > > pstmt.close(); > > > > return mapResult; > > } > > > > I tried with derby 10.3.2.1, 10.2.2.0, 10.1.3.1 > > > > Thanks, > > Eduardo > > > > 2007/12/17, Bryan Pendleton <[EMAIL PROTECTED]>: > > > > Just a stab in the dark, but I think you can only have one resultset > > > > open in a connection at a time. > > > > > > No, that's not true. Some databases have that limitation, but not Derby. > > > > > > I routinely have multiple result sets open on the same connection > > > in my Derby applications. > > > > > > > I have a question about using two PreparedStatements in the same > > > > connection. When I use the following line, I get an exception > > > > java.sql.SQLException: ResultSet not open. Operation 'next' not > > > > permitted. Verify that autocommit is OFF. > > > > > > Can you post a complete working example of the code that is causing > > > you problems? I didn't see anything wrong with your skeleton pseudo- > > code, > > > so it must be something wrong in the actual code. > > > > > > thanks, > > > > > > bryan > > > > > > > > > > > > >
