[Shards] Deleting objects

rakeshxp · **Joined:** Sun Sep 16, 2007 9:45 am **Posts:** 6

I am trying to delete rows from a sharded database based on certain criteria.
This is a sample code that I have been trying

Code:

String deleteQuery = "delete from table_name where id = ?" ;
Query query = ShardedDAO.getSession().createQuery(deleteQuery );
query.setInteger(0, 89);
query.executeUpdate()

The above code results in
Exception in thread "main" java.lang.UnsupportedOperationException
at org.hibernate.shards.session.ShardedSessionImpl.createSQLQuery(ShardedSessionImpl.java:1152)

So what would be the easiest way to delete entries from a shared database ? ( w/o loading and deleting object, preferably )

Thanks!
Rakesh

emmanuel · **Posted:** Tue Oct 30, 2007 2:01 pm

I guess implementing the feature would be the easiest path. Max and co can comment if there is any reason for not allowing that.

rakeshxp · **Joined:** Sun Sep 16, 2007 9:45 am **Posts:** 6

emmanuel wrote:

I guess implementing the feature would be the easiest path. Max and co can comment if there is any reason for not allowing that.

Currently, I am loading the objects and deleting them one by one.

Code:

List<Table> list= shardedSession.createCriteria(Table.class).add(
                    Restrictions.eq("id", id)).list();
            for(Table table: list) {
                shardedSession.delete(table);
            }

Implementing a proper delete ( w/o loading ) would be the best option ( It would be solved once the implementation for executeUpdate in ShardedQueryImpl is done.

Could you also let us know a rough timeframe when you are planning to release the next version ?