EJB Query Language

[Former Member]

Hi All,

I am using SAP Netweaver Developer Studio(2004)version.I want to know that EJB2.0 Query Language will

support Joins,Internal select statement with in a select

statement or not.Is it posssible or not.I have a requirement lilke this,I have to use joins.

Thanks & Regards,

Guru

[Former Member · Accepted solution]

Guruvulu,

In EJB QL you may operate on objects relations (both 0..1 and 0..n) in the same way as with joins in SQL. So the answer is yes.

Read free <a href="http://www.theserverside.com/books/wiley/masteringEJB/downloads/MasteringEJB3rdEd.pdf">Mastering EJB</a> book -- it contains separate chapter on EJB QL.

Valery Silaev

EPAM Systems

http://www.NetWeaverTeam.com

[Former Member · Accepted solution]

Hi Valery,

What u said is right,when i write a query with joins it

is giving deployment error,when i deploy in WAS saying that EJB2.0 will not support this.Please send me a sample

Query with joins which works,when i delpoy it in WAS.

Thanks & Regards,

Guru