Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 358743

Summary: SQLException can occur while updating a merge branch
Product: [Technology] OSEE Reporter: Ryan Brooks <ryan.d.brooks>
Component: OSEE Application FrameworkAssignee: Ryan Brooks <ryan.d.brooks>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3    
Version: 0.9.9   
Target Milestone: 0.9.9   
Hardware: All   
OS: All   
Whiteboard:

Description Ryan Brooks CLA 2011-09-23 12:27:01 EDT 
java.sql.SQLException: Missing IN or OUT parameter at index:: 3
	at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
	at org.eclipse.osee.framework.database.internal.core.OseeDatabaseServiceImpl.runPreparedUpdate(OseeDatabaseServiceImpl.java:119)
	at org.eclipse.osee.framework.database.core.ConnectionHandler.runPreparedUpdate(ConnectionHandler.java:89)
	at org.eclipse.osee.framework.skynet.core.artifact.UpdateMergeBranch.purgeArtifactFromBranch(UpdateMergeBranch.java:248)
	at org.eclipse.osee.framework.skynet.core.artifact.UpdateMergeBranch.handleTxWork(UpdateMergeBranch.java:117)
	at org.eclipse.osee.framework.database.core.DbTransaction$InternalTransactionWork.handleTxWork(DbTransaction.java:81)
	at org.eclipse.osee.framework.database.core.DatabaseTransactions.execute(DatabaseTransactions.java:38)
	at org.eclipse.osee.framework.database.core.DatabaseTransactions.execute(DatabaseTransactions.java:26)
	at org.eclipse.osee.framework.database.core.DbTransaction.execute(DbTransaction.java:37)
	at org.eclipse.osee.framework.skynet.core.artifact.BranchManager.getOrCreateMergeBranch(BranchManager.java:313)
	at org.eclipse.osee.framework.skynet.core.revision.ConflictManagerInternal.getConflictsPerBranch(ConflictManagerInternal.java:132)
	at org.eclipse.osee.framework.skynet.core.conflict.ConflictManagerExternal.getOriginalConflicts(ConflictManagerExternal.java:40)
	at org.eclipse.osee.framework.skynet.core.conflict.ConflictManagerExternal.getRemainingConflicts(ConflictManagerExternal.java:52)
	at org.eclipse.osee.framework.ui.skynet.commandHandlers.branch.commit.CommitHandler.commitBranch(CommitHandler.java:56)
	at org.eclipse.osee.framework.ui.skynet.commandHandlers.branch.commit.CommitHandler$CommitJob.run(CommitHandler.java:181)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Comment 1 Ryan Brooks CLA 2011-09-23 12:28:49 EDT 
This code defect was introduced with commit "refinement: Replace artifact revert with artifact replace with baseline" which removed an sql bind parameter  but didn't remove the reference to it from the sql PURGE_BASELINE_ARTIFACT_TRANS.
Comment 2 Ryan Brooks CLA 2011-09-23 14:48:12 EDT 
Resolved on 0.9.9_SR2 by commit "bug[bgz_358743]: Fix SQLException that can occur while updating a merge branch"
Comment 3 Ryan Brooks CLA 2011-09-23 14:48:44 EDT 
Resolved on branch 0.9.9_SR2 with commit "bug[bgz_358743]: Fix SQLException that can occur while updating a merge branch"