• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Post about: JPA (EJB) Query tips - with source code to download

 
Hebert Coelho
Ranch Hand
Posts: 754
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wrote a new post about query and JPA.

http://uaihebert.com/?p=1274

Bellow you can see the topics of the post.
Model classes and a class that will generate database data
Find method; Use the getReference method to get a better performance, displaying query parameters in the console with the log4j
JPQL: Queries with simple parameters or objects, Joins, Order By, Navigating through relationships
JPQL: Functions: AVG, COUNT, MAX, MIN, TRIM, SUM, UPPER, LOWER, MOD, LENGHT, SQRT; Using HAVING, GROUP BY
JPQL: Filtering Conditions: LIKE, IN, DISTINCT, EMPTY, BETWEEN, NULL, MEMBER OF, EXISTS (Subqueries), ANY, ALL, SOME, CONCAT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, LOCATE, SIZE, SUBSTRING
JPA: NamedQuery, querying with dates, warnings about the getSingleResult method
JPA: NativeQuery, NamedNativeQuery
JPA: Complex Native Queries
JPA: Optimizing queries with EJB
JPA: Pagination
JPA: Database Hints
JPA: Creating a object from a query
JPQL: Bulk Update and Delete
JPA: Criteria
I hope you guys like it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic