Updating row with createSQLQuery

chuckie474 · **Joined:** Wed May 13, 2009 4:11 pm **Posts:** 2

I am trying to update a row in my table using createSQLQuery, because my row contains a column of SDO_GEOMETRY type that Hibernate doesn't support. However, when I run the executeUpdate() and commit the transaction, my database is not updated and I don't get any exceptions to explain why it wasn't updated. It just looks like it was committed correctly. This is what my code looks like:

Code:

String sqlString = "update GEOM set geo_points=SDO_UTIL.CIRCLE_POLYGON(50,-150,300,3) where id=105";
Transaction tx = session.beginTransaction();
SQLQuery query = session.createSQLQuery(sqlString);
query.executeUpdate();
session.flush();
tx.commit();

I can successfully run the same snippet of code with an INSERT rather than an UPDATE.

What am I missing?

mumbaimuru · **Posted:** Tue Sep 29, 2009 6:30 am

make show_sql as true and find the sql query for update in console.

chuckie474 · **Joined:** Wed May 13, 2009 4:11 pm **Posts:** 2

Setting show_sql to true displayed the correct query when I did the query.executeUpdate() line, but then it cleared everything out when I did a session.flush().

The solution to this was to do a session.refresh() and then a tx.commit().