Post reply

Schema CHange Error

  • November 17, 2004 at 10:32 am

    #86938

    Hi,

    We are getting following Exception in our Java application:

    ====================================================

    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not complete cursor operation because the table schema changed after the cursor was declared.

    at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

    at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

    at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

    at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

    at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

    at com.microsoft.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)

    at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.getRow(Unknown Source)

    at com.microsoft.jdbc.sqlserver.SQLServerImplResultSetServerSideCursor.positionCursor(Unknown Source)

    at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)

    ---------------------------------------------------------------------

    We have a Java application which is running for 24 hours and we have implemented our own connection pooling. We are connected to SQL Server 2000 with Serverice pack 3 installed.

    We get the above error when there is a schema change i.e. Creating a new table, Dropping an existing table. This schema change is done by a stored procedure which is run in parallel with our Java application.

    We have restared our application but sometimes it doesn't make any difference. The tables created and droped are in tempDB.

    This error doesn't occur regularly and all environments. It seems to be an intermittent error i.e. some bug in SQL Server.

    Can anybody plz help ?

    rgds,

     

  • November 18, 2004 at 2:48 am

    #530601

    It might be worth considering to post this to

    http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.jdbcdriver&cat=en_US_2e7397de-c0af-4aee-9c28-eee388c0f48e&lang=en&cr=US

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 19, 2004 at 3:29 am

    #530778

    Thanks for your suggestion. I have posted the query on the above mentioned forum as well.

    cheers,

    Rahul

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply