Mit obigem Namen geht das bei mir so:

Class.forName(driverName); // register driver
con = DriverManager.getConnection(url, userName, password);
fromSelect = con.createStatement();
fromSelect.setQueryTimeout(60);
fromResult = fromSelect.executeQuery("select * from ...");
while(fromResult.next()) {
// mach was
}