Implementing dynamic paged queries - POJOs in Action: Developing Enterprise Applications with Lightweight Frameworks - page 425

Domain Model

Order

OrderRepository

findOrders()

Restaurant

...

Persistence Framework

Object/Relational Mapping

Connection Query <class

name="Order"
table="PLACED_ORDER"
... >

createQuery ()
...

execute()
...

</class>

Database

JDBC

<<table>>
PLACED_
ORDER

Prepared
Statement

ResultSet

Connection

next()
getInt()
getString()
...

prepareStatement()
...

executeQuery()
...

<<table>>
RESTAURANT

...

Figure 11.3 How a query is executed when using a persistence framework

framework. Moreover, unlike i BATIS , Hibernate and JDO lack support for dynami-
cally generating SQL statements, which means that you will end up writing some
messy query-generation code.
Another potential obstacle to implementing dynamic paged queries with a per-
sistence framework is that you might not be able to control how the persistence
framework selects a range of rows from the result set. Hibernate and some JDO