Creating a new object instance in hibernate using a sql query

Question

I am attempting to create an object in hibernate using a query, which will then be saved back to the table representing the class.

Excerpt from hbm.xml file:

<class name="MyClass" table="MY_TABLE">
<id column="ID" name="ID">
   <generator class="sequence">
    <param name="sequence">MY_SEQ</param>
   </generator>
</id>
  <property column="VAL" name="val" type="string"/>
</class>

<sql-query name="myQuery">
  <return class="MyClass"/>
  SELECT MY_SEQ.nextval ID, 'something' VAL from DUAL
</sql-query>

Code snippet from test case:

MyClass myClass = (MyClass) session.getNamedQuery("myQuery").list().get(0);
Transaction t = session.beginTransaction();
session.save(myClass);
t.commit();

My aim is that there should now be a new record in table MY_TABLE, but the insert does not occur, I assume that this is due the fact that Hibernate does not know that the instance has not been persisted in the db.

I have tried changing the query to read:

SELECT NULL ID, 'something' VAL from DUAL

But this results in Hibernate not instantiating an object.

So how can i create a new object instance from a query that is not associated with a persisted instance of the class and use this to create a persisted instance?