File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes ejb query language ... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "ejb query language ..." Watch "ejb query language ..." New topic
Author

ejb query language ...

Salah Lejmi
Greenhorn

Joined: Jul 25, 2008
Posts: 22
hi, i have an entity session bean (service bean) with following method:


The Cabin class is defined as follows:


I am getting following console output



Anyone knows why the query with ejb-syntax does not work?
[ October 31, 2008: Message edited by: Salah Lejmi ]

SCJP 5.0 (95%), SCWCD 5.0 (98%)<br />Salah Lejmi
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16


Where is the SELECT ?


[My Blog]
All roads lead to JavaRanch
Salah Lejmi
Greenhorn

Joined: Jul 25, 2008
Posts: 22
Originally posted by Christophe Verre:

Where is the SELECT ?


i read this syntax in the oreilly book.

i tried also with "select from ..." and "select * from ..." but still getting error message.

how would you write the query in the ejb-syntax ?
[ October 31, 2008: Message edited by: Salah Lejmi ]
Reza Rahman
author
Ranch Hand

Joined: Feb 01, 2005
Posts: 580
    
    5
Salah,

Are you using EJB 3 remoting by accident or on purpose? The problem you are having indicates an RMI connectivity issue, possibly because of a firewall, but it could also be some kind of weird network misconfiguration.

The "from" syntax definitely won't work unless you are using Hibernate. Even then, it's not a good idea...I am shocked the Bill Burke book would include such code. I certainly did not catch that when I read it myself.

The code you have posted is fine otherwise. The problem is elsewhere.

Thanks,
Reza

P.S.: What you are using is called JPQL, not "EJB query language". That refers to EJBQL in EJB 2.x Entity Beans.
[ October 31, 2008: Message edited by: Reza Rahman ]

Independent Consultant — Author, EJB 3 in Action — Expert Group Member, Java EE 6 and EJB 3.1
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10141
    
165

Originally posted by Reza Rahman:
I am shocked the Bill Burke book would include such code. I certainly did not catch that when I read it myself.



This example seems to be specifically for demonstrating how to use native queries, so looks valid :



[My Blog] [JavaRanch Journal]
Salah Lejmi
Greenhorn

Joined: Jul 25, 2008
Posts: 22
Originally posted by Reza Rahman:
Salah,

Are you using EJB 3 remoting by accident or on purpose? The problem you are having indicates an RMI connectivity issue, possibly because of a firewall, but it could also be some kind of weird network misconfiguration.

The "from" syntax definitely won't work unless you are using Hibernate. Even then, it's not a good idea...I am shocked the Bill Burke book would include such code. I certainly did not catch that when I read it myself.

The code you have posted is fine otherwise. The problem is elsewhere.

Thanks,
Reza

P.S.: What you are using is called JPQL, not "EJB query language". That refers to EJBQL in EJB 2.x Entity Beans.

[ October 31, 2008: Message edited by: Reza Rahman ]


First of all, thank you much for the reply.
Second, it was in fact in the oreilly book in many sections:
- 9.1. Query API:

- 25.1.6. FlushModeType Behavior
- I saw it also elsewhere in the book

but it is as you said not a valid syntax for JPQL (thank you for the explanation) and because it was a bit strange to me, i looked in the unconfirmed errata of this book. And in fact it was inside as a mistake. (because of this mistake so much trouble and testings but anyway, i am learning ). The unconfirmed errata text contains the right answer:

I tested this syntax and it worked fine. Thank you all for your help.
[ October 31, 2008: Message edited by: Salah Lejmi ]
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

I think this problem is listed in the unconfirmed errata. (171)
 
GeeCON Prague 2014
 
subject: ejb query language ...