Hi,
I am new to hibernate and have a question . I have a table which is created in mysql called RULES
and has the following colums

int id,
field varchar(20),
operator varchar(10),
value varchar(20)

This was an existing table and I have to use it as read only.

Now I want to use hibernate to retrieve results from this table.

since there was not any object model when this table was created, I have created a class called Rule with member names corresponding column names and mapped it to table RULES as shown below

<hibernate-mapping>
<class name="package.Rule" table="RULES">
</class>

</hibernate-mapping>

In my hibernate.cfg.xml, I am referring to the above mapping file in <mapping resource="package.filename" />

In my code I tried to creates SQL query as shown below

Query q = session.createSQLQuery("select {r.*} from RULES r where id := id").addEntity("r",Rule.class);

I get the error Rule.class not found.

can some one tell what is the right way of querying and existing table using SQL queries and also how to do it through named SQL queries.

thanks

An entity is an object, not a class.

You are doing



This is nonsense.

But anyway, what you really want to do is to get all Rules out of the db. You can do that with a simple HQL query (why are you using a SQLQuery?) by doing "from Rule" which would return a list of all rule entities in the db.

thank you