Java web service invoking a stored pocedure

Does anybody have a example Java web srevice to invoke a stored procedure 开发者_如何学Goin the database.

A java webservice shouldn't connect directly to a database, but go through a database layer.

For java to use a stored procedure use the prepareCall method in JDBC as seen here:

http://download.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html