Is there a way to call the store procedure in EJB's.As far as my knowledge goes it is not possible to call Store procedure in Entity beans. I am wondering is it possible to call in Session beans.??!!! If so could you please paste a snapshot of code.
Thanks in advance.
You can call stored procedures through JDBC for most databases. So, if you are using bean managed persistence, you can use stored procedures. The same holds true for Session Beans--if you are using a JDBC driver that support the stored procedure then you can call a stored procedure.
You can call stored procedures from every bean via jdbc, if the jdbc-driver supports this.
View the jdbc documentation for java.sql.CallableStatement. There you will find the required information.
is there sample code availble for calling stored procedure from BMP