Hi all
The table get locked after the program throws an exception. I have tried closing the session and rolling back the transaction but the table sitll gets locked. What I need to do to solve this problem?
I am using MS SQL Server 2000 and MS provided JDBC driver. Is it because the problem in the JDBC driver
or other reason? It is dangerous if the table get locked in the production.
The following is my program and it throws the following exception and the table get locked since then.
Code:
Session sess = HibernateSession.currentSession();
Transaction t = sess.beginTransaction();
try {
sess.save(log);
if (log.getDnaServiceLog() != null) {
sess.save(log.getDnaServiceLog());
sess.save(log.getDnaServiceLog().getDnaAuthorizerLog()); //throws exception
//the program works fine if I save log.getDnaServiceLog().getDnaAuthorizerLog first
}
} catch (HibernateException e) {
t.rollback();
}
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_DnaAuthorizerLog_DnaServiceLog'. The conflict occurred in database 'dna', table 'DnaServiceLog', column 'id'.
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 net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2261)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.saveRecord(AddDnaServiceRequestProcessor.java:173)
at com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.addAccount(AddDnaServiceRequestProcessor.java:114)
at com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.execute(AddDnaServiceRequestProcessor.java:61)
at com.dna.control.CentralizedRequestProcessingMediator.execute(CentralizedRequestProcessingMediator.java:128)
at com.dna.control.CentralizedRequestProcessingMediator$1.run(CentralizedRequestProcessingMediator.java:62)
ERROR [Thread-3] (SessionImpl.java:2269) - Could not synchronize database state with session
net.sf.hibernate.JDBCException: could not insert: [com.dna.dataaccesslayer.hibernate.dataobjects.DnaAuthorizerLog#27]
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:479)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2261)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.saveRecord(AddDnaServiceRequestProcessor.java:173)
at com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.addAccount(AddDnaServiceRequestProcessor.java:114)
at com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.execute(AddDnaServiceRequestProcessor.java:61)
at com.dna.control.CentralizedRequestProcessingMediator.execute(CentralizedRequestProcessingMediator.java:128)
at com.dna.control.CentralizedRequestProcessingMediator$1.run(CentralizedRequestProcessingMediator.java:62)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_DnaAuthorizerLog_DnaServiceLog'. The conflict occurred in database 'dna', table 'DnaServiceLog', column 'id'.
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 net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469)
... 11 more
WARN [Thread-3] (AddDnaServiceRequestProcessor.java:176) - net.sf.hibernate.JDBCException: could not insert: [com.dna.dataaccesslayer.hibernate.dataobjects.DnaAuthorizerLog#27]
could not insert: [com.dna.dataaccesslayer.hibernate.dataobjects.DnaAuthorizerLog#27]
Root Cause:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_DnaAuthorizerLog_DnaServiceLog'. The conflict occurred in database 'dna', table 'DnaServiceLog', column 'id'.
StackTrace:
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:479)
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443)
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308)
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2261)
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187)
net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.saveRecord(AddDnaServiceRequestProcessor.java:173)
com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.addAccount(AddDnaServiceRequestProcessor.java:114)
com.dna.model.requestprocessors.AddDnaServiceRequestProcessor.execute(AddDnaServiceRequestProcessor.java:61)
com.dna.control.CentralizedRequestProcessingMediator.execute(CentralizedRequestProcessingMediator.java:128)
com.dna.control.CentralizedRequestProcessingMediator$1.run(CentralizedRequestProcessingMediator.java:62)
Login
FAQ
Search
