Discussions

EJB design: two headache ejb questions

  1. two headache ejb questions (1 messages)

    1.Under the condition of same hardware configuration, when should I consider to use EJB, in what number range of the concurrent user?

    2.Is there any way to use store procedure in EJB (put all the SQL into SP)? What is the difference of DB performance in using the SP?
  2. two headache ejb questions[ Go to top ]

    Is there any way to use store procedure in EJB (put all >the SQL into SP)? What is the difference of DB performance >in using the SP?

    The DB performance AFAIK increases if we use Stored Procs. But this may lead to problems, if you plan to migrate to some other database.

    Stored procs can be invoked by the normal JDBC CallableStatement, from the EJB or from a DAO.