Review

Detector:	MuDetectRankComp_180222_ExcludeInstances
Target:	project ' chensun ' version cf23b99
Misuse:	misuse ' grouminer-9 '
Tags:

Misuse Details

Details about the known misuse from the MUBench dataset.

Description:	The `PreparedStatement` opened in line 702 is never closed. (Same as MuDetect finding 17)
Fix Description:
Violation Types:	missing/call
In File:	database/SocialNetworkDatabasePosts.java
In Method:	addFFAParticipipant(Connection, int, String, String)
Code with Misuse:	`class SocialNetworkDatabasePosts { public static int addFFAParticipipant(Connection conn, int post, String username, String priv) { int status = 0; String query = "INSERT INTO freeforall.postprivileges (pid, username, privilege) " + "VALUES (?, ?, ?)"; PreparedStatement pstmt = null; try { pstmt = conn.prepareStatement(query); pstmt.setInt(1, post); pstmt.setString(2, username); pstmt.setString(3, priv); status = pstmt.executeUpdate(); } catch (SQLException e) { status = 0; } return status; } }`

Potential Hits

Findings of the detector that identify an anomaly in the same file and method as the known misuse.

Hit

Rank

Confidence

Confidence String

Pattern Examples

Pattern Support

Pattern Violation

Target Environment Mapping

Strategy	Rank	Desc
	2	()
Confidence	-	filtered
DefectIndicator	26	(1 / 432 (String)) * 11 / 2
O-E2MN	-	filtered
O-E2MN*PS	-	filtered
O-E2MNPSPU	-	filtered
O-E2MNPSPV	-	filtered
O-E2MNPSPV*PU	-	filtered
O-E2MNPSPV*VS	-	filtered
O-E2MNPSPVVSPU	-	filtered
O-E2MNPSVS	-	filtered
O-E2MNPSVS*PU	-	filtered
O-E2MN*PU	-	filtered
O-E2MN*PV	-	filtered
O-E2MNPVPU	-	filtered
O-E2MNPVVS	-	filtered
O-E2MNPVVS*PU	-	filtered
O-E2MN*VS	-	filtered
O-E2MNVSPU	-	filtered
PS	41	(pattern support = 11 / 22)
PS*PU	47	(pattern support = 11 / 22)*(1 / 432 (String))
PS*PV	-	filtered
PSPVPU	-	filtered
PSPVVS	-	filtered
PSPVVS*PU	-	filtered
PS*VS	17	(pattern support = 11 / 22)*(violation support = 1 / 2)
PSVSPU	26	(pattern support = 11 / 22)(violation support = 1 / 2)(1 / 432 (String))
PU	15	(1 / 432 (String))
PV	-	filtered
PV*PU	-	filtered
PV*VS	-	filtered
PVVSPU	-	filtered
Rareness	17	1 - (2 / 11)
VS	15	(violation support = 1 / 2)
VS*PU	26	(violation support = 1 / 2)*(1 / 432 (String))

chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getRegReqCount(Connection, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriendReqCount(Connection, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriendRequestList(Connection, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfBoard(Connection, String)

Strategy	Rank	Desc
	-	filtered
Confidence	103	11 / (11 + 90)
DefectIndicator	-	filtered
O-E2MN	-	filtered
O-E2MN*PS	-	filtered
O-E2MNPSPU	-	filtered
O-E2MNPSPV	-	filtered
O-E2MNPSPV*PU	-	filtered
O-E2MNPSPV*VS	-	filtered
O-E2MNPSPVVSPU	-	filtered
O-E2MNPSVS	-	filtered
O-E2MNPSVS*PU	-	filtered
O-E2MN*PU	-	filtered
O-E2MN*PV	-	filtered
O-E2MNPVPU	-	filtered
O-E2MNPVVS	-	filtered
O-E2MNPVVS*PU	-	filtered
O-E2MN*VS	-	filtered
O-E2MNVSPU	-	filtered
PS	-	filtered
PS*PU	-	filtered
PS*PV	103	(pattern support = 11 / 22)*(pattern violations = 1 / 90)
PSPVPU	103	(pattern support = 11 / 22)(pattern violations = 1 / 90)(1 / 432 (String))
PSPVVS	-	filtered
PSPVVS*PU	-	filtered
PS*VS	-	filtered
PSVSPU	-	filtered
PU	-	filtered
PV	103	(pattern violations = 1 / 90)
PV*PU	103	(pattern violations = 1 / 90)*(1 / 432 (String))
PV*VS	-	filtered
PVVSPU	-	filtered
Rareness	-	filtered
VS	-	filtered
VS*PU	-	filtered

chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#createBoard(Connection, String, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseDBA.java#createAcappellaGroup(Connection, String, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseRegions.java#createRegion(Connection, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java#createPost(Connection, String, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java#createReply(Connection, String, String, String, String, int)

175

Strategy	Rank	Desc
	-	filtered
Confidence	-	filtered
DefectIndicator	-	filtered
O-E2MN	34	(overlap = 26.00 / 27.00)
O-E2MN*PS	-	filtered
O-E2MNPSPU	-	filtered
O-E2MNPSPV	-	filtered
O-E2MNPSPV*PU	-	filtered
O-E2MNPSPV*VS	-	filtered
O-E2MNPSPVVSPU	-	filtered
O-E2MNPSVS	-	filtered
O-E2MNPSVS*PU	-	filtered
O-E2MN*PU	47	(overlap = 26.00 / 27.00)*(1 / 432 (String))
O-E2MN*PV	-	filtered
O-E2MNPVPU	-	filtered
O-E2MNPVVS	-	filtered
O-E2MNPVVS*PU	-	filtered
O-E2MN*VS	-	filtered
O-E2MNVSPU	-	filtered
PS	-	filtered
PS*PU	-	filtered
PS*PV	-	filtered
PSPVPU	-	filtered
PSPVVS	-	filtered
PSPVVS*PU	-	filtered
PS*VS	-	filtered
PSVSPU	-	filtered
PU	-	filtered
PV	-	filtered
PV*PU	-	filtered
PV*VS	-	filtered
PVVSPU	-	filtered
Rareness	-	filtered
VS	-	filtered
VS*PU	-	filtered

chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#insertRegRequest(Connection, String, int, String, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseDBA.java#createAcappellaGroup(Connection, String, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java#authorizedFFAPost(Connection, String, int, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java#postExists(Connection, String, String, int)
chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#removeParticipant(Connection, String, String, String)

181

Strategy	Rank	Desc
	-	filtered
Confidence	-	filtered
DefectIndicator	-	filtered
O-E2MN	-	filtered
O-E2MN*PS	75	(overlap = 27.00 / 29.00)*(pattern support = 11 / 22)
O-E2MNPSPU	82	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(1 / 432 (String))
O-E2MNPSPV	135	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(pattern violations = 1 / 90)
O-E2MNPSPV*PU	135	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(pattern violations = 1 / 90)*(1 / 432 (String))
O-E2MNPSPV*VS	48	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(pattern violations = 1 / 90)*(violation support = 1 / 2)
O-E2MNPSPVVSPU	48	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(pattern violations = 1 / 90)(violation support = 1 / 2)(1 / 432 (String))
O-E2MNPSVS	16	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(violation support = 1 / 2)
O-E2MNPSVS*PU	25	(overlap = 27.00 / 29.00)(pattern support = 11 / 22)(violation support = 1 / 2)*(1 / 432 (String))
O-E2MN*PU	-	filtered
O-E2MN*PV	135	(overlap = 27.00 / 29.00)*(pattern violations = 1 / 90)
O-E2MNPVPU	135	(overlap = 27.00 / 29.00)(pattern violations = 1 / 90)(1 / 432 (String))
O-E2MNPVVS	26	(overlap = 27.00 / 29.00)(pattern violations = 1 / 90)(violation support = 1 / 2)
O-E2MNPVVS*PU	26	(overlap = 27.00 / 29.00)(pattern violations = 1 / 90)(violation support = 1 / 2)*(1 / 432 (String))
O-E2MN*VS	13	(overlap = 27.00 / 29.00)*(violation support = 1 / 2)
O-E2MNVSPU	25	(overlap = 27.00 / 29.00)(violation support = 1 / 2)(1 / 432 (String))
PS	-	filtered
PS*PU	-	filtered
PS*PV	-	filtered
PSPVPU	-	filtered
PSPVVS	59	(pattern support = 11 / 22)(pattern violations = 1 / 90)(violation support = 1 / 2)
PSPVVS*PU	59	(pattern support = 11 / 22)(pattern violations = 1 / 90)(violation support = 1 / 2)*(1 / 432 (String))
PS*VS	-	filtered
PSVSPU	-	filtered
PU	-	filtered
PV	-	filtered
PV*PU	-	filtered
PV*VS	33	(pattern violations = 1 / 90)*(violation support = 1 / 2)
PVVSPU	33	(pattern violations = 1 / 90)(violation support = 1 / 2)(1 / 432 (String))
Rareness	-	filtered
VS	-	filtered
VS*PU	-	filtered

chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#createBoard(Connection, String, String)
chensun/cf23b99/build/CS5430/src/database/DatabaseDBA.java#createAcappellaGroup(Connection, String, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseRegions.java#createRegion(Connection, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java#createPost(Connection, String, String, String, String)
chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java#createReply(Connection, String, String, String, String, int)