DBUtils.java
| Index Score | ||
|---|---|---|
 |
 |
org.compiere.db |
 |
 |
Compiere |
View: Reasons, Metrics, Source Code
These are the metrics that contribute to the Enerjy Score for this file, ranked by impact. So the metrics listed at the top influence the score to a greater extent that the metrics listed at the bottom.
| Metric | Description | |
|---|---|---|
| JAVA0034 | JAVA0034 Missing braces in if statement |  |
| EXEC_COMMENTS | Comments in executable code | |
| JAVA0144 | JAVA0144 Line exceeds maximum M characters | |
| COMPARISONS | Number of comparison operators | |
| JAVA0266 | JAVA0266 Use of System.out | |
| JAVA0163 | JAVA0163 Empty statement | |
| LINE_COMMENT | Number of line comments | |
| JAVA0071 | JAVA0071 Strings compared with == | |
| JAVA0117 | JAVA0117 Missing javadoc: method 'method' | |
| OPERANDS | Number of operands | |
| PROGRAM_VOLUME | Halstead program volume | |
| PROGRAM_VOCAB | Halstead program vocabulary | |
| UNIQUE_OPERATORS | Number of unique operators | |
| JAVA0126 | JAVA0126 Method declares unchecked exception in throws | |
| UNIQUE_OPERANDS | Number of unique operands | |
| JAVA0110 | JAVA0110 Incorrect javadoc: no @return tag | |
| CYCLOMATIC | Cyclomatic complexity | |
| PROGRAM_LENGTH | Halstead program length | |
| JAVA0173 | JAVA0173 Unused method parameter | |
| LOOPS | Number of loops | |
| JAVA0108 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| COMMENTS | Comment lines | |
| LINES | Number of lines in the source file | |
| JAVA0003 | JAVA0003 Minimize use of on-demand (.*) imports | |
| FUNCTIONS | Number of function declarations | |
| LOGICAL_LINES | Number of statements | |
| OPERATORS | Number of operators | |
| SIZE | Size of the file in bytes | |
/******************************************************************************
* Product: Compiere ERP & CRM Smart Business Solution *
* Copyright (C) 1999-2007 ComPiere, Inc. All Rights Reserved. *
* This program is free software, you can redistribute it and/or modify it *
* under the terms version 2 of the GNU General Public License as published *
* by the Free Software Foundation. This program is distributed in the hope *
* that it will be useful, but WITHOUT ANY WARRANTY, without even the implied *
* warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. *
* See the GNU General Public License for more details. *
* You should have received a copy of the GNU General Public License along *
* with this program, if not, write to the Free Software Foundation, Inc., *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. *
* For the text or an alternative of this public license, you may reach us *
* ComPiere, Inc., 3600 Bridge Parkway #102, Redwood City, CA 94065, USA *
* or via info@compiere.org or http://www.compiere.org/license.html *
*****************************************************************************/
package org.compiere.db;
import java.math.*;
import java.sql.*;
import java.util.*;
import org.compiere.*;
import org.compiere.common.*;
import org.compiere.model.*;
import org.compiere.util.*;
//import com.compiere.migrate.DBImport;
/**
* Database Utilities
*
* @author Jinglun Zhang a few common functions, some merged from existing classes so that we do not need to maintain multiple copies
* @version $Id$
*/
public class DBUtils
{
/** Logger */
private static CLogger log = CLogger.getCLogger (DBUtils.class);
/**************************************************************************
* jz
*
* rewrite SQL if there is ROWNUM=1 in a query with updated in select max(updated) from ...
* this is not a generic solution, with
* assume: 1. only ROWNUM=1
* 2. it is in a query with 1 table and the table has a column called "UPDATED"
* 3. key words in upper case
*
* @param oraS oracle style statement
* @return statement
*/
public static String repRownum (String oraS)
{
if (oraS == null || oraS.length()==0)
return oraS;
int irn = oraS.indexOf(" ROWNUM=1");
if (irn == -1)
return oraS;
//get all indexes needed
int isel = 0;
int ire = 0;
int iFrom = 0;
String cid = null;
ire = oraS.indexOf(")", irn);
if (ire == -1)
ire = oraS.length();
String sq = oraS.substring(0, ire+1);
int iselt = isel;
while (iselt < ire && isel != -1)
{
iselt = sq.indexOf("SELECT");
if (iselt != -1)
isel = iselt;
}
iFrom = sq.indexOf(" FROM ", isel);
sq = sq.substring(iFrom+5, ire);
//make right correlated ID
String[] tabIDs = sq.split(" ", 3);
if (tabIDs[1].equals(",")||tabIDs.equals("WHERE"))
;
else
cid = tabIDs[1]+".";
sq = oraS.substring(iFrom, oraS.charAt(ire)==')'?ire:ire+1);
String cid1 = null;
if (cid != null)
{
cid1 = cid.substring(0,cid.length())+"1.";
sq=sq.replaceAll(cid,cid1);
}
//construct new SQL
StringBuffer sql = new StringBuffer(oraS.substring(0,irn));
sql.append(cid + "UPDATED in ( SELECT MAX(" + cid1 + "UPDATED) " + sq + ") ");
if (ire<oraS.length())
sql.append(oraS.substring(ire+1, oraS.length()));
//
return sql.toString();
}
/**
* Create SQL TO Date String from Timestamp
*
* @param time Date to be converted
* @param dayOnly true if time set to 00:00:00
* @return date function
*/
public static String TO_DATE (Timestamp time, boolean dayOnly)
{
if (time == null)
{
if (dayOnly)
//jz return "convert(date,getdate())";
return "trunc(getdate(), 'DD')"; //jz default to 'DD'
return "getdate()";
}
GregorianCalendar cal = new GregorianCalendar();
cal.setTime(time);
//
//jz StringBuffer dateString = new StringBuffer("convert(datetime,'");
StringBuffer dateString = new StringBuffer("TIMESTAMP('");
// yyyy.mm.dd - format 2 p.411
/* jz
if (dayOnly)
{
int yyyy = cal.get(Calendar.YEAR);
String format = "102"; // "SQL Standard" format
if (yyyy < 100)
format = "2";
dateString.append(yyyy).append(".")
.append(getXX(cal.get(Calendar.MONTH)+1)).append(".")
.append(getXX(cal.get(Calendar.DAY_OF_MONTH)))
.append("',").append(format).append(")");
}
// mon dd yyy hh:mi:ss - format 116
else
{
int yyyy = cal.get(Calendar.YEAR);
String format = "116"; // n/a format
if (yyyy < 100)
format = "16";
dateString.append(MONTHS[cal.get(Calendar.MONTH)]).append(" ")
.append(getXX(cal.get(Calendar.DAY_OF_MONTH))).append(" ")
.append(getXX(cal.get(Calendar.YEAR))).append(" ")
.append(getXX(cal.get(Calendar.HOUR_OF_DAY))).append(":")
.append(getXX(cal.get(Calendar.MINUTE))).append(":")
.append(getXX(cal.get(Calendar.SECOND)))
.append("',").append(format).append(")");
}
jz */
if (dayOnly)
{
int yyyy = cal.get(Calendar.YEAR);
dateString.append(yyyy)
.append(getXX(cal.get(Calendar.MONTH)+1))
.append(getXX(cal.get(Calendar.DAY_OF_MONTH)))
.append("000000").append("')");
}
// mon dd yyy hh:mi:ss - format 116
else
{
int yyyy = cal.get(Calendar.YEAR);
dateString.append(yyyy)
.append(getXX(cal.get(Calendar.MONTH)+1))
.append(getXX(cal.get(Calendar.DAY_OF_MONTH)))
.append(getXX(cal.get(Calendar.HOUR_OF_DAY)))
.append(getXX(cal.get(Calendar.MINUTE)))
.append(getXX(cal.get(Calendar.SECOND)))
.append("')");
}
return dateString.toString();
} // TO_DATE
/**
* Get integer as two string digits (leading zero)
* @param x integer
* @return string of x
*/
private static String getXX (int x)
{
if (x < 10)
return "0" + x;
return String.valueOf(x);
} // getXX
/**
* Use user defined SQL functions for formatted Date, Number
*
* @param columnName the column name in the SQL
* @param displayType Display Type
* @param AD_Language 6 character language setting (from Env.LANG_*)
*
* @return TRIM(TO_CHAR(columnName,'9G999G990D00','NLS_NUMERIC_CHARACTERS='',.'''))
* or TRIM(TO_CHAR(columnName,'TM9')) depending on DisplayType and Language
* @see org.compiere.util.DisplayType
* @see org.compiere.util.Env
*
**/
public static String TO_CHAR (String columnName, int displayType, String AD_Language)
{
//TODO //jz need more work later
if (FieldType.isDate(displayType))
{
return " Time2Chars("+columnName+") ";
}
// number
else if (FieldType.isNumeric(displayType))
{
return " getChars("+columnName+") ";
}
// String
return "";
} // TO_CHAR
/**
* Get a string representation of literal used in SQL clause
*
* @param sqlClause "S", "U","I", "W"
* @param dataType java.sql.Types
*
* @return db2: nullif(x,x)
*/
public static String nullValue (String sqlClause, int dataType)
{
if (sqlClause=="I")
{
switch (dataType)
{
case Types.INTEGER:
return "nullif(0,0)";
case Types.DECIMAL:
return "nullif(0.1,0.1)";
case Types.TIMESTAMP:
return "nullif(Timestamp('20061012000000'),Timestamp('20061012000000'))";
case Types.VARCHAR:
return "nullif('a','a')";
default:
return "''";
}
}
else
return "''";
} // nullValue
/**
* Return number as string for INSERT statements with correct precision
* @param number number
* @param displayType display Type
* @return number as string
*/
public static String TO_NUMBER (BigDecimal number, int displayType)
{
if (number == null)
return "NULL";
BigDecimal result = number;
int scale = FieldType.getDefaultPrecision(displayType);
if (number.scale() > scale)
{
try
{
result = number.setScale(scale, BigDecimal.ROUND_HALF_UP);
}
catch (Exception e)
{
log.severe("Number=" + number + ", Scale=" + " - " + e.getMessage());
}
}
return result.toString();
} // TO_NUMBER
/**
*
* jz: NOT a generic one
*
* change WHERE (...) IN/NOT IN (select ... from ) to one column at a time
* Warning: This may not translate an equivalent sql
*
* @param sql update clause
*
* @return new sql
*/
public static String whereSelectList (String sql)
{
String s = whereSelectList1(sql, "IN");
s = whereSelectList1(s,"NOT IN");
return s;
}
private static String whereSelectList1 (String sql, String notIn)
{
String keyword = null;
if (notIn.equals("IN"))
keyword = ") IN (";
else
keyword = ") NOT IN (";
int ixIn = sql.indexOf(keyword+"SELECT");
if (ixIn==-1)
return sql;
StringBuffer newSQL = new StringBuffer();
int copyBegin = 0;
int isql = sql.length();
while (ixIn > -1)
{
int iColEnd = ixIn;
int iCol = iColEnd-1;
int iSelect = ixIn+keyword.length();
int il = 1;
int ir = 0;
iSelect += 6;
int iFrom = sql.indexOf(" FROM ", iSelect);
//get column list beginning
ir = 1;
il = 0;
while (il < ir && --iCol >= 0)
{
if (sql.charAt(iCol)==')')
ir++;
else if (sql.charAt(iCol)=='(')
il++;
}
//copy first part
if (copyBegin < iCol)
newSQL = newSQL.append(sql.substring(copyBegin,iCol));
String[] colList = sql.substring(iCol+1,iColEnd).split(",");
String[] tableNames = sql.substring(iFrom,isql).split(" ");
String[] selectList = sql.substring(iSelect,iFrom).split(",");
StringBuffer colList1 = new StringBuffer();
StringBuffer selectList1 = new StringBuffer();
MTable mt = MTable.get(Env.getCtx(), tableNames[2].trim());
for (int i=0; i<colList.length; i++)
{
if (i>0)
{
colList1.append(" || ");
selectList1.append(" || ");
}
colList[i]=colList[i].trim();
selectList[i]=selectList[i].trim();
MColumn mc = mt.getColumn(colList[i]);
if (mc==null)
{
log.severe("Wrong column:" + colList[i] + ": in sql: " + sql);
return sql;
}
int dt = mt.getColumn(colList[i]).getAD_Reference_ID(); //getElement().getDisplayType();
colList1.append(DB.TO_CHAR(colList[i], dt, Env.getAD_Language(Env.getCtx())));
selectList1.append(DB.TO_CHAR(selectList[i], dt, Env.getAD_Language(Env.getCtx())));
}//for
newSQL.append(" " + colList1 + keyword.substring(1) + "SELECT " +selectList1);
copyBegin = iFrom;
ixIn = sql.indexOf(keyword+"SELECT", copyBegin);
}//while
if (copyBegin <isql)
newSQL.append(sql.substring(copyBegin, isql));
return newSQL.toString();
} //
/**
*
* jz NOT a generic one
*
* change update set (...) = (select ... from ) standard format
*
* @param sql update clause
*
* @return new sql
*/
public static String updateSetSelectList (String sql)
{
StringBuffer newSQL = null;
int iSet = sql.indexOf(" SET (");
int iSetEnd = sql.indexOf(")",iSet);
int iSelect = sql.indexOf("(SELECT ",iSetEnd);
int iSelectEnd = sql.indexOf(" FROM ",iSelect);
int il = 1;
int ir = 0;
int isql = sql.length();
if (iSet == -1 || iSetEnd == -1 || iSelect == -1 || iSelectEnd == -1)
return sql;
//get lists
String[] setList = sql.substring(iSet+6,iSetEnd).split(",");
String[] selectList = null;
String selListStr = sql.substring(iSelect+7,iSelectEnd);
//if (selListStr.indexOf("), ")>0)
if (selListStr.indexOf(")")>0)
selectList = selListStr.split(", ");
else
selectList = selListStr.split(",");
//get subQuery end
int end = iSelectEnd+5;
while (il > ir && ++end < isql)
{
if (sql.charAt(end)==')')
ir++;
else if (sql.charAt(end)=='(')
il++;
}
if (end < isql)
end++;
//construct new sql
newSQL = new StringBuffer(sql.substring(0,iSet+5));
for (int i=0; i<setList.length; i++)
{
if (i>0)
newSQL.append(" , ");
newSQL.append(setList[i]+" = (SELECT "+selectList[i]+" "+sql.substring(iSelectEnd, end));
}
if (end <=isql)
newSQL.append(sql.substring(end, isql));
return newSQL.toString();
} //
/**
* @param args
*/
public static void main(String[] args)
{
String s = updateSetSelectList("UPDATE T_Report SET Col_0 = (SELECT COALESCE(SUM(Col_0),0) FROM T_Report WHERE AD_PInstance_ID=1000014 AND PA_ReportLine_ID IN (0,0) AND ABS(LevelNo)<1) WHERE AD_PInstance_ID=1000014 AND PA_ReportLine_ID=100 AND ABS(LevelNo)<1");
System.out.println(s);
Compiere.startup(true);
s = whereSelectList("DELETE FROM C_PeriodControl WHERE (C_Period_ID, DocBaseType) IN (SELECT C_Period_ID, DocBaseType FROM C_PeriodControl pc2 GROUP BY C_Period_ID, DocBaseType HAVING COUNT(*) > 1) AND C_PeriodControl_ID NOT IN (SELECT MIN(C_PeriodControl_ID) FROM C_PeriodControl pc3 GROUP BY C_Period_ID, DocBaseType)");
System.out.println(s);
s = whereSelectList("DELETE FROM C_PeriodControl WHERE (C_Period_ID, DocBaseType) NOT IN (SELECT C_Period_ID, DocBaseType FROM C_PeriodControl pc2 GROUP BY C_Period_ID, DocBaseType HAVING COUNT(*) > 1) AND C_PeriodControl_ID NOT IN (SELECT MIN(C_PeriodControl_ID) FROM C_PeriodControl pc3 GROUP BY C_Period_ID, DocBaseType)");
System.out.println(s);
} // main()
} // DBUtils
The table below shows all metrics for DBUtils.java.
| Metric | Value | Description | |
|---|---|---|---|
| BLOCKS | 28.00 | Number of blocks | |
| BLOCK_COMMENT | 28.00 | Number of block comment lines | |
| COMMENTS | 145.00 | Comment lines | |
| COMMENT_DENSITY | 0.67 | Comment density | |
| COMPARISONS | 51.00 | Number of comparison operators | |
| CYCLOMATIC | 62.00 | Cyclomatic complexity | |
| DECL_COMMENTS | 13.00 | Comments in declarations | |
| DOC_COMMENT | 98.00 | Number of javadoc comment lines | |
| ELOC | 217.00 | Effective lines of code | |
| EXEC_COMMENTS | 18.00 | Comments in executable code | |
| EXITS | 39.00 | Procedure exits | |
| FUNCTIONS | 10.00 | Number of function declarations | |
| HALSTEAD_DIFFICULTY | 83.54 | Halstead difficulty | |
| HALSTEAD_EFFORT | 0.00 | Halstead effort | |
| INTERFACE_COMPLEXITY | 42.00 | Interface complexity | |
| JAVA0001 | 0.00 | JAVA0001 Package name does not contain only lower case letters | |
| JAVA0002 | 0.00 | JAVA0002 Package name does not begin with a top level domain name or country code | |
| JAVA0003 | 1.00 | JAVA0003 Minimize use of on-demand (.*) imports | |
| JAVA0004 | 0.00 | JAVA0004 Unnecessary import from java.lang | |
| JAVA0005 | 0.00 | JAVA0005 Imports not in specified order | |
| JAVA0006 | 0.00 | JAVA0006 Empty finally block | |
| JAVA0007 | 0.00 | JAVA0007 Should not declare public field | |
| JAVA0008 | 0.00 | JAVA0008 Empty catch block | |
| JAVA0009 | 0.00 | JAVA0009 Protected member in final class | |
| JAVA0010 | 0.00 | JAVA0010 Non-instantiable class does not contain a non-private static member | |
| JAVA0011 | 0.00 | JAVA0011 Abstract class does not contain an abstract method | |
| JAVA0012 | 0.00 | JAVA0012 Non-constructor method with same name as declaring class | |
| JAVA0013 | 0.00 | JAVA0013 Non-blank final field is not static | |
| JAVA0014 | 1.00 | JAVA0014 Class with only static members has non-private constructor | |
| JAVA0015 | 0.00 | JAVA0015 Package class contains public nested type | |
| JAVA0016 | 0.00 | JAVA0016 Abstract class contains public constructor | |
| JAVA0017 | 0.00 | JAVA0017 Class name does not have required form | |
| JAVA0018 | 0.00 | JAVA0018 Method name does not have required form | |
| JAVA0019 | 0.00 | JAVA0019 Interface name does not have required form | |
| JAVA0020 | 0.00 | JAVA0020 Field name does not have required form | |
| JAVA0021 | 0.00 | JAVA0021 Interface method name does not have required form | |
| JAVA0022 | 0.00 | JAVA0022 Static final field name does not have required form | |
| JAVA0023 | 0.00 | JAVA0023 Empty finalize method | |
| JAVA0024 | 0.00 | JAVA0024 Empty class | |
| JAVA0025 | 0.00 | JAVA0025 Method override is empty | |
| JAVA0026 | 0.00 | JAVA0026 Finalize method with parameters | |
| JAVA0029 | 0.00 | JAVA0029 Private method not used | |
| JAVA0030 | 0.00 | JAVA0030 Private field not used | |
| JAVA0031 | 0.00 | JAVA0031 Case statement not properly closed | |
| JAVA0032 | 0.00 | JAVA0032 Switch statement missing default | |
| JAVA0033 | 0.00 | JAVA0033 default: not last case in switch statement | |
| JAVA0034 | 26.00 | JAVA0034 Missing braces in if statement | |
| JAVA0035 | 0.00 | JAVA0035 Missing braces in for statement | |
| JAVA0036 | 0.00 | JAVA0036 Missing braces in while statement | |
| JAVA0038 | 0.00 | JAVA0038 Non-case label in switch statement | |
| JAVA0039 | 0.00 | JAVA0039 Break statement with label | |
| JAVA0040 | 0.00 | JAVA0040 Switch statement contains N cases (maximum: M) | |
| JAVA0041 | 0.00 | JAVA0041 Nested synchronized block | |
| JAVA0042 | 0.00 | JAVA0042 Empty synchronized statement | |
| JAVA0043 | 0.00 | JAVA0043 Inner class does not use outer class | |
| JAVA0044 | 0.00 | JAVA0044 Serializable class with no instance variables | |
| JAVA0045 | 0.00 | JAVA0045 Serializable class with only transient fields | |
| JAVA0046 | 0.00 | JAVA0046 Name of class not derived from Exception ends with 'Exception' | |
| JAVA0047 | 0.00 | JAVA0047 Serializable class derives from invalid base class | |
| JAVA0048 | 0.00 | JAVA0048 Name of class derived from Exception does not end with 'Exception' | |
| JAVA0049 | 0.00 | JAVA0049 Nested block at depth N (maximum: M) | |
| JAVA0050 | 0.00 | JAVA0050 Class derives from java.lang.Error | |
| JAVA0051 | 0.00 | JAVA0051 Class derives from java.lang.RuntimeException | |
| JAVA0052 | 0.00 | JAVA0052 Class derives from java.lang.Throwable | |
| JAVA0053 | 0.00 | JAVA0053 Unused label | |
| JAVA0054 | 0.00 | JAVA0054 Inheritance depth N exceeds maximum M | |
| JAVA0055 | 0.00 | JAVA0055 Class should be interface | |
| JAVA0056 | 0.00 | JAVA0056 Unnecessary abstract modifier for interface or annotation | |
| JAVA0057 | 0.00 | JAVA0057 Unnecessary default constructor | |
| JAVA0058 | 0.00 | JAVA0058 Constructor calls super() | |
| JAVA0059 | 0.00 | JAVA0059 Method override only calls super() | |
| JAVA0061 | 0.00 | JAVA0061 Inaccessible member in anonymous class | |
| JAVA0062 | 0.00 | JAVA0062 Public class missing public member or protected constructor | |
| JAVA0063 | 0.00 | JAVA0063 Identifier name should not contain '$' | |
| JAVA0064 | 0.00 | JAVA0064 N variations of identifier name (maximum: M) | |
| JAVA0065 | 0.00 | JAVA0065 Unnecessary final modifier for method in final class | |
| JAVA0066 | 0.00 | JAVA0066 Unnecessary modifier for interface nested type | |
| JAVA0067 | 0.00 | JAVA0067 Array descriptor on identifier name | |
| JAVA0068 | 0.00 | JAVA0068 Modifiers not declared in recommended order | |
| JAVA0071 | 1.00 | JAVA0071 Strings compared with == | |
| JAVA0073 | 0.00 | JAVA0073 Integer division in floating-point context | |
| JAVA0074 | 0.00 | JAVA0074 Use of Object.notify() | |
| JAVA0075 | 0.00 | JAVA0075 Method parameter hides field | |
| JAVA0076 | 2.00 | JAVA0076 Use of magic number | |
| JAVA0077 | 0.00 | JAVA0077 Private field not used in declaring class | |
| JAVA0078 | 0.00 | JAVA0078 Floating point values compared with == | |
| JAVA0079 | 0.00 | JAVA0079 Use of instance to reference static member | |
| JAVA0080 | 0.00 | JAVA0080 Import declaration not used | |
| JAVA0081 | 0.00 | JAVA0081 Boolean literal in comparison | |
| JAVA0082 | 0.00 | JAVA0082 Unnecessary widening cast | |
| JAVA0083 | 0.00 | JAVA0083 Unnecessary instanceof test | |
| JAVA0084 | 0.00 | JAVA0084 Should use compound assignment operator | |
| JAVA0085 | 0.00 | JAVA0085 Use of sun.* class | |
| JAVA0087 | 0.00 | JAVA0087 Use of Thread.sleep() | |
| JAVA0089 | 0.00 | JAVA0089 Use of restricted package | |
| JAVA0092 | 0.00 | JAVA0092 Use of restricted type | |
| JAVA0093 | 0.00 | JAVA0093 Redundant assignment | |
| JAVA0094 | 0.00 | JAVA0094 Field hides a superclass field | |
| JAVA0095 | 0.00 | JAVA0095 Uninitialized private field | |
| JAVA0096 | 0.00 | JAVA0096 Field in nested class hides outer field | |
| JAVA0098 | 0.00 | JAVA0098 Minimize use of implicit field initializers | |
| JAVA0100 | 0.00 | JAVA0100 Class contains N non-final fields (maximum: M) | |
| JAVA0101 | 0.00 | JAVA0101 Unnecessary modifier for field in interface | |
| JAVA0102 | 0.00 | JAVA0102 Last statement in finalize() not super.finalize() | |
| JAVA0103 | 0.00 | JAVA0103 Explicit call to finalize() | |
| JAVA0104 | 0.00 | JAVA0104 finalize() only calls super.finalize() | |
| JAVA0105 | 0.00 | JAVA0105 Duplicate import declaration | |
| JAVA0106 | 0.00 | JAVA0106 Unnecessary import from current package | |
| JAVA0108 | 0.00 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0109 | 0.00 | JAVA0109 Incorrect javadoc: no parameter 'parameter' | |
| JAVA0110 | 0.00 | JAVA0110 Incorrect javadoc: no @return tag | |
| JAVA0111 | 0.00 | JAVA0111 Incorrect javadoc: @return tag for void method | |
| JAVA0112 | 0.00 | JAVA0112 Incorrect javadoc: no exception 'exception' in throws | |
| JAVA0113 | 0.00 | JAVA0113 Incorrect javadoc: no @author tag | |
| JAVA0114 | 0.00 | JAVA0114 Incorrect javadoc: no @version tag | |
| JAVA0115 | 0.00 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| JAVA0116 | 0.00 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0117 | 0.00 | JAVA0117 Missing javadoc: method 'method' | |
| JAVA0118 | 0.00 | JAVA0118 Missing javadoc: type 'type' | |
| JAVA0119 | 0.00 | JAVA0119 Control variable changed within body of for loop | |
| JAVA0123 | 0.00 | JAVA0123 Use all three components of for loop | |
| JAVA0125 | 0.00 | JAVA0125 Continue statement with label | |
| JAVA0126 | 0.00 | JAVA0126 Method declares unchecked exception in throws | |
| JAVA0128 | 0.00 | JAVA0128 Public constructor in non-public class | |
| JAVA0130 | 0.00 | JAVA0130 Non-static method does not use instance fields | |
| JAVA0131 | 0.00 | JAVA0131 Compatible method does not override base | |
| JAVA0132 | 0.00 | JAVA0132 Method overload with compatible signature | |
| JAVA0133 | 0.00 | JAVA0133 Non-synchronized method overrides synchronized method | |
| JAVA0135 | 0.00 | JAVA0135 Only one of Object.equals and Object.hashCode defined: missing 'method' | |
| JAVA0136 | 0.00 | JAVA0136 N methods defined in class (maximum: M) | |
| JAVA0137 | 0.00 | JAVA0137 Non-abstract class missing constructor | |
| JAVA0138 | 0.00 | JAVA0138 N parameters defined for method (maximum: M) | |
| JAVA0139 | 0.00 | JAVA0139 Definition of main other than public static void main(java.lang.String[]) | |
| JAVA0141 | 0.00 | JAVA0141 Unnecessary modifier for method in interface | |
| JAVA0143 | 0.00 | JAVA0143 Synchronized method | |
| JAVA0144 | 4.00 | JAVA0144 Line exceeds maximum M characters | |
| JAVA0145 | 973.00 | JAVA0145 Tab character used in source file | |
| JAVA0150 | 0.00 | JAVA0150 java.lang.Error (or subclass) thrown | |
| JAVA0153 | 0.00 | JAVA0153 Inefficient conversion of integer to string | |
| JAVA0159 | 0.00 | JAVA0159 Inefficient conversion of string to integer | |
| JAVA0160 | 0.00 | JAVA0160 Method does not throw specified exception | |
| JAVA0161 | 0.00 | JAVA0161 Conditional wait() not in loop | |
| JAVA0163 | 1.00 | JAVA0163 Empty statement | |
| JAVA0165 | 0.00 | JAVA0165 Conflicting return statement in finally block | |
| JAVA0166 | 1.00 | JAVA0166 Generic exception caught | |
| JAVA0167 | 0.00 | JAVA0167 ThreadDeath not rethrown | |
| JAVA0169 | 0.00 | JAVA0169 Unnecessary catch block: exception 'exception' | |
| JAVA0170 | 0.00 | JAVA0170 Caught exception not derived from java.lang.Exception | |
| JAVA0171 | 0.00 | JAVA0171 Unused local variable | |
| JAVA0173 | 1.00 | JAVA0173 Unused method parameter | |
| JAVA0174 | 0.00 | JAVA0174 Assigned local variable never used | |
| JAVA0175 | 0.00 | JAVA0175 Successive assignment to variable | |
| JAVA0176 | 0.00 | JAVA0176 Local variable name does not have required form | |
| JAVA0177 | 0.00 | JAVA0177 Variable declaration missing initializer | |
| JAVA0179 | 0.00 | JAVA0179 Local variable hides visible field | |
| JAVA0233 | 0.00 | JAVA0233 Definition of serialVersionUID other than 'private static final long serialVersionUID' | |
| JAVA0234 | 0.00 | JAVA0234 Class is Serializable but does not define serialVersionUID | |
| JAVA0235 | 0.00 | JAVA0235 Class defines serialVersionUID but does not implement Serializable | |
| JAVA0236 | 0.00 | JAVA0236 Attempt to clone an object which does not implement Cloneable | |
| JAVA0237 | 0.00 | JAVA0237 Class implements Cloneable but does not have public clone method | |
| JAVA0238 | 0.00 | JAVA0238 Clone method does not call super.clone() | |
| JAVA0239 | 0.00 | JAVA0239 Class declares 'readObject' or 'writeObject' but does not implement Serializable | |
| JAVA0240 | 0.00 | JAVA0240 Serializable class which declares readObject or writeObject but not both | |
| JAVA0241 | 0.00 | JAVA0241 'readObject' or 'writeObject' should be declared private in Serializable class | |
| JAVA0242 | 0.00 | JAVA0242 Transient field in non-Serializable class | |
| JAVA0243 | 0.00 | JAVA0243 'readResolve' or 'writeReplace' should be declared private or protected | |
| JAVA0244 | 0.00 | JAVA0244 Field or method name in subclass differs only by case from inherited field or method | |
| JAVA0245 | 0.00 | JAVA0245 JUnit TestCase with non-trivial constructor | |
| JAVA0246 | 0.00 | JAVA0246 JUnit assertXXX statement missing message parameter | |
| JAVA0247 | 0.00 | JAVA0247 JUnit 'setUp()' and 'tearDown()' should call super method | |
| JAVA0248 | 0.00 | JAVA0248 JUnit method 'setUp' or 'tearDown' with incorrect signature | |
| JAVA0249 | 0.00 | JAVA0249 JUnit TestCase 'suite()' should be declared static | |
| JAVA0250 | 0.00 | JAVA0250 JUnit TestCase declares testXXX method with incorrect signature | |
| JAVA0251 | 0.00 | JAVA0251 Use '%n' for line breaks in printf/format for platform independence | |
| JAVA0252 | 0.00 | JAVA0252 'enum' is a Java 1.5 reserved word | |
| JAVA0253 | 0.00 | JAVA0253 Not all enum constants consumed in switch statement | |
| JAVA0254 | 0.00 | JAVA0254 Use enhanced for loop construct instead of Iterator | |
| JAVA0255 | 0.00 | JAVA0255 Result of method invocation not used | |
| JAVA0256 | 0.00 | JAVA0256 Assignment of external collection/array to field | |
| JAVA0257 | 0.00 | JAVA0257 Use of 'Constant Interface' anti-pattern | |
| JAVA0258 | 0.00 | JAVA0258 Implement Iterable for foreach compatibility | |
| JAVA0259 | 0.00 | JAVA0259 Return of collection/array field | |
| JAVA0260 | 0.00 | JAVA0260 Use 'enum' instead of Enumerated Type pattern | |
| JAVA0261 | 0.00 | JAVA0261 Use specialized Enum collection types | |
| JAVA0262 | 0.00 | JAVA0262 Use of char in integer context | |
| JAVA0263 | 0.00 | JAVA0263 Long literal ends with 'l' instead of 'L' | |
| JAVA0264 | 0.00 | JAVA0264 Integer math in long context - check for overflow | |
| JAVA0265 | 0.00 | JAVA0265 Use of Throwable.printStackTrace() | |
| JAVA0266 | 3.00 | JAVA0266 Use of System.out | |
| JAVA0267 | 0.00 | JAVA0267 Use of System.err | |
| JAVA0269 | 0.00 | JAVA0269 Contents of StringBuffer never used | |
| JAVA0270 | 0.00 | JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array | |
| JAVA0271 | 0.00 | JAVA0271 Minimize use of on-demand (.*) static imports | |
| JAVA0272 | 0.00 | JAVA0272 Thread.run() called | |
| JAVA0273 | 0.00 | JAVA0273 Non-final derivative of Thread calls start() in constructor | |
| JAVA0274 | 0.00 | JAVA0274 Serializable class has a synchronized readObject() | |
| JAVA0275 | 0.00 | JAVA0275 Serializable class has a synchronized writeObject() and no other synchronized methods | |
| JAVA0276 | 0.00 | JAVA0276 Unnecessary use of String constructor | |
| JAVA0277 | 0.00 | JAVA0277 Iterator.next() implementation does not throw NoSuchElementException | |
| JAVA0278 | 0.00 | JAVA0278 Unnecessary use of Boolean constructor | |
| JAVA0279 | 0.00 | JAVA0279 Serialization method readObject or readObjectNoData calls an overridable method | |
| JAVA0280 | 0.00 | JAVA0280 IllegalMonitorStateException caught | |
| JAVA0281 | 0.00 | JAVA0281 Iterator.next() not called in loop | |
| JAVA0282 | 0.00 | JAVA0282 Call to Iterator.next() in loop which does not test Iterator.hasNext() | |
| JAVA0283 | 0.00 | JAVA0283 Control variable not updated in loop body | |
| JAVA0284 | 0.00 | JAVA0284 Explicit garbage collection | |
| JAVA0285 | 0.00 | JAVA0285 Dereference of potentially null variable | |
| JAVA0286 | 0.00 | JAVA0286 Dereference of null variable | |
| JAVA0287 | 0.00 | JAVA0287 Unnecessary null check | |
| JAVA0288 | 0.00 | JAVA0288 Inconsistent null check | |
| LINES | 479.00 | Number of lines in the source file | |
| LINE_COMMENT | 19.00 | Number of line comments | |
| LOC | 266.00 | Lines of code | |
| LOGICAL_LINES | 140.00 | Number of statements | |
| LOOPS | 6.00 | Number of loops | |
| NEST_DEPTH | 4.00 | Maximum nesting depth | |
| OPERANDS | 724.00 | Number of operands | |
| OPERATORS | 1180.00 | Number of operators | |
| PARAMS | 16.00 | Number of formal parameter declarations | |
| PROGRAM_LENGTH | 1904.00 | Halstead program length | |
| PROGRAM_VOCAB | 256.00 | Halstead program vocabulary | |
| PROGRAM_VOLUME | 0.00 | Halstead program volume | |
| RETURNS | 26.00 | Number of return points from functions | |
| SIZE | 13581.00 | Size of the file in bytes | |
| UNIQUE_OPERANDS | 208.00 | Number of unique operands | |
| UNIQUE_OPERATORS | 48.00 | Number of unique operators | |
| WHITESPACE | 68.00 | Number of whitespace lines | |