EJB QL and Using stored procedure ( CMP)

[vikas_sm]

Hi Geeks ,

I want to call stored procedure for my CMP using EJB-QL.
I dont knowhow to write QL for calling stored proc.
Does jboss support calling stored proc from ejb-ql.

Regards
Vikas

[anilmitra]

Hi Vikas,

FireStorm/DAO adopts a pragmatic approach of generating Java source code for data persistence that is a direct mapping of a particular relational database schema. It is also possible to define complex multi-table queries and to leverage existing database logic contained within stored procedures.

http://www.codefutures.com/ejb-cmp/

Regards,
Anil