Neoview SQL Reference Manual (R2.2)

rowNo = 0;
while (rs.next())
{
rowNo++;
for (int j=1; j <= rsMD.getColumnCount(); j++)
{
System.out.println(rs.getObject(j));
}
}
System.out.println("");
System.out.println("--- SQL operation complete");
rs.close();
}
connection.close();
}
catch (SQLException e)
{
SQLException nextException;
nextException = e;
do
{
System.out.println(nextException.getMessage());
System.out.println("SQLState " + nextException.getSQLState());
System.out.println("Error Code " + nextException.getErrorCode());
} while ((nextException = nextException.getNextException()) != null);
}
}
}
114 SQL Statements