EJB 3.0 and Stored Procedures

[tvanbuskirk]

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!

[epbernard]

How is a stored procedure slower than a prepared statement?

[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!

[epbernard]

it depends on your driver / connection pool / DB, so it's better to actullay write a decent benchmark at home.

[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!

[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.