Schema Change Error

From: rahulkav (rahulkav_at_discussions.microsoft.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 02:09:07 -0800

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,
Rahul

Relevant Pages

  • Re: Schema Change Error
    ... > We have a Java application which is running for 24 hours and we have ... We are connected to SQL Server ... > We get the above error when there is a schema change i.e. ... something concurrently that your cursor relies on. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: xsd files only: enough to start writing app. code of a DB-related component ?
    ... junior Java programmer (know Java but this is a J2EE project ... These schema definition files aren't very numerous (about 20 ... claims to be able to generate database structure. ...
    (comp.lang.java.programmer)
  • Jaxb and xsd Help requested
    ... (Note the xsd below is part of a bigger xsd file i ... the source schema. ... Java content class for GuestCountType complex type. ...
    (comp.lang.java.programmer)
  • Possible to validate XML against a DTD using Java 5/JAXB/etc?
    ... There seems to be a lot of deprecated API stuff going on in Java, ... 'DTD' 'schema' for the 'xsd', ...
    (comp.lang.java.programmer)
  • Re: Real-time update index
    ... While sp_fulltext_table does change the schema of the table, ... "Change Tracking" with update index in background, you do not have to set ... exec sp_fulltext_table 'FTSTable','create','FTSCatalog','FTSTable_IDX' ... complete cursor operation because the table schema changed after the cursor ...
    (microsoft.public.sqlserver.fulltext)
Loading