Can we use cmp with stroed procedures? Which server (version) supports it? WLS, WAS?
posted 11 years ago
I cannot give you a certain answer, but from my experience with weblogic I�ll tell you that this is rather impossible. If you want to access your stored procedures from your ejbs, than you rather use a SLSB that uses straight jdbc to invoke the SP. As a rule of thumb you should also remember that stored procedure should be used only when necessary. On the other hand the result of mixing the transaction logic in your ejbs, as well as the stored procedures is highly unpredictable. Regards.