aspose file tools*
The moose likes JDBC and the fly likes The query has been canceled  !! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "The query has been canceled  !!" Watch "The query has been canceled  !!" New topic
Author

The query has been canceled !!

Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

Hi all,

i'm getting this error when i'm trying to run a query on MS SQL 2000 :

i cant understand what is this error and i googled but i cant find anything explaing this

Any recommendation ?


Thanks,
Sherif
Vinod K Singh
Ranch Hand

Joined: Sep 30, 2008
Posts: 198
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The query has been canceled because the estimated cost of this query (14616) exceeds the configured threshold of 30. Contact the system administrator.

The error message says that SQLServer is configured to not to run any query, which is supposed to take more than 30 (not sure if that is seconds or minutes ;) ) and the query you are trying to execute may take up to 14616.


My Blog
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Originally posted by Sherif Shehab:
Hi all,

i'm getting this error when i'm trying to run a query on MS SQL 2000 :

i cant understand what is this error and i googled but i cant find anything explaing this

Any recommendation ?


Could you post your query... perhaps it could be made more efficient and you can get under the 30 sec exectution limit.
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

actually it's very simple select query..
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18651
    
    8

So it doesn't have a WHERE clause, for example?
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

Guys , i figured what caused this error , the DB admin is doing some maintenance to the db so he is canceling any requests for the db , so i'll try after this maintenance finish and i'll see...

Thanks much for your help guys
Merry Christmas to all
 
Don't get me started about those stupid light bulbs.
 
subject: The query has been canceled !!