-
-
2. Re: EJB 3.0 and Stored Procedures
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! -
3. Re: EJB 3.0 and Stored Procedures
it depends on your driver / connection pool / DB, so it's better to actullay write a decent benchmark at home.
-
4. Re: EJB 3.0 and Stored Procedures
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! -
5. Re: EJB 3.0 and Stored Procedures
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.