How can I convert the following Hibernate code to JPA and get the same functinoality?

Criteria criteria = session.createCriteria(Article.class);
String[] splits = searchTerms.split(" ");
criteria.add(Restrictions.eq("blog", false));
criteria.add(Restrictions.eq("deleted", false));

for (int loop = 0; loop < splits.length; loop++) {
String withWildCards = "%" + splits[loop] + "%";
criteria.add(Restrictions.ilike("title", withWildCards));
}
criteria.addOrder(Order.desc("postDateMillis"));
criteria.setFirstResult(Integer.parseInt(index));
criteria.setMaxResults(Constants.MAX_PAGE_SIZE);
List<Article> articles = criteria.list();

Which JPA implementation are you using?

I'm using javax.persistence 1.0 with Hibenate 3.2.6.ga as the provider.

But constructing my own query from parts and pieces of strings, I've pretty much got it doing what I want except I don't know how to deal with

// criteria.setFirstResult(Integer.parseInt(index));
// criteria.setMaxResults(Constants.MAX_PAGE_SIZE);

criteria.setFirstResult(0);
criteria.setMaxResults(25);

Sorry, I'd just done a copy and paste from my website. The variable names make sense in context of the webpage code, but alone it doesn't. The arguments just take an integer as parameter.

:)

-Cameron McKenzie

Thanks ... I figured out the ...

// criteria.setFirstResult(Integer.parseInt(index));
// criteria.setMaxResults(Constants.MAX_PAGE_SIZE);

piece ... left an message about that but looks like it wasn't saved.

Using JPA, it appears that I have to construct my query by manipulating parts and pieces of strings rather than the clean way that hibernate gives you using the criteria API. Other than the ability to use other service providers, I'm beginning to wonder what the real benefit of JPA is ... I'll admit that might be a naive question as I've only started looking at JPA, but so far, I'm not seeing the advantages.