Hibernate version: 2.1

Name and version of the database you are using: MySQL 3.x

How do I execute queries that don't involve objects? For example, I want to execute "select now()" in MySQL to get the current db timestamp. The documentation talks about native sql queries, but they still involve objects.

Thanks
Chris

try:
<sql-query name="getTS">
<return-scalar column="DT" type="java.sql.Timestamp"/>
select now() as dt
</sql-query>

Then in your java code call w/ something like:
Query q = sess.getNamedQuery("getTS");
Object obj=q.uniqueResult();
if(obj instanceof Long)
{
System.out.println("answer:" + ((java.sql.Timestamp)obj).toString());
}

//or you can loop through the results with:
Iterator itr=q.list().iterator();
while(itr!=null&&itr.hasNext())
{
obj=itr.next();
System.out.println("answer:" + ((java.sql.Timestamp)obj).toString());
}