Library.java
| Index Score | ||
|---|---|---|
 |
 |
org.hsqldb |
 |
|
HSQL Database Engine |
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 | |
|---|---|---|
| DECL_COMMENTS | Comments in declarations |  |
| DOC_COMMENT | Number of javadoc comment lines | |
| SIZE | Size of the file in bytes | |
| COMMENTS | Comment lines | |
| CYCLOMATIC | Cyclomatic complexity | |
| LINES | Number of lines in the source file | |
| RETURNS | Number of return points from functions | |
| COMPARISONS | Number of comparison operators | |
| INTERFACE_COMPLEXITY | Interface complexity | |
| BLOCKS | Number of blocks | |
| OPERATORS | Number of operators | |
| ELOC | Effective lines of code | |
| PROGRAM_LENGTH | Halstead program length | |
| LOC | Lines of code | |
| LINE_COMMENT | Number of line comments | |
| UNIQUE_OPERANDS | Number of unique operands | |
| OPERANDS | Number of operands | |
| LOGICAL_LINES | Number of statements | |
| PROGRAM_VOCAB | Halstead program vocabulary | |
| PARAMS | Number of formal parameter declarations | |
| EXITS | Procedure exits | |
| FUNCTIONS | Number of function declarations | |
| LOOPS | Number of loops | |
| WHITESPACE | Number of whitespace lines | |
| JAVA0173 | JAVA0173 Unused method parameter | |
| JAVA0076 | JAVA0076 Use of magic number | |
| JAVA0034 | JAVA0034 Missing braces in if statement | |
| UNIQUE_OPERATORS | Number of unique operators | |
| JAVA0119 | JAVA0119 Control variable changed within body of for loop | |
| JAVA0177 | JAVA0177 Variable declaration missing initializer | |
| JAVA0108 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0264 | JAVA0264 Integer math in long context - check for overflow | |
| JAVA0179 | JAVA0179 Local variable hides visible field | |
| JAVA0040 | JAVA0040 Switch statement contains N cases (maximum: M) | |
| JAVA0270 | JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array | |
| JAVA0116 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0110 | JAVA0110 Incorrect javadoc: no @return tag | |
| JAVA0117 | JAVA0117 Missing javadoc: method 'method' | |
| PROGRAM_VOLUME | Halstead program volume | |
| JAVA0136 | JAVA0136 N methods defined in class (maximum: M) | |
| JAVA0160 | JAVA0160 Method does not throw specified exception | |
| BLOCK_COMMENT | Number of block comment lines | |
| JAVA0126 | JAVA0126 Method declares unchecked exception in throws | |
| JAVA0123 | JAVA0123 Use all three components of for loop | |
| JAVA0145 | JAVA0145 Tab character used in source file | |
/* Copyright (c) 1995-2000, The Hypersonic SQL Group.
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the Hypersonic SQL Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL THE HYPERSONIC SQL GROUP,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
* This software consists of voluntary contributions made by many individuals
* on behalf of the Hypersonic SQL Group.
*
*
* For work added by the HSQL Development Group:
*
* Copyright (c) 2001-2007, The HSQL Development Group
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the HSQL Development Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
package org.hsqldb;
import java.sql.Connection;
import java.sql.Date;
import java.sql.Timestamp;
import java.text.FieldPosition;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Locale;
import java.util.Random;
import org.hsqldb.lib.HashMap;
import org.hsqldb.lib.IntValueHashMap;
import org.hsqldb.persist.HsqlDatabaseProperties;
import org.hsqldb.store.ValuePool;
import org.hsqldb.types.TimeData;
// fredt@users 20020210 - patch 513005 by sqlbob@users (RMP) - ABS function
// fredt@users 20020305 - patch 1.7.0 - change to 2D string arrays
// sqlbob@users 20020420- patch 1.7.0 - added HEXTORAW and RAWTOHEX.
// boucherb@user 20020918 - doc 1.7.2 - added JavaDoc and code comments
// fredt@user 20021021 - doc 1.7.2 - modified JavaDoc
// boucherb@users 20030201 - patch 1.7.2 - direct calls for org.hsqldb.Library
// fredt@users - patch 1.8.0 - new functions added
// boucherb@users 20060428 - patch 1.8.0 - Bug fix for [ 1455637 ] allow double args for modulo
// fredt@users - patch 1.9.0 - several methods removed - see legacy support details
/**
* fredt - todo - since the introduction of SQL built-in functions and
* evaluation of several session-dependent methods outside this class,
* several methods here are dummies. These methods are still reported in
* system tables incorrectly as corresponding to the SQL function names.
*/
/**
* Provides the HSQLDB implementation of standard Open Group SQL CLI
* <em>Extended Scalar Functions</em> and other public HSQLDB SQL functions.<p>
*
* All methods here that have a Connection parameter are dummies and should
* not be called from user supplied Java procedure or trigger code. Use real
* SQL functions should be called instead in these instances.
*
* For 1.9.0, several methods have been deleted. These methods are now supported
* by other classes. All the deleted method signatures are still supported.
*
* Extensively rewritten and extended in successive versions of HSQLDB.
*
* @author Thomas Mueller (Hypersonic SQL Group)
* @version 1.8.0
* @since Hypersonic SQL
*/
public class Library {
static final SimpleDateFormat tocharFormat = new SimpleDateFormat();
static final SimpleDateFormat daynameFormat = new SimpleDateFormat("EEEE",
Locale.ENGLISH);
static final SimpleDateFormat monthnameFormat =
new SimpleDateFormat("MMMM", Locale.ENGLISH);
static final StringBuffer daynameBuffer = new StringBuffer();
static final StringBuffer monthnameBuffer = new StringBuffer();
static final FieldPosition monthPosition =
new FieldPosition(SimpleDateFormat.MONTH_FIELD);
static final FieldPosition dayPosition =
new FieldPosition(SimpleDateFormat.DAY_OF_WEEK_FIELD);
public static final String[][] sNumeric = {
{
"ACOS", "java.lang.Math.acos"
}, {
"ASIN", "java.lang.Math.asin"
}, {
"ATAN", "java.lang.Math.atan"
}, {
"ATAN2", "java.lang.Math.atan2"
}, {
"COS", "java.lang.Math.cos"
}, {
"COT", "org.hsqldb.Library.cot"
}, {
"DEGREES", "java.lang.Math.toDegrees"
}, {
"DMOD", "org.hsqldb.Library.dmod"
}, {
"LOG10", "org.hsqldb.Library.log10"
}, {
"PI", "org.hsqldb.Library.pi"
}, {
"POWER", "java.lang.Math.pow"
}, {
"RADIANS", "java.lang.Math.toRadians"
}, {
"RAND", "java.lang.Math.random"
}, {
"ROUND", "org.hsqldb.Library.round"
}, {
"SIGN", "org.hsqldb.Library.sign"
}, {
"SIN", "java.lang.Math.sin"
}, {
"SQRT", "java.lang.Math.sqrt"
}, {
"TAN", "java.lang.Math.tan"
}, {
"TRUNCATE", "org.hsqldb.Library.truncate"
}, {
"BITAND", "org.hsqldb.Library.bitand"
}, {
"BITOR", "org.hsqldb.Library.bitor"
}, {
"BITXOR", "org.hsqldb.Library.bitxor"
}, {
"ROUNDMAGIC", "org.hsqldb.Library.roundMagic"
}
};
// fredt@users 20010701 - patch 418023 by deforest@users
// the definition for SUBSTR was added
public static final String[][] sString = {
{
"ASCII", "org.hsqldb.Library.ascii"
}, {
"BIT_LENGTH", "org.hsqldb.Library.bitLength"
}, {
"CHAR", "org.hsqldb.Library.character"
}, {
"CONCAT", "org.hsqldb.Library.concat"
}, {
"DIFFERENCE", "org.hsqldb.Library.difference"
}, {
"HEXTORAW", "org.hsqldb.Library.hexToRaw"
}, {
"INSERT", "org.hsqldb.Library.insert"
}, {
"LCASE", "org.hsqldb.Library.lcase"
}, {
"LEFT", "org.hsqldb.Library.left"
}, {
"LENGTH", "org.hsqldb.Library.length"
}, {
"LOCATE", "org.hsqldb.Library.locate"
}, {
"LTRIM", "org.hsqldb.Library.ltrim"
}, {
"RAWTOHEX", "org.hsqldb.Library.rawToHex"
}, {
"REPEAT", "org.hsqldb.Library.repeat"
}, {
"REPLACE", "org.hsqldb.Library.replace"
}, {
"RIGHT", "org.hsqldb.Library.right"
}, {
"RTRIM", "org.hsqldb.Library.rtrim"
}, {
"SOUNDEX", "org.hsqldb.Library.soundex"
}, {
"SPACE", "org.hsqldb.Library.space"
}, {
"SUBSTR", "org.hsqldb.Library.substring"
}, {
"UCASE", "org.hsqldb.Library.ucase"
}
};
public static final String[][] sTimeDate = {
{
"CURDATE", "org.hsqldb.Library.curdate"
}, {
"CURTIME", "org.hsqldb.Library.curtime"
}, {
"DATEDIFF", "org.hsqldb.Library.datediff"
}, {
"DAYNAME", "org.hsqldb.Library.dayname"
}, {
"DAYOFMONTH", "org.hsqldb.Library.dayofmonth"
}, {
"DAYOFWEEK", "org.hsqldb.Library.dayofweek"
}, {
"DAYOFYEAR", "org.hsqldb.Library.dayofyear"
}, {
"MONTHNAME", "org.hsqldb.Library.monthname"
}, {
"QUARTER", "org.hsqldb.Library.quarter"
}, {
"WEEK", "org.hsqldb.Library.week"
}, {
"TO_CHAR", "org.hsqldb.Library.to_char"
}
};
public static final String[][] sSystem = {
{
"DATABASE", "org.hsqldb.Library.database"
}
};
private Library() {}
static HashMap getAliasMap() {
HashMap h = new HashMap(83, 1);
register(h, sNumeric);
register(h, sString);
register(h, sTimeDate);
register(h, sSystem);
return h;
}
private static void register(HashMap h, String[][] s) {
for (int i = 0; i < s.length; i++) {
h.put(s[i][0], s[i][1]);
}
}
private static final Random rRandom = new Random();
// NUMERIC FUNCTIONS
// fredt@users 20020220 - patch 489184 by xclayl@users - thread safety
/**
* Returns the next pseudorandom, uniformly distributed <code>double</code> value
* between 0.0 and 1.0 from a single, system-wide random number generator's
* sequence, optionally re-seeding (and thus resetting) the generator sequence.
*
* If the seed value is <code>null</code>, then the underlying random number
* generator retrieves the next value in its current sequence, else the seed
* alters the state of the generator object so as to be in exactly the same state
* as if it had just been created with the seed value.
* @param seed an optional parameter with which to reseed the underlying
* pseudorandom number generator
* @return the next pseudorandom, uniformly distributed <code>double</code> value between
* 0.0 and 1.0
*/
public static double rand(Integer seed) {
// boucherb@users 20020918
// CHECKME: perhaps rRandom should be a member of Session,
// since otherwise connections are *not* guranteed to get the
// same pseudorandom sequence, given the same set of calls to this
// SQL function. This makes comparitive analysis difficult.
// In fact, rRandom will be shared across multiple in-process
// database instances, so it is not even guaranteed that the
// sole connection to one instance will get the same sequence given
// the same set of calls to this SQL function.
synchronized (rRandom) {
if (seed != null) {
rRandom.setSeed(seed.intValue());
}
return rRandom.nextDouble();
}
}
// this magic number works for 100000000000000; but not for 0.1 and 0.01
private static final double LOG10_FACTOR = 0.43429448190325183;
/**
* Returns the base 10 logarithm of the given <code>double</code> value.
* @param x the value for which to calculate the base 10 logarithm
* @return the base 10 logarithm of <code>x</code>, as a <code>double</code>
*/
public static double log10(double x) {
return roundMagic(Math.log(x) * LOG10_FACTOR);
}
/**
* Retrieves a <em>magically</em> rounded </code>double</code> value produced
* from the given <code>double</code> value. This method provides special
* handling for numbers close to zero and performs rounding only for
* numbers within a specific range, returning precisely the given value
* if it does not lie in this range. <p>
*
* Special handling includes: <p>
*
* <UL>
* <LI> input in the interval -0.0000000000001..0.0000000000001 returns 0.0
* <LI> input outside the interval -1000000000000..1000000000000 returns
* input unchanged
* <LI> input is converted to String form
* <LI> input with a <code>String</code> form length greater than 16 returns
* input unchaged
* <LI> <code>String</code> form with last four characters of '...000x' where
* x != '.' is converted to '...0000'
* <LI> <code>String</code> form with last four characters of '...9999' is
* converted to '...999999'
* <LI> the <code>java.lang.Double.doubleValue</code> of the <code>String</code>
* form is returned
* </UL>
* @param d the double value for which to retrieve the <em>magically</em>
* rounded value
* @return the <em>magically</em> rounded value produced
*/
public static double roundMagic(double d) {
// this function rounds numbers in a good way but slow:
// - special handling for numbers around 0
// - only numbers <= +/-1000000000000
// - convert to a string
// - check the last 4 characters:
// '000x' becomes '0000'
// '999x' becomes '999999' (this is rounded automatically)
if ((d < 0.0000000000001) && (d > -0.0000000000001)) {
return 0.0;
}
if ((d > 1000000000000.) || (d < -1000000000000.)) {
return d;
}
StringBuffer s = new StringBuffer();
s.append(d);
int len = s.length();
if (len < 16) {
return d;
}
char cx = s.charAt(len - 1);
char c1 = s.charAt(len - 2);
char c2 = s.charAt(len - 3);
char c3 = s.charAt(len - 4);
if ((c1 == '0') && (c2 == '0') && (c3 == '0') && (cx != '.')) {
s.setCharAt(len - 1, '0');
} else if ((c1 == '9') && (c2 == '9') && (c3 == '9') && (cx != '.')) {
s.setCharAt(len - 1, '9');
s.append('9');
s.append('9');
}
return Double.valueOf(s.toString()).doubleValue();
}
/**
* Returns the cotangent of the given <code>double</code> value
* expressed in radians.
* @param d the angle, expressed in radians
* @return the cotangent
*/
public static double cot(double d) {
return 1. / Math.tan(d);
}
// Bug fix for [ 1455637 ] allow double args for modulo
// Most big-iron DBMS support MOD, incuding support for values with scale
// A search of SQL 3 (2006 edition) verifies our original implementation is
// standards-compliant:
//
// <modulus expression> operates on two exact numeric arguments with scale 0
// (zero) and returns the modulus (remainder) of the first argument divided by
// the second argument as an exact numeric with scale 0 (zero).
//
// However, it can be quite useful to calculate modulus for numbers having scale
// greater than zero:
/**
* Returns the remainder (modulus) of the first given double divided
* by the second. <p>
*
* @param d1 the numerator
* @param d2 the divisor
* @return <code>d1</code> % <code>d2</code>, as a <code>double</code>
*/
public static double dmod(double d1, double d2) {
return d1 % d2;
}
/**
* Returns the constant value, pi.
* @return pi as a <code>double</code> value
*/
public static double pi() {
return Math.PI;
}
/**
* Returns the given <code>double</code> value, rounded to the given
* <code>int</code> places right of the decimal point. If
* the supplied rounding place value is negative, rounding is performed
* to the left of the decimal point, using its magnitude (absolute value).
* @param d the value to be rounded
* @param p the rounding place value
* @return <code>d</code> rounded
*/
public static double round(double d, int p) {
double f = Math.pow(10., p);
return Math.round(d * f) / f;
}
/**
* Returns an indicator of the sign of the given <code>double</code>
* value. If the value is less than zero, -1 is returned. If the value
* equals zero, 0 is returned. If the value is greater than zero, 1 is
* returned.
* @param d the value
* @return the sign of <code>d</code>
*/
public static int sign(double d) {
return (d < 0) ? -1
: ((d > 0) ? 1
: 0);
}
/**
* Returns the given <code>double</code> value, truncated to
* the given <code>int</code> places right of the decimal point.
* If the given place value is negative, the given <code>double</code>
* value is truncated to the left of the decimal point, using the
* magnitude (aboslute value) of the place value.
* @param d the value to truncate
* @param p the places left or right of the decimal point at which to
* truncate
* @return <code>d</code>, truncated
*/
public static double truncate(double d, int p) {
double f = Math.pow(10., p);
double g = d * f;
return ((d < 0) ? Math.ceil(g)
: Math.floor(g)) / f;
}
/**
* Returns the bit-wise logical <em>and</em> of the given
* integer values.
* @param i the first value
* @param j the second value
* @return the bit-wise logical <em>and</em> of
* <code>i</code> and <code>j</code>
*/
public static int bitand(int i, int j) {
return i & j;
}
/**
* Returns the bit-wise logical <em>or</em> of the given
* integer values.
*
* @param i the first value
* @param j the second value
* @return the bit-wise logical <em>or</em> of
* <code>i</code> and <code>j</code>
*/
public static int bitor(int i, int j) {
return i | j;
}
/**
* Returns the bit-wise logical <em>xor</em> of the given
* integer values.
*
* @param i the first value
* @param j the second value
* @return the bit-wise logical <em>xor</em> of
* <code>i</code> and <code>j</code>
*
* @since 1.8.0
*/
public static int bitxor(int i, int j) {
return i ^ j;
}
// STRING FUNCTIONS
/**
* Returns the Unicode code value of the leftmost character of
* <code>s</code> as an <code>int</code>. This is the same as the
* ASCII value if the string contains only ASCII characters.
* @param s the <code>String</code> to evaluate
* @return the integer Unicode value of the
* leftmost character
*/
public static Integer ascii(String s) {
if ((s == null) || (s.length() == 0)) {
return null;
}
return ValuePool.getInt(s.charAt(0));
}
/**
* Returns the character string corresponding to the given ASCII
* (or Unicode) value.
*
* <b>Note:</b> <p>
*
* In some SQL CLI
* implementations, a <code>null</code> is returned if the range is outside 0..255.
* In HSQLDB, the corresponding Unicode character is returned
* unchecked.
* @param code the character code for which to return a String
* representation
* @return the String representation of the character
*/
public static String character(int code) {
return String.valueOf((char) code);
}
/**
* Returns a <code>String</code> object that is the result of an
* concatenation of the given <code>String</code> objects. <p>
*
* <b>When only one string is NULL, the result is different from that
* returned by an (string1 || string2) expression:
*
* <UL>
* <LI> if both <code>String</code> objects are <code>null</code>, return
* <code>null</code>
* <LI> if only one string is <code>null</code>, return the other
* <LI> if both <code>String</code> objects are non-null, return as a
* <code>String</code> object the character sequence obtained by listing,
* in left to right order, the characters of the first string followed by
* the characters of the second
* </UL>
* @param s1 the first <code>String</code>
* @param s2 the second <code>String</code>
* @return <code>s1</code> concatentated with <code>s2</code>
*/
public static String concat(String s1, String s2) {
if (s1 == null) {
if (s2 == null) {
return null;
}
return s2;
}
if (s2 == null) {
return s1;
}
return s1.concat(s2);
}
/**
* Returns a count of the characters that do not match when comparing
* the 4 digit numeric SOUNDEX character sequences for the
* given <code>String</code> objects. If either <code>String</code> object is
* <code>null</code>, zero is returned.
* @param s1 the first <code>String</code>
* @param s2 the second <code>String</code>
* @return the number of differences between the <code>SOUNDEX</code> of
* <code>s1</code> and the <code>SOUNDEX</code> of <code>s2</code>
*/
// fredt@users 20020305 - patch 460907 by fredt - soundex
public static int difference(String s1, String s2) {
// todo: check if this is the standard algorithm
if ((s1 == null) || (s2 == null)) {
return 0;
}
s1 = soundex(s1);
s2 = soundex(s2);
int e = 0;
for (int i = 0; i < 4; i++) {
if (s1.charAt(i) != s2.charAt(i)) {
e++;
}
}
return e;
}
/**
* Converts a <code>String</code> of hexidecimal digit characters to a raw
* binary value, represented as a <code>String</code>.<p>
*
* The given <code>String</code> object must consist of a sequence of
* 4 digit hexidecimal character substrings.<p> If its length is not
* evenly divisible by 4, <code>null</code> is returned. If any of
* its 4 character subsequences cannot be parsed as a
* 4 digit, base 16 value, then a NumberFormatException is thrown.
*
* This conversion has the effect of reducing the character count 4:1.
*
* @param s a <code>String</code> of hexidecimal digit characters
* @return an equivalent raw binary value, represented as a
* <code>String</code>
*/
public static String hexToRaw(String s) {
if (s == null) {
return null;
}
char raw;
StringBuffer to = new StringBuffer();
int len = s.length();
if (len % 4 != 0) {
return null;
}
for (int i = 0; i < len; i += 4) {
raw = (char) Integer.parseInt(s.substring(i, i + 4), 16);
to.append(raw);
}
return (to.toString());
}
/**
* Returns a character sequence which is the result of writing the
* first <code>length</code> number of characters from the second
* given <code>String</code> over the first string. The start position
* in the first string where the characters are overwritten is given by
* <code>start</code>.<p>
*
* <b>Note:</b> In order of precedence, boundry conditions are handled as
* follows:<p>
*
* <UL>
* <LI>if either supplied <code>String</code> is null, then the other is
* returned; the check starts with the first given <code>String</code>.
* <LI>if <code>start</code> is less than one, <code>s1</code> is returned
* <LI>if <code>length</code> is less than or equal to zero,
* <code>s1</code> is returned
* <LI>if the length of <code>s2</code> is zero, <code>s1</code> is returned
* <LI>if <code>start</code> is greater than the length of <code>s1</code>,
* <code>s1</code> is returned
* <LI>if <code>length</code> is such that, taken together with
* <code>start</code>, the indicated interval extends
* beyond the end of <code>s1</code>, then the insertion is performed
* precisely as if upon a copy of <code>s1</code> extended in length
* to just include the indicated interval
* </UL>
* @param s1 the <code>String</code> into which to insert <code>s2</code>
* @param start the position, with origin one, at which to start the insertion
* @param length the number of characters in <code>s1</code> to replace
* @param s2 the <code>String</code> to insert into <code>s1</code>
* @return <code>s2</code> inserted into <code>s1</code>, as indicated
* by <code>start</code> and <code>length</code> and adjusted for
* boundry conditions
*/
public static String insert(String s1, int start, int length, String s2) {
if (s1 == null) {
return s2;
}
if (s2 == null) {
return s1;
}
int len1 = s1.length();
int len2 = s2.length();
start--;
if (start < 0 || length <= 0 || len2 == 0 || start > len1) {
return s1;
}
if (length > len2) {
length = len2;
}
if (start + length > len1) {
length = len1 - start;
}
return s1.substring(0, start) + s2.substring(0, length)
+ s1.substring(start + length);
}
/**
* Returns a copy of the given <code>String</code>, with all upper case
* characters converted to lower case. This uses the default Java String
* conversion.
* @param s the <code>String</code> from which to produce a lower case
* version
* @return a lower case version of <code>s</code>
*/
public static String lcase(String s) {
return (s == null) ? null
: s.toLowerCase();
}
/**
* Returns the leftmost <code>count</code> characters from the given
* <code>String</code>. <p>
*
* <b>Note:</b> boundry conditions are handled in the following order of
* precedence:
*
* <UL>
* <LI> if <code>s</code> is <code>null</code>, then <code>null</code>
* is returned
* <LI> if <code>count</code> is less than 1, then a zero-length
* <code>String</code> is returned
* <LI> if <code>count</code> is greater than the length of <code>s</code>,
* then a copy of <code>s</code> is returned
* </UL>
* @param s the <code>String</code> from which to retrieve the leftmost
* characters
* @param count the count of leftmost characters to retrieve
* @return the leftmost <code>count</code> characters of <code>s</code>
*/
public static String left(String s, int count) {
if (s == null) {
return null;
}
return s.substring(0, ((count < 0) ? 0
: (count < s.length()) ? count
: s.length()));
}
// fredt@users - 20020819 - patch 595854 by thomasm@users
/**
* Returns the number of characters in the given <code>String</code>.
* This includes trailing blanks.
*
* @param s the <code>String</code> for which to determine length
* @return the length of <code>s</code>, including trailing blanks
*/
public static Integer length(String s) {
return s == null ? null
: ValuePool.getInt(s.length());
}
/**
* Returns the number of bytes in the given <code>String</code>.
* This includes trailing blanks.
*
* @param s the <code>String</code> for which to determine the octet length
* @return the octet length of <code>s</code>, including trailing blanks
* @since 1.7.2
*/
public static Integer octetLength(String s) {
return s == null ? null
: ValuePool.getInt(s.length() * 2);
}
/**
* Returns the number of bits in the given <code>String</code>.
* This includes trailing blanks.
*
* @param s the <code>String</code> for which to determine the bit length
* @return the bit length of <code>s</code>, including trailing blanks
* @since 1.7.2
*/
public static Integer bitLength(String s) {
return s == null ? null
: ValuePool.getInt(s.length() * 16);
}
/**
* Returns the starting position of the first occurrence of
* the given <code>search</code> <code>String</code> object within
* the given <code>String</code> object, <code>s</code>.
*
* The search for the first occurrence of <code>search</code> begins with
* the first character position in <code>s</code>, unless the optional
* argument, <code>start</code>, is specified (non-null). If
* <code>start</code> is specified, the search begins with the character
* position indicated by the value of <code>start</code>, where the
* first character position in <code>s</code> is indicated by the value 1.
* If <code>search</code> is not found within <code>s</code>, the
* value 0 is returned.
* @param search the <code>String</code> occurence to find in <code>s</code>
* @param s the <code>String</code> within which to find the first
* occurence of <code>search</code>
* @param start the optional character position from which to start
* looking in <code>s</code>
* @return the one-based starting position of the first occurrence of
* <code>search</code> within <code>s</code>, or 0 if not found
*/
public static int locate(String search, String s, Integer start) {
if (s == null || search == null) {
return 0;
}
int i = (start == null) ? 0
: start.intValue() - 1;
return s.indexOf(search, (i < 0) ? 0
: i) + 1;
}
/**
* As locate but from start position l. <p>
*
* @param search the <code>String</code> occurence to find in <code>s</code>
* @param s the <code>String</code> within which to find the first
* occurence of <code>search</code>
* @return the one-based starting position of the first occurrence of
* <code>search</code> within <code>s</code>, or 0 if not found
*/
public static int position(String search, String s) {
return locate(search, s, null);
}
/**
* Returns the characters of the given <code>String</code>, with the
* leading spaces removed. Characters such as TAB are not removed.
*
* @param s the <code>String</code> from which to remove the leading blanks
* @return the characters of the given <code>String</code>, with the leading
* spaces removed
*/
public static String ltrim(String s) {
if (s == null) {
return s;
}
int len = s.length(),
i = 0;
while (i < len && s.charAt(i) <= ' ') {
i++;
}
return (i == 0) ? s
: s.substring(i);
}
/**
* Converts a raw binary value, as represented by the given
* <code>String</code>, to the equivalent <code>String</code>
* of hexidecimal digit characters. <p>
*
* This conversion has the effect of expanding the character count 1:4.
*
* @param s the raw binary value, as a <code>String</code>
* @return an equivalent <code>String</code> of hexidecimal digit characters
*/
public static String rawToHex(String s) {
if (s == null) {
return null;
}
char[] from = s.toCharArray();
String hex;
StringBuffer to = new StringBuffer(4 * s.length());
for (int i = 0; i < from.length; i++) {
hex = Integer.toHexString(from[i] & 0xffff);
for (int j = hex.length(); j < 4; j++) {
to.append('0');
}
to.append(hex);
}
return (to.toString());
}
/**
* Returns a <code>String</code> composed of the given <code>String</code>,
* repeated <code>count</code> times.
*
* @param s the <code>String</code> to repeat
* @param count the number of repetitions
* @return the given <code>String</code>, repeated <code>count</code> times
*/
public static String repeat(String s, Integer count) {
if (s == null || count == null || count.intValue() < 0) {
return null;
}
int i = count.intValue();
StringBuffer b = new StringBuffer(s.length() * i);
while (i-- > 0) {
b.append(s);
}
return b.toString();
}
// fredt@users - 20020903 - patch 1.7.1 - bug fix to allow multiple replaces
/**
* Replaces all occurrences of <code>replace</code> in <code>s</code>
* with the <code>String</code> object: <code>with</code>
* @param s the target for replacement
* @param replace the substring(s), if any, in <code>s</code> to replace
* @param with the value to substitute for <code>replace</code>
* @return <code>s</code>, with all occurences of <code>replace</code>
* replaced by <code>with</code>
*/
public static String replace(String s, String replace, String with) {
if (s == null || replace == null) {
return s;
}
if (with == null) {
with = "";
}
StringBuffer b = new StringBuffer();
int start = 0;
int lenreplace = replace.length();
while (true) {
int i = s.indexOf(replace, start);
if (i == -1) {
b.append(s.substring(start));
break;
}
b.append(s.substring(start, i));
b.append(with);
start = i + lenreplace;
}
return b.toString();
}
/**
* Returns the rightmost <code>count</code> characters of the given
* <code>String</code>, <code>s</code>. <p>
*
* <b>Note:</b> boundry conditions are handled in the following order of
* precedence: <p>
*
* <UL>
* <LI> if <code>s</code> is <code>null</code>, <code>null</code> is returned
* <LI> if <code>count</code> is less than one, a zero-length
* <code>String</code> is returned
* <LI> if <code>count</code> is greater than the length of <code>s</code>,
* a copy of <code>s</code> is returned
* </UL>
* @param s the <code>String</code> from which to retrieve the rightmost
* <code>count</code> characters
* @param count the number of rightmost characters to retrieve
* @return the rightmost <code>count</code> characters of <code>s</code>
*/
public static String right(String s, int count) {
if (s == null) {
return null;
}
count = s.length() - count;
return s.substring((count < 0) ? 0
: (count < s.length()) ? count
: s.length());
}
// fredt@users 20020530 - patch 1.7.0 fredt - trim only the space character
/**
* Returns the characters of the given <code>String</code>, with trailing
* spaces removed.
* @param s the <code>String</code> from which to remove the trailing blanks
* @return the characters of the given <code>String</code>, with the
* trailing spaces removed
*/
public static String rtrim(String s) {
if (s == null) {
return s;
}
int endindex = s.length() - 1;
int i = endindex;
for (; i >= 0 && s.charAt(i) == ' '; i--) {}
return i == endindex ? s
: s.substring(0, i + 1);
}
/**
* Returns the character sequence <code>s</code>, with the leading,
* trailing or both the leading and trailing occurences of the first
* character of the character sequence <code>trimstr</code> removed. <p>
*
* This method is in support of the standard SQL String function TRIM.
* Ordinarily, the functionality of this method is accessed from SQL using
* the following syntax: <p>
*
* <pre class="SqlCodeExample">
* <trim function> ::= TRIM <left paren> <trim operands> <right paren>
* <trim operands> ::= [ [ <trim specification> ] [ <trim character> ] FROM ] <trim source>
* <trim source> ::= <character value expression>
* <trim specification> ::= LEADING | TRAILING | BOTH
* <trim character> ::= <character value expression>
* </pre>
*
* @param s the string to trim
* @param trimstr the character whose occurences will be removed
* @param leading if true, remove leading occurences
* @param trailing if true, remove trailing occurences
* @return s, with the leading, trailing or both the leading and trailing
* occurences of the first character of <code>trimstr</code> removed
* @since 1.7.2
*/
public static String trim(String s, String trimstr, boolean leading,
boolean trailing) {
if (s == null) {
return s;
}
int trim = trimstr.charAt(0);
int endindex = s.length();
if (trailing) {
for (--endindex; endindex >= 0 && s.charAt(endindex) == trim;
endindex--) {}
endindex++;
}
if (endindex == 0) {
return "";
}
int startindex = 0;
if (leading) {
while (startindex < endindex && s.charAt(startindex) == trim) {
startindex++;
}
}
if (startindex == 0 && endindex == s.length()) {
return s;
} else {
return s.substring(startindex, endindex);
}
}
// fredt@users 20011010 - patch 460907 by fredt - soundex
/**
* Returns a four character code representing the sound of the given
* <code>String</code>. Non-ASCCI characters in the
* input <code>String</code> are ignored. <p>
*
* This method was
* rewritten for HSQLDB by fredt@users to comply with the description at
* <a href="http://www.archives.gov/genealogy/census/soundex.html">
* http://www.archives.gov/genealogy/census/soundex.html </a>.<p>
* @param s the <code>String</code> for which to calculate the 4 character
* <code>SOUNDEX</code> value
* @return the 4 character <code>SOUNDEX</code> value for the given
* <code>String</code>
*/
public static String soundex(String s) {
if (s == null) {
return s;
}
s = s.toUpperCase(Locale.ENGLISH);
int len = s.length();
char[] b = new char[] {
'0', '0', '0', '0'
};
char lastdigit = '0';
for (int i = 0, j = 0; i < len && j < 4; i++) {
char c = s.charAt(i);
char newdigit;
if ("AEIOUY".indexOf(c) != -1) {
newdigit = '7';
} else if (c == 'H' || c == 'W') {
newdigit = '8';
} else if ("BFPV".indexOf(c) != -1) {
newdigit = '1';
} else if ("CGJKQSXZ".indexOf(c) != -1) {
newdigit = '2';
} else if (c == 'D' || c == 'T') {
newdigit = '3';
} else if (c == 'L') {
newdigit = '4';
} else if (c == 'M' || c == 'N') {
newdigit = '5';
} else if (c == 'R') {
newdigit = '6';
} else {
continue;
}
if (j == 0) {
b[j++] = c;
lastdigit = newdigit;
} else if (newdigit <= '6') {
if (newdigit != lastdigit) {
b[j++] = newdigit;
lastdigit = newdigit;
}
} else if (newdigit == '7') {
lastdigit = newdigit;
}
}
return new String(b, 0, 4);
}
/**
* Returns a <code>String</code> consisting of <code>count</code> spaces, or
* <code>null</code> if <code>count</code> is less than zero. <p>
*
* @param count the number of spaces to produce
* @return a <code>String</code> of <code>count</code> spaces
*/
public static String space(int count) {
if (count < 0) {
return null;
}
char[] c = new char[count];
while (count > 0) {
c[--count] = ' ';
}
return new String(c);
}
/**
* Returns the characters from the given <code>String</code>, starting at
* the indicated one-based <code>start</code> position and extending the
* (optional) indicated <code>length</code>. If <code>length</code> is not
* specified (is <code>null</code>), the remainder of <code>s</code> is
* implied.
*
* The rules for boundary conditions on s, start and length are,
* in order of precedence: <p>
*
* 1.) if s is null, return null
*
* 2.) If length is less than 1, return null.
*
* 3.) If start is 0, it is treated as 1.
*
* 4.) If start is positive, count from the beginning of s to find
* the first character postion.
*
* 5.) If start is negative, count backwards from the end of s
* to find the first character.
*
* 6.) If, after applying 2.) or 3.), the start position lies outside s,
* then return null
*
* 7.) if length is ommited or is greated than the number of characters
* from the start position to the end of s, return the remaineder of s,
* starting with the start position.
*
* @param s the <code>String</code> from which to produce the indicated
* substring
* @param start the starting position of the desired substring
* @param length the length of the desired substring
* @return the indicted substring of <code>s</code>.
*/
// fredt@users 20020210 - patch 500767 by adjbirch@users - modified
// boucherb@users 20050205 - patch to correct bug 1107477
public static String substring(final String s, int start,
final Integer length) {
if (s == null) {
return null;
}
int sl = s.length();
int ol = (length == null) ? sl
: length.intValue();
if (ol < 1) {
return null;
}
if (start < 0) {
start = sl + start;
} else if (start > 0) {
start--;
}
if (start < 0 || start >= sl) {
return null;
} else if (start > sl - ol) {
ol = sl - start;
}
return s.substring(start, start + ol);
}
/**
* Returns a copy of the given <code>String</code>, with all lower case
* characters converted to upper case using the default Java method.
* @param s the <code>String</code> from which to produce an upper case
* version
* @return an upper case version of <code>s</code>
*/
public static String ucase(String s) {
return (s == null) ? null
: s.toUpperCase();
}
// TIME AND DATE
/**
* Returns the current date as a date value. <p>
*
* Dummy mehtod.<p>
*
* @return a date value representing the current date
*/
public static Date curdate(Connection c) {
return null;
}
/**
* Returns the current local time as a time value. <p>
*
* Dummy mehtod.<p>
*
* @return a time value representing the current local time
*/
public static TimeData curtime(Connection c) {
return null;
}
/**
* Returns a character string containing the name of the day
* (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday )
* for the day portion of the given <code>java.sql.Date</code>.
* @param d the date value from which to extract the day name
* @return the name of the day corresponding to the given
* <code>java.sql.Date</code>
*/
public static String dayname(Date d) {
if (d == null) {
return null;
}
synchronized (daynameBuffer) {
daynameBuffer.setLength(0);
return daynameFormat.format(d, daynameBuffer,
dayPosition).toString();
}
}
/**
* Returns the day of the month from the given date value, as an integer
* value in the range of 1-31.
*
* @param d the date value from which to extract the day of month
* @return the day of the month from the given date value
*/
public static Integer dayofmonth(Date d) {
if (d == null) {
return null;
}
return ValuePool.getInt(HsqlDateTime.getDateTimePart(d,
Calendar.DAY_OF_MONTH));
}
/**
* Returns the day of the week from the given date value, as an integer
* value in the range 1-7, where 1 represents Sunday.
*
* @param d the date value from which to extract the day of week
* @return the day of the week from the given date value
*/
public static Integer dayofweek(Date d) {
if (d == null) {
return null;
}
return ValuePool.getInt(HsqlDateTime.getDateTimePart(d,
Calendar.DAY_OF_WEEK));
}
/**
* Returns the day of the year from the given date value, as an integer
* value in the range 1-366.
*
* @param d the date value from which to extract the day of year
* @return the day of the year from the given date value
*/
public static Integer dayofyear(Date d) {
if (d == null) {
return null;
}
return ValuePool.getInt(HsqlDateTime.getDateTimePart(d,
Calendar.DAY_OF_YEAR));
}
/**
* Returns a character string containing the name of month
* (January, February, March, April, May, June, July, August,
* September, October, November, December) for the month portion of
* the given date value.
*
* @param d the date value from which to extract the month name
* @return a String representing the month name from the given date value
*/
public static String monthname(Date d) {
if (d == null) {
return null;
}
synchronized (monthnameBuffer) {
monthnameBuffer.setLength(0);
return monthnameFormat.format(d, monthnameBuffer,
monthPosition).toString();
}
}
/**
* Returns the quarter of the year in the given date value, as an integer
* value in the range of 1-4. <p>
*
* @param d the date value from which to extract the quarter of the year
* @return an integer representing the quater of the year from the given
* date value
*/
public static Integer quarter(Date d) {
if (d == null) {
return null;
}
return ValuePool.getInt(
(HsqlDateTime.getDateTimePart(d, Calendar.MONTH) / 3) + 1);
}
/**
* Returns the week of the year from the given date value, as an integer
* value in the range of 1-53. <p>
*
* @param d the date value from which to extract the week of the year
* @return an integer representing the week of the year from the given
* date value
*/
public static Integer week(Date d) {
if (d == null) {
return null;
}
return ValuePool.getInt(HsqlDateTime.getDateTimePart(d,
Calendar.WEEK_OF_YEAR));
}
/**
* @since 1.8.0
*/
public static String to_char(java.util.Date d, String format) {
if (d == null || format == null) {
return null;
}
synchronized (tocharFormat) {
tocharFormat.applyPattern(HsqlDateTime.toJavaDatePattern(format));
return tocharFormat.format(d);
}
}
// date calculations.
/**
* Returns the number of units elapsed between two dates.<p>
* The datapart parameter indicates the part to be used for computing the
* difference. Supported types include: 'year', 'yy', 'month', 'mm'
* 'day', 'dd', 'hour', 'hh', 'minute', 'mi', 'second', 'ss', 'millisecond',
* 'ms'.
*
* Contributed by Michael Landon<p>
*
* @param datepart Specifies the unit in which the interval is to be measured.
* @param d1 The starting datetime value for the interval. This value is
* subtracted from d2 to return the number of
* date-parts between the two arguments.
* @param d2 The ending datetime for the interval. d1 is subtracted
* from this value to return the number of date-parts
* between the two arguments.
*
* since 1.7.3
*/
public static Long datediff(String datepart, Timestamp d1,
Timestamp d2) throws HsqlException {
// make sure we've got valid data
if (d1 == null || d2 == null) {
return null;
}
if ("yy".equalsIgnoreCase(datepart)
|| "year".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.YEAR, d1, d2));
} else if ("mm".equalsIgnoreCase(datepart)
|| "month".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.MONTH, d1, d2));
} else if ("dd".equalsIgnoreCase(datepart)
|| "day".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.DATE, d1, d2));
} else if ("hh".equalsIgnoreCase(datepart)
|| "hour".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.HOUR, d1, d2));
} else if ("mi".equalsIgnoreCase(datepart)
|| "minute".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.MINUTE, d1, d2));
} else if ("ss".equalsIgnoreCase(datepart)
|| "second".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.SECOND, d1, d2));
} else if ("ms".equalsIgnoreCase(datepart)
|| "millisecond".equalsIgnoreCase(datepart)) {
return ValuePool.getLong(getElapsed(Calendar.MILLISECOND, d1, d2));
} else {
throw Trace.error(Trace.INVALID_CONVERSION);
}
}
/**
* Private method used to do actual calculation units elapsed between
* two given dates. <p>
*
* @param field Calendar field to use to calculate elapsed time
* @param d1 The starting date for the interval. This value is
* subtracted from d2 to return the number of
* date-parts between the two arguments.
* @param d2 The ending date for the interval. d1 is subtracted
* from this value to return the number of date-parts
* between the two arguments.
*/
private static long getElapsed(int field, java.util.Date d1,
java.util.Date d2) {
// can we do this very simply?
if (field == Calendar.MILLISECOND) {
return d2.getTime() - d1.getTime();
}
// ok, let's work a little harder:
Calendar g1 = Calendar.getInstance(),
g2 = Calendar.getInstance();
g1.setTime(d1);
g2.setTime(d2);
g1.set(Calendar.MILLISECOND, 0);
g2.set(Calendar.MILLISECOND, 0);
if (field == Calendar.SECOND) {
return (g2.getTime().getTime() - g1.getTime().getTime()) / 1000;
}
g1.set(Calendar.SECOND, 0);
g2.set(Calendar.SECOND, 0);
if (field == Calendar.MINUTE) {
return (g2.getTime().getTime() - g1.getTime().getTime())
/ (1000 * 60);
}
g1.set(Calendar.MINUTE, 0);
g2.set(Calendar.MINUTE, 0);
if (field == Calendar.HOUR) {
return (g2.getTime().getTime() - g1.getTime().getTime())
/ (1000 * 60 * 60);
} // end if-else
// if we got here, then we really need to work:
long elapsed = 0;
short sign = 1;
if (g2.before(g1)) {
sign = -1;
Calendar tmp = g1;
g1 = g2;
g2 = tmp;
} // end if
g1.set(Calendar.HOUR_OF_DAY, 0);
g2.set(Calendar.HOUR_OF_DAY, 0);
if (field == Calendar.MONTH || field == Calendar.YEAR) {
g1.set(Calendar.DATE, 1);
g2.set(Calendar.DATE, 1);
}
if (field == Calendar.YEAR) {
g1.set(Calendar.MONTH, 1);
g2.set(Calendar.MONTH, 1);
} // end if-else
// then calculate elapsed units
while (g1.before(g2)) {
g1.add(field, 1);
elapsed++;
}
return sign * elapsed;
} // end getElapsed
// SYSTEM
/*
* All system functions that return Session dependent information are
* dummies here.
*/
/**
* Returns the name of the database corresponding to this connection.
*
* @param conn the connection for which to retrieve the database name
* @return the name of the database for the given connection
* @throws HsqlException if a database access error occurs
*/
public static String database(Connection conn) throws HsqlException {
return null;
}
// JDBC SYSTEM
/**
* Retrieves the autocommit status of this connection. <p>
*
* @param conn the <code>Connection</code> object for which to retrieve
* the current autocommit status
* @return a boolean value representing the connection's autocommit status
* @since 1.7.0
*/
public static boolean getAutoCommit(Connection conn) {
return false;
}
/**
* Retrieves the full version number of this database product. <p>
*
* @return database version number as a <code>String</code> object
* @since 1.8.0.4
*/
public static String getDatabaseFullProductVersion() {
return HsqlDatabaseProperties.THIS_FULL_VERSION;
}
/**
* Retrieves the name of this database product. <p>
*
* @return database product name as a <code>String</code> object
* @since 1.7.2
*/
public static String getDatabaseProductName() {
return HsqlDatabaseProperties.PRODUCT_NAME;
}
/**
* Retrieves the version number of this database product. <p>
*
* @return database version number as a <code>String</code> object
* @since 1.7.2
*/
public static String getDatabaseProductVersion() {
return HsqlDatabaseProperties.THIS_VERSION;
}
/**
* Retrieves the major version number of this database. <p>
*
* @return the database's major version as an <code>int</code> value
* @since 1.7.2
*/
public static int getDatabaseMajorVersion() {
return HsqlDatabaseProperties.MAJOR;
}
/**
* Retrieves the major version number of this database. <p>
*
* @return the database's major version as an <code>int</code> value
* @since 1.7.2
*/
public static int getDatabaseMinorVersion() {
return HsqlDatabaseProperties.MINOR;
}
/**
* Retrieves whether this connection is in read-only mode. <p>
*
* Dummy mehtod.<p>
*
* @param conn the <code>Connection</code> object for which to retrieve
* the current read-only status
* @return <code>true</code> if connection is read-only and
* <code>false</code> otherwise
* @since 1.7.2
*/
public static boolean isReadOnlyConnection(Connection conn) {
return false;
}
/**
* Dummy method. Retrieves whether this database is in read-only mode. <p>
*
* @param c the <code>Connection</code> object for which to retrieve
* the current database read-only status
* @return <code>true</code> if so; <code>false</code> otherwise
* @since 1.7.2
*/
public static boolean isReadOnlyDatabase(Connection c) {
return false;
}
/**
* Retrieves whether the files of this database are in read-only mode. <p>
*
* Dummy mehtod.<p>
*
* @param c the <code>Connection</code> object for which to retrieve
* the current database files read-only status
* @return <code>true</code> if so; <code>false</code> otherwise
* @since 1.7.2
*/
public static boolean isReadOnlyDatabaseFiles(Connection c) {
return false;
}
static final int abs = 0;
static final int ascii = 1;
static final int bitand = 2;
static final int bitLength = 3;
static final int bitor = 4;
static final int bitxor = 5;
static final int character = 6;
static final int concat = 7;
static final int cot = 8;
static final int curdate = 9;
static final int curtime = 10;
static final int database = 11;
static final int datediff = 12;
static final int day = 13;
static final int dayname = 14;
static final int dayofmonth = 15;
static final int dayofweek = 16;
static final int dayofyear = 17;
static final int difference = 18;
static final int dmod = 19;
static final int getAutoCommit = 20;
static final int getDatabaseFullProductVersion = 21;
static final int getDatabaseMajorVersion = 22;
static final int getDatabaseMinorVersion = 23;
static final int getDatabaseProductName = 24;
static final int getDatabaseProductVersion = 25;
static final int hexToRaw = 26;
static final int hour = 27;
static final int identity = 28;
static final int insert = 29;
static final int isReadOnlyConnection = 30;
static final int isReadOnlyDatabase = 31;
static final int isReadOnlyDatabaseFiles = 32;
static final int lcase = 33;
static final int left = 34;
static final int length = 35;
static final int locate = 36;
static final int log10 = 37;
static final int ltrim = 38;
static final int minute = 39;
static final int mod = 40;
static final int month = 41;
static final int monthname = 42;
static final int now = 43;
static final int octetLength = 44;
static final int pi = 45;
static final int position = 46;
static final int quarter = 47;
static final int rand = 48;
static final int rawToHex = 49;
static final int repeat = 50;
static final int replace = 51;
static final int right = 52;
static final int round = 53;
static final int roundMagic = 54;
static final int rtrim = 55;
static final int second = 56;
static final int sign = 57;
static final int soundex = 58;
static final int space = 59;
static final int substring = 60;
static final int to_char = 61;
static final int trim = 62;
static final int truncate = 63;
static final int ucase = 64;
static final int user = 65;
static final int week = 66;
static final int year = 67;
/** @todo see bitxor and datediff numbering */
//
private static final IntValueHashMap functionMap = new IntValueHashMap(68);
static final Double piValue = new Double(Library.pi());
static {
functionMap.put("ascii", ascii);
functionMap.put("bitand", bitand);
functionMap.put("bitlength", bitLength);
functionMap.put("bitor", bitor);
functionMap.put("bitxor", bitor);
functionMap.put("character", character);
functionMap.put("concat", concat);
functionMap.put("cot", cot);
functionMap.put("curdate", curdate);
functionMap.put("curtime", curtime);
functionMap.put("database", database);
functionMap.put("datediff", datediff);
functionMap.put("dayname", dayname);
functionMap.put("dayofmonth", dayofmonth);
functionMap.put("dayofweek", dayofweek);
functionMap.put("dayofyear", dayofyear);
functionMap.put("difference", difference);
functionMap.put("dmod", dmod);
functionMap.put("getAutoCommit", getAutoCommit);
functionMap.put("getDatabaseFullProductVersion",
getDatabaseFullProductVersion);
functionMap.put("getDatabaseMajorVersion", getDatabaseMajorVersion);
functionMap.put("getDatabaseMinorVersion", getDatabaseMinorVersion);
functionMap.put("getDatabaseProductName", getDatabaseProductName);
functionMap.put("getDatabaseProductVersion",
getDatabaseProductVersion);
functionMap.put("hexToRaw", hexToRaw);
functionMap.put("insert", insert);
functionMap.put("isReadOnlyConnection", isReadOnlyConnection);
functionMap.put("isReadOnlyDatabase", isReadOnlyDatabase);
functionMap.put("isReadOnlyDatabaseFiles", isReadOnlyDatabaseFiles);
functionMap.put("lcase", lcase);
functionMap.put("left", left);
functionMap.put("length", length);
functionMap.put("locate", locate);
functionMap.put("log10", log10);
functionMap.put("ltrim", ltrim);
functionMap.put("monthname", monthname);
functionMap.put("octetLength", octetLength);
functionMap.put("pi", pi);
functionMap.put("position", position);
functionMap.put("quarter", quarter);
functionMap.put("rand", rand);
functionMap.put("rawToHex", rawToHex);
functionMap.put("repeat", repeat);
functionMap.put("replace", replace);
functionMap.put("right", right);
functionMap.put("round", round);
functionMap.put("roundMagic", roundMagic);
functionMap.put("rtrim", rtrim);
functionMap.put("sign", sign);
functionMap.put("soundex", soundex);
functionMap.put("space", space);
functionMap.put("substring", substring);
functionMap.put("to_char", to_char);
functionMap.put("trim", trim);
functionMap.put("truncate", truncate);
functionMap.put("ucase", ucase);
functionMap.put("week", week);
}
static Object invoke(int fID, Object[] params) throws HsqlException {
try {
switch (fID) {
case ascii : {
return ascii((String) params[0]);
}
case bitand : {
return ValuePool.getInt(
bitand(((Number) params[0]).intValue(),
((Number) params[1]).intValue()));
}
case bitLength : {
return bitLength((String) params[0]);
}
case bitor : {
return ValuePool.getInt(
bitor(((Number) params[0]).intValue(),
((Number) params[1]).intValue()));
}
case bitxor : {
return ValuePool.getInt(
bitxor(((Number) params[0]).intValue(),
((Number) params[1]).intValue()));
}
case character : {
return character(((Number) params[0]).intValue());
}
case concat : {
return concat((String) params[0], (String) params[1]);
}
case cot : {
return new Double(cot(((Number) params[0]).doubleValue()));
}
case curdate : {
return null;
}
case curtime : {
return null;
}
case database : {
return null;
}
case datediff : {
return datediff((String) params[0], (Timestamp) params[1],
(Timestamp) params[2]);
}
case dayname : {
return dayname((Date) params[0]);
}
case dayofmonth : {
return dayofmonth((Date) params[0]);
}
case dayofweek : {
return dayofweek((Date) params[0]);
}
case dayofyear : {
return dayofyear((Date) params[0]);
}
case difference : {
return ValuePool.getInt(difference((String) params[0],
(String) params[1]));
}
// fix for "bug" [ 1455637 ] allow double args for modulo
case dmod : {
return ValuePool.getDouble(
Double.doubleToLongBits(
dmod(((Number) params[0]).doubleValue(),
((Number) params[1]).doubleValue())));
}
case getAutoCommit : {
return null;
}
case getDatabaseFullProductVersion : {
return getDatabaseFullProductVersion();
}
case getDatabaseMajorVersion : {
return ValuePool.getInt(getDatabaseMajorVersion());
}
case getDatabaseMinorVersion : {
return ValuePool.getInt(getDatabaseMinorVersion());
}
case getDatabaseProductName : {
return getDatabaseProductName();
}
case getDatabaseProductVersion : {
return getDatabaseProductVersion();
}
case hexToRaw : {
return hexToRaw((String) params[0]);
}
case insert : {
return insert((String) params[0],
((Number) params[1]).intValue(),
((Number) params[2]).intValue(),
(String) params[3]);
}
case isReadOnlyConnection : {
return null;
}
case isReadOnlyDatabase : {
return null;
}
case lcase : {
return lcase((String) params[0]);
}
case left : {
return left((String) params[0],
((Number) params[1]).intValue());
}
case length : {
return length((String) params[0]);
}
case locate : {
return ValuePool.getInt(locate((String) params[0],
(String) params[1],
(Integer) params[2]));
}
case log10 : {
return new Double(
log10(((Number) params[0]).doubleValue()));
}
case ltrim : {
return ltrim((String) params[0]);
}
case monthname : {
return ValuePool.getString(monthname((Date) params[0]));
}
case octetLength : {
return octetLength((String) params[0]);
}
case position : {
return ValuePool.getInt(position((String) params[0],
(String) params[1]));
}
case pi : {
return piValue;
}
case quarter : {
return quarter((Date) params[0]);
}
case rand : {
return new Double(rand((Integer) params[0]));
}
case rawToHex : {
return rawToHex((String) params[0]);
}
case repeat : {
return repeat((String) params[0], (Integer) params[1]);
}
case replace : {
return replace((String) params[0], (String) params[1],
(String) params[2]);
}
case right : {
return right((String) params[0],
((Number) params[1]).intValue());
}
case round : {
return new Double(round(((Number) params[0]).doubleValue(),
((Number) params[1]).intValue()));
}
case roundMagic : {
return new Double(
roundMagic(((Number) params[0]).doubleValue()));
}
case rtrim : {
return rtrim((String) params[0]);
}
case sign : {
return ValuePool.getInt(
sign(((Number) params[0]).doubleValue()));
}
case soundex : {
return soundex((String) params[0]);
}
case space : {
return space(((Number) params[0]).intValue());
}
case substring : {
return substring((String) params[0],
((Number) params[1]).intValue(),
(Integer) params[2]);
}
case trim : {
return trim((String) params[0], (String) params[1],
((Boolean) params[2]).booleanValue(),
((Boolean) params[3]).booleanValue());
}
case truncate : {
return new Double(
truncate(
((Number) params[0]).doubleValue(),
((Number) params[1]).intValue()));
}
case ucase : {
return ucase((String) params[0]);
}
case week : {
return week((Date) params[0]);
}
case to_char : {
return to_char((java.util.Date) params[0],
(String) params[1]);
}
case isReadOnlyDatabaseFiles : {
return null;
}
default : {
// coding error
throw Trace.runtimeError(
Trace.UNSUPPORTED_INTERNAL_OPERATION, "Library");
}
}
} catch (Exception e) {
throw Trace.error(Trace.FUNCTION_CALL_ERROR, e.toString());
}
}
static final String prefix = "org.hsqldb.Library.";
static final int prefixLength = prefix.length();
static int functionID(String fname) {
return fname.startsWith(prefix)
? functionMap.get(fname.substring(prefixLength), -1)
: -1;
}
}
The table below shows all metrics for Library.java.
| Metric | Value | Description | |
|---|---|---|---|
| BLOCKS | 222.00 | Number of blocks | |
| BLOCK_COMMENT | 68.00 | Number of block comment lines | |
| COMMENTS | 781.00 | Comment lines | |
| COMMENT_DENSITY | 0.90 | Comment density | |
| COMPARISONS | 179.00 | Number of comparison operators | |
| CYCLOMATIC | 264.00 | Cyclomatic complexity | |
| DECL_COMMENTS | 101.00 | Comments in declarations | |
| DOC_COMMENT | 651.00 | Number of javadoc comment lines | |
| ELOC | 866.00 | Effective lines of code | |
| EXEC_COMMENTS | 10.00 | Comments in executable code | |
| EXITS | 114.00 | Procedure exits | |
| FUNCTIONS | 63.00 | Number of function declarations | |
| HALSTEAD_DIFFICULTY | 105.90 | Halstead difficulty | |
| HALSTEAD_EFFORT | 0.00 | Halstead effort | |
| INTERFACE_COMPLEXITY | 256.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 | 0.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 | 0.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 | 0.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 | 1.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 | 0.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 | 15.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 | 4.00 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0109 | 0.00 | JAVA0109 Incorrect javadoc: no parameter 'parameter' | |
| JAVA0110 | 3.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 | 1.00 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| JAVA0116 | 4.00 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0117 | 0.00 | JAVA0117 Missing javadoc: method 'method' | |
| JAVA0118 | 0.00 | JAVA0118 Missing javadoc: type 'type' | |
| JAVA0119 | 2.00 | JAVA0119 Control variable changed within body of for loop | |
| JAVA0123 | 1.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 | 1.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 | 0.00 | JAVA0144 Line exceeds maximum M characters | |
| JAVA0145 | 0.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 | 1.00 | JAVA0160 Method does not throw specified exception | |
| JAVA0161 | 0.00 | JAVA0161 Conditional wait() not in loop | |
| JAVA0163 | 0.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 | 7.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 | 3.00 | JAVA0177 Variable declaration missing initializer | |
| JAVA0179 | 2.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 | 1.00 | JAVA0262 Use of char in integer context | |
| JAVA0263 | 0.00 | JAVA0263 Long literal ends with 'l' instead of 'L' | |
| JAVA0264 | 2.00 | JAVA0264 Integer math in long context - check for overflow | |
| JAVA0265 | 0.00 | JAVA0265 Use of Throwable.printStackTrace() | |
| JAVA0266 | 0.00 | JAVA0266 Use of System.out | |
| JAVA0267 | 0.00 | JAVA0267 Use of System.err | |
| JAVA0269 | 0.00 | JAVA0269 Contents of StringBuffer never used | |
| JAVA0270 | 2.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 | 2091.00 | Number of lines in the source file | |
| LINE_COMMENT | 62.00 | Number of line comments | |
| LOC | 1069.00 | Lines of code | |
| LOGICAL_LINES | 458.00 | Number of statements | |
| LOOPS | 14.00 | Number of loops | |
| NEST_DEPTH | 4.00 | Maximum nesting depth | |
| OPERANDS | 2257.00 | Number of operands | |
| OPERATORS | 4644.00 | Number of operators | |
| PARAMS | 86.00 | Number of formal parameter declarations | |
| PROGRAM_LENGTH | 6901.00 | Halstead program length | |
| PROGRAM_VOCAB | 746.00 | Halstead program vocabulary | |
| PROGRAM_VOLUME | 0.00 | Halstead program volume | |
| RETURNS | 170.00 | Number of return points from functions | |
| SIZE | 74314.00 | Size of the file in bytes | |
| UNIQUE_OPERANDS | 682.00 | Number of unique operands | |
| UNIQUE_OPERATORS | 64.00 | Number of unique operators | |
| WHITESPACE | 241.00 | Number of whitespace lines | |