apache / empire-dbDuplication

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

13% duplication:

28,525 cleaned lines of cleaned code (without empty lines, comments, and frequently duplicated constructs such as imports)
3,796 duplicated lines

347 duplicates

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

Duplication per Extension

Duplication per Component (primary)

Duplication Between Components (50+ lines)

Download: SVG DOT (open online Graphviz editor)

From Component --> To Component	Duplicated Lines	File Pairs	Details
empire-db-examples (1%) --> empire-db-jsf2 (1%)	140	3 file pairs	details...

Open 3D force graph...

Show more details on duplication between components...

Longest Duplicates

The list of 50 longest duplicates.

See data for all 347 duplicates...

Size	#	Folders	Files	Lines	Code
78	x 2	empire-db-examples/empire-db-example-basic empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	1:166 (92%) 1:166 (92%)	view
69	x 2	empire-db-examples/empir...pire/jsf2/websample/web empire-db-examples/empir.../apache/empire/rest/app	SampleConfig.java SampleConfig.java	28:192 (100%) 28:192 (100%)	view
56	x 2	empire-db-examples/empir...mpire/jsf2/websample/db empire-db-examples/empir...he/empire/vue/sample/db	SampleDB.java SampleDB.java	50:151 (51%) 51:152 (48%)	view
53	x 2	empire-db-examples/empir...mpire/jsf2/websample/db empire-db-examples/empir...he/empire/vue/sample/db	SampleDB.java SampleDB.java	158:266 (48%) 168:276 (46%)	view
44	x 2	empire-db-examples/empir...src/main/webapp/WEB-INF empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	1:100 (52%) 1:100 (52%)	view
44	x 2	empire-db-examples/empire-db-example-basic empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	1:100 (52%) 1:100 (52%)	view
41	x 2	empire-db-examples/empir.../apache/empire/rest/app empire-db-jsf2/src/main/...apache/empire/jsf2/impl	ResourceTextResolver.java ResourceTextResolver.java	50:120 (80%) 51:121 (80%)	view
41	x 2	empire-db/src/main/java/...apache/empire/dbms/hsql empire-db/src/main/java/...ache/empire/dbms/oracle	DBCommandHSql.java DBCommandOracle.java	93:158 (61%) 282:347 (23%)	view
30	x 2	empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/org/apache/empire/dbms/h2	DBMSHandlerDerby.java DBMSHandlerH2.java	195:237 (24%) 271:313 (19%)	view
27	x 2	empire-db-examples/empire-db-example-advanced empire-db-examples/empire-db-example-basic	config.xml config.xml	121:177 (31%) 121:177 (32%)	view
26	x 2	empire-db-examples/empir...src/main/webapp/WEB-INF empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	115:166 (30%) 115:166 (30%)	view
26	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerH2.java DBMSHandlerMySQL.java	279:317 (16%) 1078:1116 (3%)	view
26	x 2	empire-db-examples/empire-db-example-basic empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	115:166 (30%) 115:166 (30%)	view
25	x 2	empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/org/apache/empire/dbms/h2	DBMSHandlerDerby.java DBMSHandlerH2.java	240:297 (20%) 316:373 (16%)	view
23	x 2	empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerDerby.java DBMSHandlerMySQL.java	242:297 (18%) 1122:1178 (2%)	view
23	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerH2.java DBMSHandlerMySQL.java	318:373 (14%) 1122:1178 (2%)	view
23	x 2	empire-db-examples/empir...mpire/jsf2/websample/db empire-db-examples/empir...he/empire/vue/sample/db	SampleTable.java SampleTable.java	32:79 (100%) 32:79 (100%)	view
23	x 2	empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerDerby.java DBMSHandlerMySQL.java	203:237 (18%) 1078:1112 (2%)	view
22	x 2	empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/.../empire/dbms/postgresql	DBMSHandlerMySQL.java DBCommandPostgres.java	75:112 (2%) 130:167 (31%)	view
21	x 2	empire-db-examples/empire-db-example-advanced empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	121:166 (24%) 121:166 (25%)	view
21	x 2	empire-db-examples/empire-db-example-advanced empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	121:166 (24%) 121:166 (25%)	view
21	x 2	empire-db-examples/empir...sf2/src/main/webapp/css empire-db-examples/empir...main/vue/src/assets/css	common.css layout.css	39:61 (38%) 36:58 (9%)	view
20	x 2	empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/...ache/empire/dbms/sqlite	DBMSHandlerMySQL.java DBMSHandlerSQLite.java	1055:1075 (2%) 333:353 (6%)	view
19	x 2	empire-db-examples/empir...main/vue/src/components empire-db-examples/empir...main/vue/src/components	e-input.vue e-value.vue	74:92 (13%) 42:60 (23%)	view
19	x 2	empire-db/src/main/java/org/apache/empire/db empire-db/src/main/java/org/apache/empire/db	DBUtils.java DBUtils.java	980:1012 (4%) 1134:1166 (4%)	view
18	x 2	empire-db-examples/empire-db-example-advanced empire-db-examples/empire-db-example-basic	config.xml config.xml	1:50 (21%) 1:50 (21%)	view
18	x 2	empire-db-examples/empire-db-example-advanced empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	1:50 (21%) 1:50 (21%)	view
18	x 2	empire-db-examples/empire-db-example-advanced empire-db-examples/empir...src/main/webapp/WEB-INF	config.xml config.xml	1:50 (21%) 1:50 (21%)	view
17	x 2	empire-db/src/main/java/org/apache/empire/db empire-db/src/main/java/org/apache/empire/db	DBUtils.java DBUtils.java	825:854 (3%) 1133:1162 (3%)	view
17	x 2	empire-db/src/main/java/org/apache/empire/db empire-db/src/main/java/...pache/empire/dbms/mysql	DBDDLGenerator.java MySQLDDLGenerator.java	570:597 (5%) 207:234 (15%)	view
17	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerH2.java DBMSHandlerMySQL.java	207:237 (10%) 1006:1036 (1%)	view
17	x 2	empire-db-examples/empir...sf2/src/main/webapp/css empire-db-examples/empir...main/vue/src/assets/css	content.css layout.css	46:64 (15%) 125:142 (7%)	view
17	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	ControlTag.java InputTag.java	606:639 (4%) 272:305 (8%)	view
16	x 2	empire-db/src/main/java/org/apache/empire/db empire-db/src/main/java/org/apache/empire/db	DBUtils.java DBUtils.java	826:854 (3%) 980:1008 (3%)	view
16	x 2	empire-db-examples/empire-db-example-codegen empire-db-examples/empire-db-example-codegen	generate-config.xml generate-example.xml	68:95 (44%) 69:96 (32%)	view
16	x 2	empire-db-examples/empir...-vue/src/main/vue/build empire-db-examples/empir...-vue/src/main/vue/build	build-dev.js build.js	32:49 (61%) 32:55 (61%)	view
15	x 2	empire-db/src/main/java/...apache/empire/data/list empire-db/src/main/java/org/apache/empire/db	DataListHead.java DBRecordData.java	108:140 (34%) 468:500 (8%)	view
15	x 2	empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/...ache/empire/dbms/sqlite	DBMSHandlerDerby.java DBMSHandlerSQLite.java	203:227 (12%) 356:380 (5%)	view
15	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerH2.java DBMSHandlerMySQL.java	261:276 (9%) 1060:1075 (1%)	view
15	x 2	empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/.../empire/dbms/postgresql	DBMSHandlerMySQL.java DBCommandPostgres.java	974:994 (1%) 140:162 (21%)	view
15	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...ache/empire/dbms/sqlite	DBMSHandlerH2.java DBMSHandlerSQLite.java	261:276 (9%) 338:353 (5%)	view
15	x 2	empire-db-jsf2/src/main/...pache/empire/jsf2/pages empire-db/src/main/java/org/apache/empire/db	PageElement.java DBColumnExpr.java	122:147 (26%) 257:282 (4%)	view
15	x 2	empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/...ache/empire/dbms/sqlite	DBMSHandlerMySQL.java DBMSHandlerSQLite.java	1015:1042 (1%) 293:321 (5%)	view
15	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...ache/empire/dbms/sqlite	DBMSHandlerH2.java DBMSHandlerSQLite.java	279:303 (9%) 356:380 (5%)	view
15	x 2	empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/...ache/empire/dbms/sqlite	DBMSHandlerMySQL.java DBMSHandlerSQLite.java	1078:1102 (1%) 356:380 (5%)	view
15	x 2	empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerMySQL.java DBMSHandlerMySQL.java	85:107 (1%) 974:994 (1%)	view
15	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...apache/empire/dbms/hsql	DBMSHandlerH2.java DBCommandHSql.java	84:107 (9%) 65:88 (22%)	view
14	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/.../empire/dbms/postgresql	DBMSHandlerH2.java DBMSHandlerPostgreSQL.java	214:239 (9%) 150:175 (5%)	view
14	x 2	empire-db-examples/empir...pire/jsf2/websample/web empire-db-jsf2/src/main/.../apache/empire/jsf2/app	SampleApplication.java WebApplication.java	311:331 (9%) 448:467 (6%)	view
14	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	ControlTag.java InputTag.java	705:732 (3%) 365:392 (7%)	view

