• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

@QueryHint

 
Amandeep Singh
Ranch Hand
Posts: 850
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
in my Entity-

--------------------------
@NamedQuery(
name="findAllEmployees",
query="SELECT * FROM EMPLOYEE WHERE MGR=1",
hints={
@QueryHint (name=TopLinkQueryHints.BIND_PARAMETERS, value=HintValues.PERSISTENCE_UNIT_DEFAULT)
}
)
----------------------------

I am unable to resolve the @QueryHint annotation. Even though i included the jar file's
------------------
import oracle.toplink.essentials.config.HintValues;
import oracle.toplink.essentials.config.TopLinkQueryHints;
-----------------

but still it's unresolveable.

Also i am doubtful about it's syntax usage.
I have included all Oracle TopLink jar file's.

I want to know about correct jar file and syntax required for @QueryHint.

This link http://download.oracle.com/docs/cd/B32110_01/web.1013/b28221/ent30qry003.htm wasn't useful for me.
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check the J2EE API, QueryHint is in the javax.persistence package.
 
Amandeep Singh
Ranch Hand
Posts: 850
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got it, it is present here

javax.persistence.QueryHint;

and this is the correct systax usage-

@NamedQuery(name="findCar",
query = "select c from Car c where c.steering like :steering",
hints = {@QueryHint (name= "toplink.jdbc.timeout", value = "10")}
)

thanks Christophe...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic