I got the JPA(with eclipselink) to work and have been using @NamedStoredProcedureQuery annotations in entities to obtain entity classes successully from SQLServer. This technique doesn't seem to work well or fit the situation where the stored proc just returns output parameters (no entity class required). For this I think I need a Session to do a more programatic solution to call the stored proc.
Does Tapestry help obtain this object with an injection? John