Calling Store procedure in EJB


EJB design: Calling Store procedure in EJB

  1. Calling Store procedure in EJB (3 messages)

    Hi All,
       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.


    Threaded Messages (3)

  2. Calling Store procedure in EJB[ Go to top ]

    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.

  3. 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.
  4. urgent[ Go to top ]

    is there sample code availble for calling stored procedure from BMP