Annoying database problem!

[DC1]

Hi,

I was wondering if anyone could help me. After running the below code, I get a SQL Exception "ResultSet is closed" as I leave the while(c.nextPage()) loop - can someone tell me why and also how to stop the exception and instead just get out of the while loop as it's meant to and run the next lot of code?

Thanks.

public JTable printData (CachedRowSet c){
		try{
			RowSetMetaData rsmd = (RowSetMetaData)c.getMetaData();
			int cols = rsmd.getColumnCount();
			String [] columns = new String[cols];
			for (int i = 0; i<cols; i++){
				columns[i] = rsmd.getColumnName(i+1);
			}
			c.last();
			int rows = c.getRow();
			c.first();
			String [][] data = new String [rows][cols];
			
			int i = 0;
			c.beforeFirst();
			
			while(c.nextPage()){ // ERROR AS LEAVE
// Inner code works fine - populates data as required

				while(c.next()){ 
					for (int j = 0; j<cols; j++){
						data[i][j] = c.getString(j+1);						
					}
					i++;
					
					System.out.println("c.next");
					
					
				}
			}	
			
			
			
			
			DefaultTableModel dm = new DefaultTableModel();
			dm.setDataVector(data, columns);
			JTable table = new JTable(dm);
			return table;
		} catch (SQLException e) {
			System.err.println("Could not connect: " + e + "\n" + e.getMessage() );
			e.printStackTrace();
			JTable table = new JTable();
			return table;
		}		
	}

[Eranga]

Did you get at least one entry to the table?

[DC1]

Yes, the inner code populates data with the 4 rows that resulted from the query. The only problem is when I exit the outer while (c.nextPage()) loop - instead of going to the code below it, it goes straight to the SQL Exception catch block.

When I run this simple test code, the while(c.nextPage()) loop works fine - just exits as expected (so get hello, hello, hello, hello, hi as predicted).

try {
			try {
				Class.forName("org.postgresql.Driver");
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			CachedRowSet c = new CachedRowSetImpl();
			Connection conn = DriverManager.getConnection ("jdbc:postgresql://db.doc.ic.ac.uk/g0516315_u","g0516315_u","ncSCbCon9E");
			PreparedStatement stmt = conn.prepareStatement("SELECT * FROM ppl", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			ResultSet r = stmt.executeQuery();
			c.setPageSize(1);
			c.populate(r, 1);
			while (c.nextPage()){
				System.out.println("hello");
			}
			System.out.print("hi");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}