Hello Everyone,

When i try to delete a row from the table as,

Customer c1 = new Customer();
c1.CustomerID = "A001";

session.Delete("from customers where customerid = ",c1.CustomerID,NHibernate.NHibernateUtil.String);

I get the following Exception:

"in expected: <end-of-text> (possibly an invalid or unmapped class name was used in the query)"

My table name is "customers".

Anyone Plz help to solve this.

Thanks in Advance,
Dhivya.

You need to use class names in HQL queries (Delete takes an HQL query). Delete("from Customer c where c.id = ?", c1.CustomerID, NHibernateUtil.String)

or just Delete(c1) should work I think.

Hi Sergey,

Thanks for your fast response.

I am able to use Delete(c1).

But when i try to Delete using HQL query:
Delete("from customers c where c.id =?",c1.Cid,NHibernateUtil.String)

again i get exception as:
"in expected: c [from customers c where c.customerid =?]"


And also, i could not find, executeUpdate Method with the below statement:
session.createQuery( "delete Customers c where c.id = 1 ).executeUpdate();

Plz help.


Thanks,
Dhivya.

Hi Sergey,

Thanks for your fast response.

I am able to use Delete(c1).

But when i try to Delete using HQL query:
Delete("from customers c where c.id =?",c1.Cid,NHibernateUtil.String)

again i get exception as:
"in expected: c [from customers c where c.customerid =?]"


And also, i could not find, executeUpdate Method with the below statement:
session.createQuery( "delete Customers c where c.id = 1 ).executeUpdate();

Plz help.


Thanks,
Dhivya.

Please read my reply carefully again, you should see your error.
There isn't a method named executeUpdate because it's a Hibernate 3 feature and NHibernate is a port of Hibernate 2.1.

Thanks a lot Sergey.
Now Delete Method works fine.

1.If there is no method called executeUpdate...then how is it possible to use the CreateQuery Method?

2.Is there any way to execute Stored Procedures using NHibernate?


Plz Help.

Thanks,
Dhivya.

I think you call query.List (or some method similar to that) to execute the Query returned from CreateQuery.

You cannot execute SP's using NHibernate. However you can extend NH to do this. Please search the forum, there was a post sometime ago on how to do this. This facility is already available out of the box in 3.0 for java users.

It worked fine.
Thanks a lot.

It worked fine.
Thanks a lot.