Review

Detector:	MuDetect_180215_ExcludeVeryPrevalentFixed
Target:	project ' chensun ' version cf23b99
Misuse:	misuse ' jadet-1 '
Tags:

Misuse Details

Details about the known misuse from the MUBench dataset.

Description:	The `PreparedStatement` opened in line 635 is never closed. (Same as MuDetect finding 19)
Fix Description:
Violation Types:	missing/call
In File:	database/SocialNetworkDatabasePosts.java
In Method:	getPost(Connection, String, String, String, int)
Code with Misuse:	class SocialNetworkDatabasePosts { /** Gets a post from the designated board and region * with the given post number. * ASSUMES that the board, region, and post are all valid. / public static String getPost(Connection conn, String username, String boardName, String regionName, int postNum) { String getOriginalPost = ""; String getReplies = ""; String postAndReplies = ""; /No joining of results because of redundancy of data returned/ if (boardName.equals("freeforall")) { getOriginalPost = "SELECT FROM freeforall.posts " + "WHERE pid = ?"; getReplies = "SELECT * FROM freeforall.replies " + "WHERE pid = ? ORDER BY dateReplied ASC"; } else { getOriginalPost = "SELECT * FROM " + boardName + ".posts " + "WHERE pid = ? AND rname = ?"; getReplies = "SELECT * FROM " + boardName + ".replies " + "WHERE pid = ? AND rname = ? ORDER BY dateReplied ASC"; } PreparedStatement originalPost = null; ResultSet postResult = null; PreparedStatement replies = null; ResultSet repliesResult = null; boolean sqlex = false; try { originalPost = conn.prepareStatement(getOriginalPost); replies = conn.prepareStatement(getReplies); originalPost.setInt(1, postNum); replies.setInt(1, postNum); if (!boardName.equals("freeforall")) { originalPost.setString(2, regionName); replies.setString(2, regionName); } postResult = originalPost.executeQuery(); if (postResult.next()) { /Only expect one post result/ //Make sure the checksum is correct if (!Arrays.equals( Hash.generateChecksum((SharedKeyCrypto.decrypt(postResult.getString("content"))).getBytes("UTF8")), CryptoUtil.decode(postResult.getString("checksum")))) { postAndReplies += "print ----- Post# " + postNum + "[" + postResult.getString("postedBy") + "]----- " + postResult.getTimestamp("datePosted").toString() + ";print \t" + "Content could not be fetched -- Integrity Failure!" + ";"; } else { postAndReplies += "print ----- Post# " + postNum + "[" + postResult.getString("postedBy") + "]----- " + postResult.getTimestamp("datePosted").toString() + ";print \t" + SharedKeyCrypto.decrypt(postResult.getString("content")) + ";"; } repliesResult = replies.executeQuery(); while (repliesResult.next()) { //Print out all replies //for each reply, make sure the checksum is correct. if(!Arrays.equals( Hash.generateChecksum((SharedKeyCrypto.decrypt(repliesResult.getString("content"))).getBytes("UTF8")), CryptoUtil.decode(repliesResult.getString("checksum")))) { postAndReplies += "print ----- Reply[" + repliesResult.getString("repliedBy") + "] ----- " + repliesResult.getTimestamp("dateReplied").toString() + ";print \t" + "Content could not be fetched -- Integrity Failure!" + ";"; } else { postAndReplies += "print ----- Reply[" + repliesResult.getString("repliedBy") + "] ----- " + repliesResult.getTimestamp("dateReplied").toString() + ";print \t" + SharedKeyCrypto.decrypt(repliesResult.getString("content")) + ";"; } } } // if there's no postResult, the post DNE. } catch (SQLException e) { e.printStackTrace(); sqlex = true; } catch (UnsupportedEncodingException e) { // This should not happen. } if (postAndReplies.equals("") && !sqlex) { return "print Error: Post does not exist. Refresh. If the problem persists, contact an admin."; } else if (sqlex) { return "print Error: Database error while querying post and replies. Contact an admin."; } else return postAndReplies; } }

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
?	57	0.013026819923371647	(pattern support = 12 / 15)(pattern violations = 1 / 58)(overlap = 17.00 / 18.00)	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/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#removeParticipant(Connection, String, String, String)	12
?	58	0.013026819923371647	(pattern support = 12 / 15)(pattern violations = 1 / 58)(overlap = 17.00 / 18.00)	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/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#removeParticipant(Connection, String, String, String)	12
?	101	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	102	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	103	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	104	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	105	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	106	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	107	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	108	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	109	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10
?	110	0.00992063492063492	(pattern support = 10 / 15)(pattern violations = 1 / 56)(overlap = 5.00 / 6.00)	chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAllUsersOfGroup(Connection, int) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getAdminsOfGroup(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getFriends(Connection, String) chensun/cf23b99/build/CS5430/src/database/DatabaseAdmin.java#getParticipantsOne(Connection, String, String) chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java#getBoardAdmins(Connection, String)	10