1 Reply Latest reply on Feb 7, 2006 5:18 PM by Andrew Oliver

    NativeQuery for caliing Stored Procedure Implementation

    Khoya Raaz Newbie

      I am implementing a J2EE app that will go live this year using EJB3.
      Currently, Native Queries are not supported, I am therefore using JDBC calls to access data from stored procedures in my DB (faster than sorting within my Session Bean). I had a couple of questions in this regard:
      1) Are Native and or Named Queries still not implemented yet?
      2) If not, when is JBoss/EJB3.0 going to release a version that implements it?
      3) I believe that you should use NativeQuery for calling a stored procedure that reads in and returns a resultset, is that correect?

      Thanks guys, am really enjoying JBoss and EJB 3.0 ... would like to get rid of my JDBC calls soon though :)

        • 1. Re: NativeQuery for caliing Stored Procedure Implementation
          Andrew Oliver Master

           


          1) Are Native and or Named Queries still not implemented yet?


          Named: yes
          Native: yes

          If not, when is JBoss/EJB3.0 going to release a version that implements it?


          Grab RC5-PFD and upgrade JBAS-403sp1 or build JBoss 4.04-xxx yourself.


          I believe that you should use NativeQuery for calling a stored procedure that reads in and returns a resultset, is that correect?


          You may.

          I recommend having a few glances at the hibernate annotations docs. you'll find them pretty illuminating for most things.