Is there a way in Java 1.5 to retrieve multiple ResultSet objects from a DB2 database with a single SQL call without resorting to StoredProcedures / CallableStatements?
No. I don't think it is possible to get multiple ResultSet objects in single SQL call. You may refer JDBC API doc.