This works fine:
Code:
_RootDAO.initialize();
Session session = _RootDAO.createSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Cat cat");
for (Iterator it = query.iterate(); it.hasNext();) {
Cat cat = (Cat) it.next();
out.println("Female Cat: " + cat.getName());
}
tx.commit();
session.close();
When I used named parameters the query returns 0 records even though I know it should retun 1 record.
Code:
_RootDAO.initialize();
Session session = _RootDAO.createSession();
Transaction tx= session.beginTransaction();
Query query = session.createQuery("from Cat cat where cat.name = :name");
query.setString("name", "Prince");
for (Iterator it = query.iterate(); it.hasNext();) {
Cat cat = (Cat) it.next();
out.println("Female Cat: " + cat.getName() );
}
tx.commit();
session.close();
Also, the console is telling me the session is never closing, but only with the second example with named parameters
Login
FAQ
Search