1. Help with empty result set! coderanch.com |
2. Return: Illegal operation on empty result set. coderanch.comSo, how do you tell the result set is empty? When I execute the following code: subscription s= null; rs= stmt.executeQuery(); try { Log.write("dbUtils::dbResultSet2Subscription: rs= " + rs); if(rs.isBeforeFirst()) { Log.write("rs is before first "); if(rs.next())Log.write("rs moved to next"); else Log.write("rs DID NOT move to next"); } else Log.write("rs is NOT before first"); if(rs == null || (rs.isBeforeFirst() && !rs.next())) return ... |
3. Result set empty coderanch.comThat's an odd way to do a while loop for a resultset, or more generally, its not often you see a do/while loop anymore. As for your issue, I'm sure its related to the query. If its not throwing an error than your answer is pretty straight forward, the query returns no records. We would need to need to see your ... |
4. Result set is empty coderanch.comPreparedStatement query = con.prepareStatement( "SELECT PASSWORD FROM LOGIN WHERE USER LIKE ?"); query.setString(1, "administrator"); int n = query.executeUpdate(); System.out.println("n" + n); //ResultSet rs = stmt.executeQuery("SELECT password from login where userid like 'administrator'"); System.out.println("SELECT password from login where userid='"+name+"'"); ResultSet rs = stmt.executeQuery("select password from login where userid='"+name +"'"); // ResultSet rs = stmt.executeQuery("SELECT PASSWORD FROM LOGIN"); while(rs.next()) { pw= rs.getString(password); System.out.println("password" ... |
5. OracleDatabaseMetaData.getColumns() returns an empty result set coderanch.comHowdy Ranchers, I've setup a dbunit unit test for some DAO's I worked on. I was using HSQL (which worked) and am moving it to Oracle 11g. The data is loaded via dbunit's FlatXmlDataSetBuilder, Spring 2.5.6 LocalContainerEntityManagerFactoryBean and Hibernate 3.4 OracleDriver. The database is setup using synonyms and I used dbunit's DabaseConfig.setProperty() method to set the table type to "SYNONYM". It ... |