JetBrains / hsql1 Duplication

Intro

For duplication, we look at places in code where there are 6 or more lines of code that are exactly the same.
Before duplication is calculated, the code is cleaned to remove empty lines, comments, and frequently duplicated constructs such as imports.
You should aim at having as little as possible (<5%) of duplicated code as high-level of duplication can lead to maintenance difficulties, poor factoring, and logical contradictions.

Learn more...

Duplication Overall

7% duplication:

68,281 cleaned lines of cleaned code (without empty lines, comments, and frequently duplicated constructs such as imports)
4,833 duplicated lines

475 duplicates

dependency graphs: 2D graph | 3D graph | 3D graph (with duplicates)...

Duplication per Extension

Duplication per Component (primary)

Longest Duplicates

The list of 50 longest duplicates.

See data for all 475 duplicates...

Size	#	Folders	Files	Lines	Code
45	x 2	Web/website Web/website/web	index.html hsqlUsing.html	12:75 (39%) 12:75 (61%)	view
44	x 2	HSQL/src/org/hsqldb1/jdbc HSQL/src/org/hsqldb1/jdbc	jdbcCallableStatement.java jdbcPreparedStatement.java	3107:3214 (13%) 2294:2401 (8%)	view
38	x 2	Web/website/web Web/website/web	hsqlFeatures.html hsqlSupport.html	2:52 (19%) 2:52 (45%)	view
38	x 2	Web/website/web Web/website/web	changelog.html hsqlFAQ.html	2:52 (3%) 2:52 (14%)	view
38	x 2	Web/website/web Web/website/web	hsqlDevelopment.html hsqlLicense.html	2:52 (34%) 2:52 (32%)	view
38	x 2	Web/website/web Web/website/web	hsqlFeatures.html hsqlLicense.html	2:52 (19%) 2:52 (32%)	view
38	x 2	Web/website/web Web/website/web	changelog.html hsqlLicense.html	2:52 (3%) 2:52 (32%)	view
38	x 2	Web/website/web Web/website/web	hsqlFAQ.html hsqlLicense.html	2:52 (14%) 2:52 (32%)	view
38	x 2	Web/website/web Web/website/web	hsqlFAQ.html hsqlFeatures.html	2:52 (14%) 2:52 (19%)	view
38	x 2	Web/website/web Web/website/web	hsqlFAQ.html hsqlSupport.html	2:52 (14%) 2:52 (45%)	view
38	x 2	Web/website/web Web/website/web	changelog.html hsqlDevelopment.html	2:52 (3%) 2:52 (34%)	view
38	x 2	Web/website/web Web/website/web	hsqlDevelopment.html hsqlSupport.html	2:52 (34%) 2:52 (45%)	view
38	x 2	Web/website/web Web/website/web	changelog.html hsqlFeatures.html	2:52 (3%) 2:52 (19%)	view
38	x 2	Web/website/web Web/website/web	changelog.html hsqlSupport.html	2:52 (3%) 2:52 (45%)	view
38	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManager.java ZaurusDatabaseManager.java	703:740 (4%) 539:576 (9%)	view
38	x 2	Web/website/web Web/website/web	hsqlDevelopment.html hsqlFAQ.html	2:52 (34%) 2:52 (14%)	view
38	x 2	Web/website/web Web/website/web	hsqlDevelopment.html hsqlFeatures.html	2:52 (34%) 2:52 (19%)	view
38	x 2	Web/website/web Web/website/web	hsqlLicense.html hsqlSupport.html	2:52 (32%) 2:52 (45%)	view
35	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManager.java DatabaseManagerSwing.java	944:997 (4%) 1825:1878 (2%)	view
32	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManager.java DatabaseManagerSwing.java	246:284 (4%) 531:569 (1%)	view
29	x 2	HSQL/src/org/hsqldb1/lib HSQL/src/org/hsqldb1/util	RCData.java RCData.java	95:137 (12%) 84:126 (15%)	view
29	x 2	unsorted/docsrc/guide unsorted/docsrc/guide	sqlsyntax.xml texttables.xml	1516:1569 (1%) 226:279 (8%)	view
24	x 2	unsorted/testrun/sqltool unsorted/testrun/sqltool	dsv-trimming.sql dsv-trimming.sql	16:46 (43%) 57:87 (43%)	view
23	x 2	HSQL/src/org/hsqldb1/lib HSQL/src/org/hsqldb1/util	RCData.java RCData.java	325:363 (10%) 294:332 (11%)	view
21	x 2	HSQL/src/org/hsqldb1/lib HSQL/src/org/hsqldb1/util	RCData.java RCData.java	402:440 (9%) 372:410 (10%)	view
19	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	TransferSQLText.java TransferSQLText.java	376:401 (3%) 443:468 (3%)	view
19	x 2	HSQL/src/org/hsqldb1/lib HSQL/src/org/hsqldb1/util	RCData.java RCData.java	166:189 (8%) 151:174 (9%)	view
19	x 2	HSQL/src/org/hsqldb1 HSQL/src/org/hsqldb1	Expression.java Expression.java	3702:3730 (<1%) 3780:3808 (<1%)	view
19	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	OracleTransferHelper.java PostgresTransferHelper.java	94:120 (23%) 116:142 (26%)	view
18	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	Grid.java Tree.java	285:332 (8%) 271:316 (9%)	view
18	x 2	Web/website/web Web/website/web	hsqlDevelopment.html topframe.html	21:41 (16%) 19:37 (43%)	view
18	x 2	Web/website/web Web/website/web	hsqlSupport.html topframe.html	21:41 (21%) 19:37 (43%)	view
18	x 2	Web/website/web Web/website/web	hsqlFAQ.html topframe.html	21:41 (7%) 19:37 (43%)	view
18	x 2	Web/website/web Web/website/web	hsqlLicense.html topframe.html	21:41 (15%) 19:37 (43%)	view
18	x 2	HSQL/src/org/hsqldb1 HSQL/src/org/hsqldb1	DatabaseInformationMain.java DatabaseInformationMain.java	2241:2258 (1%) 2372:2389 (1%)	view
18	x 2	Web/website/web Web/website/web	changelog.html topframe.html	21:41 (1%) 19:37 (43%)	view
18	x 2	Web/website/web Web/website/web	hsqlFeatures.html topframe.html	21:41 (9%) 19:37 (43%)	view
17	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManager.java ZaurusDatabaseManager.java	638:662 (2%) 498:522 (4%)	view
17	x 2	HSQL/src/org/hsqldb1 HSQL/src/org/hsqldb1	DITableInfo.java DITableInfo.java	147:169 (7%) 229:251 (7%)	view
16	x 2	Web/website Web/website/web	index.html changelog.html	6:24 (14%) 6:25 (1%)	view
16	x 2	Web/website Web/website/web	index.html hsqlFeatures.html	6:24 (14%) 6:25 (8%)	view
16	x 2	Web/website Web/website/web	index.html hsqlLicense.html	6:24 (14%) 6:25 (13%)	view
16	x 2	unsorted/testrun/sqltool unsorted/testrun/sqltool	nullrep.sql nullrep.sql	48:66 (20%) 86:104 (20%)	view
16	x 2	unsorted/testrun/sqltool unsorted/testrun/sqltool	plcontrolflow.sql plcontrolflow.sql	26:41 (8%) 45:60 (8%)	view
16	x 2	Web/website Web/website/web	index.html hsqlSupport.html	6:24 (14%) 6:25 (19%)	view
16	x 2	HSQL/src/org/hsqldb1 HSQL/src/org/hsqldb1	DatabaseInformationFull.java DatabaseInformationFull.java	3216:3232 (<1%) 3240:3256 (<1%)	view
16	x 2	Web/website Web/website/web	index.html hsqlFAQ.html	6:24 (14%) 6:25 (6%)	view
16	x 2	Web/website Web/website/web	index.html hsqlDevelopment.html	6:24 (14%) 6:25 (14%)	view
15	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManagerSwing.java DatabaseManagerSwing.java	2159:2179 (<1%) 2197:2217 (<1%)	view
14	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManager.java DatabaseManagerSwing.java	827:847 (1%) 1662:1683 (<1%)	view

Duplicated Units

The list of top 7 duplicated units.

See data for all 7 unit duplicates...

Size	#	Folders	Files	Lines	Code
25	x 2	HSQL/src/org/hsqldb1/lib HSQL/src/org/hsqldb1/util	RCData.java RCData.java	402:441 372:411	view
14	x 2	HSQL/src/org/hsqldb1 HSQL/src/org/hsqldb1	Types.java DITypeInfo.java	1231:1249 978:996	view
13	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	DatabaseManagerSwing.java DatabaseManager.java	705:720 335:350	view
12	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	Tree.java Grid.java	290:308 306:324	view
10	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	Tree.java Grid.java	171:187 187:204	view
7	x 2	HSQL/src/org/hsqldb1/util HSQL/src/org/hsqldb1/util	ConnectionDialogSwing.java ConnectionDialog.java	383:393 340:350	view
6	x 2	HSQL/src/org/hsqldb1/lib HSQL/src/org/hsqldb1/lib	IntKeyIntValueHashMap.java LongKeyIntValueHashMap.java	86:97 87:98	view