How to execute stored Procedure

[jboss098]

Can someone explain me how to execute a stored procedure in seam using hibernate. I defined the annotation @SqlResultSetMapping and @NamedNativeQuery in entity bean . I tried calling the native query using enityManager in stateful bean. It throws null pointer exception.




thanks,
newbie.

[dhinojosa]

What's a stored procedure? ;)

Just kidding, don't hear much about stored procedures anymore. Can't you just bring in a DataSource into a (seamened) session bean, and invoke it from there using JDBC? I don't think you need Hibernate, EJB 3.0, etc. to do that.