Hi all,
i got a question, can i use sql "update" using session.createSQLQuery ?

My code is like this :

String sqlQuery = "UPDATE HP_COUNTRIES4MODEL b SET item_id = " +
"NVL((SELECT item_id FROM HP_MODEL_MASTER a " +
"WHERE a.item_name = b.item_display_name), 0)";
Query query = session.createSQLQuery(sqlQuery);
query.uniqueResult();


but it always returning exception :(

can somebody help me ?

Thank you.

if your query is HQL
-----------------------
Query q = s.createQuery("your hql here");
q.setString("coloumn name", value);
q.executeUpdate();

if it is normal sql then
------------------------
SQLQuery query=s.createSQLQuery("your sql here");
query.setString("coloumn name", value);
query.executeUpdate();


Don't forget to rate.

I don't think query.uniqueResult() can be used for executing update-statements. Wouldn't query.executeUpdate() be more appropriate???

Just some wild guess....

Edit: I just did try this.
Using query.uniqueResult() gave a SqlException from the jdbc-Driver saying "executeQuery method cannot be used for update." (just as I suspected).

Using executeUpdate() gave an UnsupportedOperationException saying "Update queries only supported through HQL".

So it seems you'll have to use HQL for update-statenments...