java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The statement has been terminated.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Deleting dependent objects question
    via by 3004,
  • KODO not reading object as BLOB
    via by 3004,
  • Read and store user info using PUMA
    via by karin.bj...@intentia.se,
  • JDBC/DAO IllegalStateException on connection
    via springframework by zoeacook
    ,
  • 2005.05.04 21:43:55 [org.jivesoftware.messenger.user.User.insertProperty(User.java:400) ] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'jiveUserProp_pk'. Cannot insert duplicate key in object 'jiveUserProp'. 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.processReply(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source) at org.jivesoftware.messenger.user.User.insertProperty(User.java:397) at org.jivesoftware.messenger.user.User.access$300(User.java:39) at org.jivesoftware.messenger.user.User$PropertiesMap.put(User.java:306) at org.jivesoftware.messenger.spi.PresenceManagerImpl.saveLastUnavailablePresence(PresenceManagerImpl.java:191) at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:117) at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:150) at org.jivesoftware.messenger.PresenceRouter.handle(PresenceRouter.java:86) at org.jivesoftware.messenger.PresenceRouter.route(PresenceRouter.java:59) at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:73) at org.jivesoftware.messenger.net.SocketReadThread.run(SocketReadThread.java:128)
    via by Gaston Dombiak,
  • 2005.05.04 21:43:55 [org.jivesoftware.messenger.user.User.insertProperty(User.java:400) ] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'jiveUserProp_pk'. Cannot insert duplicate key in object 'jiveUserProp'. 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.processReply(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source) at org.jivesoftware.messenger.user.User.insertProperty(User.java:397) at org.jivesoftware.messenger.user.User.access$300(User.java:39) at org.jivesoftware.messenger.user.User$PropertiesMap.put(User.java:306) at org.jivesoftware.messenger.spi.PresenceManagerImpl.saveLastUnavailablePresence(PresenceManagerImpl.java:191) at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:117) at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:150) at org.jivesoftware.messenger.PresenceRouter.handle(PresenceRouter.java:86) at org.jivesoftware.messenger.PresenceRouter.route(PresenceRouter.java:59) at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:73) at org.jivesoftware.messenger.net.SocketReadThread.run(SocketReadThread.java:128)
    via by Gaston Dombiak,
    • java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The statement has been terminated. 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.processInfoToken(UnknownSource) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(UnknownSource) at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(UnknownSource) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(UnknownSource) at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(UnknownSource) at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(UnknownSource) at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(UnknownSource) at com.solarmetric.datasource.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:111) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatementNonBatch(SQLExecutionManagerImpl.java:525) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatement(SQLExecutionManagerImpl.java:494) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeInternal(SQLExecutionManagerImpl.java:388) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.flush(SQLExecutionManagerImpl.java:255) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:515) at com.solarmetric.kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:730) at com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:455) at com.ipacs.als.test.Test.main(Test.java:200)

    Users with the same issue

    Unknown visitor1 times, last one,
    rp
    rp1 times, last one,