Hey,

I am new to hibernate. I have created a database table "Test". I don't have persistent class Test.java and mapping class Test.hbm.xml. How I do an insert, update and delete into Test table using hibernate.

I have tried using HQLQuery but it is keep giving me parser error.

session.createQuery("insert into Test (id, id2) values (10, 11)").executeUpdate();

Thanks.

Sanjeev

There is no way but SQL to do what you want.

You have to have mappings to allow Hibernate to work.

You could get the JDBC connection from the session and go to town on the DB.

eh you of course need to do *some* kind of mapping.

If you don't want to have a class then do stuff like:

<class entity-name="Test">
<id>...</id>
<property name="blah"../>
</clas>

and you will get it returned as a Map.


if you just want to query for it that is now possible in the later versions of h3 by the usage of ResultTransformers for SQL: http://blog.hibernate.org/cgi-bin/blosx ... d_sql.html