Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 358743 - SQLException can occur while updating a merge branch
Summary: SQLException can occur while updating a merge branch
Status: RESOLVED FIXED
Alias: None
Product: OSEE
Classification: Technology
Component: OSEE Application Framework (show other bugs)
Version: 0.9.9   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: 0.9.9   Edit
Assignee: Ryan Brooks CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-23 12:27 EDT by Ryan Brooks CLA
Modified: 2011-09-23 14:48 EDT (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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"