The notice of having possibility to call Java from stored procedures made me like looking forward to great future :-) The best thing I can imagine now is that I could have Java object references in user variables, something like:
SET @jDate = java::new('java.util.Date');
SET @sDate = @jDate.toString();
Or, letting my imagination fly far away:
SET @jWebService = java::jndi('java:comp/env/ws/weather');
SET @jResults = @jWebService.getWeatherIn('Brno');
SET @jResIter = @jResults.getIterator();
WHILE @jResIter.hasNext() DO
SET @jRes = @jResIter.next();
...
END WHILE;
Concerning web services, there already is a solution: UDF (user defined functions). There are some already working, hopefully their authors will release their source some day.