Duplicated Units

The list of top 36 duplicated units.

See data for all 36 unit duplicates...

Size	#	Folders	Files	Lines	Code
59	x 3	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerH2.java DBMSHandlerDerby.java DBMSHandlerMySQL.java	228:297 152:221 1027:1096	view
50	x 2	empire-db/src/main/java/...ache/empire/dbms/oracle empire-db/src/main/java/...apache/empire/dbms/hsql	DBCommandOracle.java DBCommandHSql.java	283:348 94:159	view
29	x 2	empire-db-jsf2/src/main/...apache/empire/jsf2/impl empire-db-examples/empir.../apache/empire/rest/app	ResourceTextResolver.java ResourceTextResolver.java	89:123 88:122	view
20	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/derby	DBMSHandlerH2.java DBMSHandlerDerby.java	303:326 227:250	view
18	x 2	empire-db-jsf2/src/main/...apache/empire/jsf2/impl empire-db-examples/empir.../apache/empire/rest/app	ResourceTextResolver.java ResourceTextResolver.java	55:74 54:73	view
16	x 2	empire-db-examples/empir.../apache/empire/rest/app empire-db-examples/empir...pire/jsf2/websample/web	SampleConfig.java SampleConfig.java	58:78 58:78	view
15	x 2	empire-db-examples/empir...he/empire/vue/sample/db empire-db-examples/empir...mpire/jsf2/websample/db	SampleDB.java SampleDB.java	219:242 209:232	view
15	x 2	empire-db-examples/empir.../apache/empire/rest/app empire-db-examples/empir...pire/jsf2/websample/web	SampleConfig.java SampleConfig.java	147:167 147:167	view
15	x 2	empire-db/src/main/java/.../empire/dbms/postgresql empire-db/src/main/java/...pache/empire/dbms/derby	PostgresDDLGenerator.java DerbyDDLGenerator.java	168:189 64:84	view
14	x 2	empire-db-examples/empir.../apache/empire/rest/app empire-db-examples/empir...pire/jsf2/websample/web	SampleServiceApp.java SampleApplication.java	119:141 169:191	view
14	x 2	empire-db/src/main/java/...ache/empire/dbms/oracle empire-db/src/main/java/...apache/empire/dbms/hsql	OracleDDLGenerator.java HSqlDDLGenerator.java	119:135 84:100	view
12	x 2	empire-db/src/main/java/...ache/empire/dbms/oracle empire-db/src/main/java/...apache/empire/dbms/hsql	OracleDDLGenerator.java HSqlDDLGenerator.java	95:110 66:81	view
10	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	MenuItemTag.java MenuListTag.java	147:160 149:162	view
10	x 2	empire-db-examples/empir...-vue/src/main/vue/build empire-db-examples/empir...-vue/src/main/vue/build	build.js build-dev.js	36:54 36:48	view
10	x 2	empire-db/src/main/java/.../empire/dbms/postgresql empire-db/src/main/java/...pache/empire/dbms/mysql	DBCommandPostgres.java DBMSHandlerMySQL.java	152:165 97:110	view
10	x 2	empire-db/src/main/java/.../empire/dbms/postgresql empire-db/src/main/java/...ache/empire/dbms/oracle	PostgresDDLGenerator.java OracleDDLGenerator.java	152:165 140:153	view
10	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...apache/empire/dbms/hsql	DBMSHandlerH2.java DBCommandHSql.java	97:110 78:91	view
10	x 2	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/mysql	DBMSHandlerH2.java DBMSHandlerMySQL.java	208:220 1007:1019	view
10	x 4	empire-db/src/main/java/org/apache/empire/dbms/h2 empire-db/src/main/java/...pache/empire/dbms/derby empire-db/src/main/java/...pache/empire/dbms/mysql empire-db/src/main/java/...e/empire/dbms/sqlserver	DBMSHandlerH2.java DBMSHandlerDerby.java DBMSHandlerMySQL.java DBMSHandlerMSSQL.java	332:343 256:267 1137:1148 476:487	view
9	x 2	empire-db-examples/empir...he/empire/vue/sample/db empire-db-examples/empir...mpire/jsf2/websample/db	SampleDB.java SampleDB.java	88:106 87:105	view
9	x 2	empire-db-examples/empir...he/empire/vue/sample/db empire-db-examples/empir...mpire/jsf2/websample/db	SampleDB.java SampleDB.java	257:270 247:260	view
9	x 2	empire-db/src/main/java/.../empire/dbms/postgresql empire-db/src/main/java/...e/empire/db/expr/column	PostgresFuncExpr.java DBFuncExpr.java	61:72 147:158	view
9	x 2	empire-db/src/main/java/...e/empire/db/expr/column empire-db/src/main/java/...e/empire/db/expr/column	DBCaseExpr.java DBCaseWhenExpr.java	159:172 175:188	view
8	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	InputTag.java ControlTag.java	273:285 607:619	view
8	x 2	empire-db-examples/empir...he/empire/vue/sample/db empire-db-examples/empir...mpire/jsf2/websample/db	SampleDB.java SampleDB.java	175:190 165:180	view
8	x 2	empire-db-examples/empir...he/empire/vue/sample/db empire-db-examples/empir...mpire/jsf2/websample/db	SampleTable.java SampleTable.java	44:58 44:58	view
8	x 2	empire-db/src/main/java/...ache/empire/dbms/oracle empire-db/src/main/java/...e/empire/dbms/sqlserver	DBMSHandlerOracle.java DBMSHandlerMSSQL.java	430:441 584:595	view
7	x 2	empire-db-jsf2/src/main/...apache/empire/jsf2/impl empire-db-examples/empir.../apache/empire/rest/app	ResourceTextResolver.java ResourceTextResolver.java	77:86 76:85	view
7	x 2	empire-db-jsf2/src/main/.../apache/empire/jsf2/app empire-db-jsf2/src/main/...pache/empire/jsf2/pages	DBELResolver.java PagesELResolver.java	183:191 156:164	view
7	x 2	empire-db-jsf2/src/main/...he/empire/jsf2/controls empire-db-jsf2/src/main/...he/empire/jsf2/controls	RadioInputControl.java SelectInputControl.java	325:333 402:410	view
7	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	InputTag.java ControlTag.java	380:390 720:730	view
7	x 2	empire-db/src/main/java/org/apache/empire/db empire-db/src/main/java/org/apache/empire/db	DBRecord.java DBRecordBean.java	235:246 139:150	view
6	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	InputTag.java ControlTag.java	288:297 622:631	view
6	x 2	empire-db-jsf2/src/main/.../empire/jsf2/components empire-db-jsf2/src/main/.../empire/jsf2/components	LabelTag.java LinkTag.java	72:81 119:128	view
6	x 2	empire-db-examples/empir...e/vue/sample/db/records empire-db-examples/empir...f2/websample/db/records	EmployeeRecord.java EmployeeRecord.java	43:50 55:62	view
6	x 2	empire-db-examples/empir...he/empire/vue/sample/db empire-db-examples/empir...mpire/jsf2/websample/db	SampleDB.java SampleDB.java	244:255 234:245	view