1. ResultSet 'setFetchDirection' forums.oracle.comI have looked through the documentation for the 'setFetchDirection' method of ResultSet and it seems to determine how the rows are scanned (or 'moved' through) after they have been fetched (correct me if I am wrong). Is there a method (or a technique) for fetching the last x amount of rows in a database which satisfy some condition - in other ... |
2. Retreival of the ResultSet containing aggregate functions forums.oracle.com |
3. Passing resultsets in a method forums.oracle.comThere are a couple of different ways you can go here. You could create a list (Say an array list) of objects each of which represents a row of data in your result set, or you could use a disconnected result set. Which on you use depends on your requirements and your preferences. As a rule I go with lists of ... |
4. ResultSet forums.oracle.com |
5. Primary keys and |
6. Trying to display a floated Resultset forums.oracle.compublic static void main (String[] args) { String userInput = ""; try { userInput = args[0]; } catch (Exception e) {} Properties ini = new Properties(); try { ini.load(new FileInputStream("jbaifconf.ini")); companyCode = ini.getProperty("COMPANY"); dbHost = ini.getProperty("DBHOST"); dbName = ini.getProperty("DBNAME"); dbUserName = ini.getProperty("DBUSERNAME"); dbPassword = ini.getProperty("DBPASSWORD"); } catch (Exception e) { System.out.println("Error: " + e.toString()); } Statement stmt; ResultSet rs; DecimalFormat df2 ... |
7. problem related to resultset forums.oracle.com |
8. got outofmemoryerror when looping resultset forums.oracle.comwhile(rsSymbol.next()){ // while symbol querySearch = "select `date`, symbol, close, volumn, adjustedClose from " + rsIndustry.getString("industry") + " where symbol = '" + rsSymbol.getString("symbol") + "' order by date desc"; prepStmtSearch = con.prepareStatement(querySearch); rsSearch = prepStmtSearch.executeQuery(); while(rsSearch.next()){ // while search ...... d of while search } // end of for swim loop // end of loop while symbol } // end ... |
9. about resultset forums.oracle.com |
10. problem with resultSet.beforeFirst(); and resultSet.isLast() forums.oracle.com |
11. how to fill ResultSet ? forums.oracle.comI have written a select query which hits the DB and fetches results. my DAO layer populates the data in a VO. However , there is no data present in DB now. I wish to mock the resultset so that I get the populated VO in the presentation layer to display a table in JSP. How do I mock a java.sql.ResultSet ... |