5 Replies Latest reply on May 5, 2006 4:01 PM by tvanbuskirk

EJB 3.0 and Stored Procedures

tvanbuskirk May 3, 2006 2:18 PM

Can anyone tell me how EJB 3.0 (via ORM) handles Stored Procedures (if at all)?

If not, how does it make up for the change in performance?

Last question, is it still possible to simply use BMP (via JDBC) to connect, or does EJB 3.0 require CMP (via ORM)?

Thanks!

1. Re: EJB 3.0 and Stored Procedures

epbernard May 3, 2006 2:24 PM (in response to tvanbuskirk)

How is a stored procedure slower than a prepared statement?
Actions
2. Re: EJB 3.0 and Stored Procedures

tvanbuskirk May 4, 2006 9:11 PM (in response to tvanbuskirk)

Hi Emmanuel,

Thank you for your reply. To be honest, it was always an assumption (so shame on me for assuming!).

Do you have any numbers or a link I can visit to see the performance differences?

Thanks!
Actions
3. Re: EJB 3.0 and Stored Procedures

epbernard May 4, 2006 9:20 PM (in response to tvanbuskirk)

it depends on your driver / connection pool / DB, so it's better to actullay write a decent benchmark at home.
Actions
4. Re: EJB 3.0 and Stored Procedures

tvanbuskirk May 4, 2006 9:32 PM (in response to tvanbuskirk)

Thanks, I'd like to write the benchmark, but I think I've gotten off topic.

I'm still trying to figure out how to call the stored procedure from my EntityManager. Can you help me with that?

Thanks in advance!
Actions
5. Re: EJB 3.0 and Stored Procedures

tvanbuskirk May 5, 2006 4:01 PM (in response to tvanbuskirk)

I found the "@NamedQuery" annotation, and that will bind my query to a bean at execution. Will this be as fast as a stored procedure?

Also, still wondering about stored procs in EJB 3.0. I know you can do a "callable" in Hibernate 3 to call a stored proc. Is there an annotation or something in EJB 3.0 that is similar to this?

Thanks in advance!

P.S. I'm using mysql-connector-j w/ a mysql datasource.
Actions

Go to original post