Hibernate Community • View topic - Error while deleting a record

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Error while deleting a record

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

ram.gaurav

Post subject: Error while deleting a record

Posted: Tue Feb 10, 2009 1:37 am

Newbie

Joined: Mon May 26, 2008 6:09 am
Posts: 8

Hi,

I am new to hibernate and just want to delete one record simply from database.

I wrote Native Sql Query and run it. While executing it is giving the error something like

estimated cost of this query is [xxx]

Can you please suggest me something

Top

parmendratyagi

Post subject:

Posted: Tue Feb 10, 2009 1:39 am

Regular

Joined: Thu Sep 06, 2007 2:22 am
Posts: 108
Location: Noida,India

Could you please post the query, code and error log message.

Top

ram.gaurav

Post subject:

Posted: Tue Feb 10, 2009 2:01 am

Newbie

Joined: Mon May 26, 2008 6:09 am
Posts: 8

Code:

String sql = "delete from "+ tableName +"  where "+ column +" = "+id;
                Query query = sess.createSQLQuery(sql);
                int row = query.executeUpdate();

error is:

The query has been canceled because the estimated cost of this query (2052) exceeds the configured threshold of 300. Contact the system administrator.
[/code]

Top

parmendratyagi

Post subject:

Posted: Tue Feb 10, 2009 3:11 am

Regular

Joined: Thu Sep 06, 2007 2:22 am
Posts: 108
Location: Noida,India

This is problem of DBMS s/w (like Oracle, SQL ). Please contact your DBA with exact query.

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum