This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
There's a version of Connection.prepareCall() that takes resultSetType and resultSetConcurrency parameters, so I don't see why not as long as your driver supports JDBC 2.0. I've never tried it myself; why don't you give it a go?
If you are able to wait to J2SE 5.0 the implementations of the new RowSet interface are able to provide a Resultset scrollable even though the driver is not. RowSet extends ResultSet. I haven't tried it but have a look at JdbcRowSet