Hibernate: native query to wrap the collection

[Edward Chen]

In the hibernate, do we have a similar function like this

<collection name="orders" class="Order">
   <sql-query>
       select * from orders .....
   </squ-query>
</collection>

Actually, just let native query to wrap the collection. Can we do this ?

Thanks.

[Cameron Wallace McKenzie]

Sure, if you're asking if you can do a regular select, it's no problem. Here's a sample snippet:

 
 
final static String SELECT = "SELECT * FROM USER";
 

private static void hibernateNativeQueryFindAll(SessionFactory factory) {
 
Session session = factory.getCurrentSession();
session.beginTransaction();
SQLQuery sqlQuery = session.createSQLQuery("SELECT * FROM USER");
List results = sqlQuery.list();
 
for (int i = 0; i < results.size(); i++) {
Object[] o = (Object[]) (results.get(i));
int id = (Integer) (o[0]);
String name = (String) (o[1]);
String password = (String) (o[2]);
System.out.println(id + name + password);
}
session.getTransaction().commit();
}