OraclePlugin.java
| Index Score | ||
|---|---|---|
 |
 |
net.sourceforge.squirrel_sql.plugins.oracle |
 |
 |
Squirrel SQL |
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 | |
|---|---|---|
| EXITS | Procedure exits |  |
| UNIQUE_OPERANDS | Number of unique operands | |
| SIZE | Size of the file in bytes | |
| OPERANDS | Number of operands | |
| PROGRAM_VOCAB | Halstead program vocabulary | |
| PROGRAM_LENGTH | Halstead program length | |
| OPERATORS | Number of operators | |
| LOGICAL_LINES | Number of statements | |
| LOC | Lines of code | |
| JAVA0081 | JAVA0081 Boolean literal in comparison | |
| ELOC | Effective lines of code | |
| LINES | Number of lines in the source file | |
| JAVA0130 | JAVA0130 Non-static method does not use instance fields | |
| BLOCKS | Number of blocks | |
| DECL_COMMENTS | Comments in declarations | |
| CYCLOMATIC | Cyclomatic complexity | |
| FUNCTIONS | Number of function declarations | |
| JAVA0008 | JAVA0008 Empty catch block | |
| JAVA0110 | JAVA0110 Incorrect javadoc: no @return tag | |
| INTERFACE_COMPLEXITY | Interface complexity | |
| JAVA0020 | JAVA0020 Field name does not have required form | |
| RETURNS | Number of return points from functions | |
| PARAMS | Number of formal parameter declarations | |
| JAVA0034 | JAVA0034 Missing braces in if statement | |
| JAVA0108 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0117 | JAVA0117 Missing javadoc: method 'method' | |
| JAVA0166 | JAVA0166 Generic exception caught | |
| UNIQUE_OPERATORS | Number of unique operators | |
| PROGRAM_VOLUME | Halstead program volume | |
| JAVA0136 | JAVA0136 N methods defined in class (maximum: M) | |
| JAVA0116 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0126 | JAVA0126 Method declares unchecked exception in throws | |
| JAVA0109 | JAVA0109 Incorrect javadoc: no parameter 'parameter' | |
| JAVA0254 | JAVA0254 Use enhanced for loop construct instead of Iterator | |
| LINE_COMMENT | Number of line comments | |
| WHITESPACE | Number of whitespace lines | |
| JAVA0068 | JAVA0068 Modifiers not declared in recommended order | |
| JAVA0145 | JAVA0145 Tab character used in source file | |
package net.sourceforge.squirrel_sql.plugins.oracle;
/*
* Copyright (C) 2002-2003 Colin Bell
* colbell@users.sourceforge.net
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library 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
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
import java.io.File;
import java.io.IOException;
import java.sql.Driver;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Hashtable;
import java.util.Iterator;
import javax.swing.SwingUtilities;
import net.sourceforge.squirrel_sql.client.IApplication;
import net.sourceforge.squirrel_sql.client.action.ActionCollection;
import net.sourceforge.squirrel_sql.client.gui.db.ISQLAliasExt;
import net.sourceforge.squirrel_sql.client.gui.db.SQLAlias;
import net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.IAliasPropertiesPanelController;
import net.sourceforge.squirrel_sql.client.gui.session.ObjectTreeInternalFrame;
import net.sourceforge.squirrel_sql.client.gui.session.SQLInternalFrame;
import net.sourceforge.squirrel_sql.client.plugin.DefaultSessionPlugin;
import net.sourceforge.squirrel_sql.client.plugin.PluginException;
import net.sourceforge.squirrel_sql.client.plugin.PluginQueryTokenizerPreferencesManager;
import net.sourceforge.squirrel_sql.client.plugin.PluginResources;
import net.sourceforge.squirrel_sql.client.plugin.PluginSessionCallback;
import net.sourceforge.squirrel_sql.client.plugin.gui.PluginGlobalPreferencesTab;
import net.sourceforge.squirrel_sql.client.plugin.gui.PluginQueryTokenizerPreferencesPanel;
import net.sourceforge.squirrel_sql.client.preferences.IGlobalPreferencesPanel;
import net.sourceforge.squirrel_sql.client.session.IAllowedSchemaChecker;
import net.sourceforge.squirrel_sql.client.session.IObjectTreeAPI;
import net.sourceforge.squirrel_sql.client.session.ISQLPanelAPI;
import net.sourceforge.squirrel_sql.client.session.ISession;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.INodeExpander;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.DatabaseObjectInfoTab;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.IObjectTab;
import net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponentFactory;
import net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DTProperties;
import net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DataTypeTimestamp;
import net.sourceforge.squirrel_sql.fw.dialects.DialectFactory;
import net.sourceforge.squirrel_sql.fw.gui.GUIUtils;
import net.sourceforge.squirrel_sql.fw.id.IIdentifier;
import net.sourceforge.squirrel_sql.fw.preferences.IQueryTokenizerPreferenceBean;
import net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType;
import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection;
import net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData;
import net.sourceforge.squirrel_sql.fw.util.StringManager;
import net.sourceforge.squirrel_sql.fw.util.StringManagerFactory;
import net.sourceforge.squirrel_sql.fw.util.Utilities;
import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;
import net.sourceforge.squirrel_sql.fw.xml.XMLBeanReader;
import net.sourceforge.squirrel_sql.fw.xml.XMLBeanWriter;
import net.sourceforge.squirrel_sql.plugins.oracle.SGAtrace.NewSGATraceWorksheetAction;
import net.sourceforge.squirrel_sql.plugins.oracle.dboutput.NewDBOutputWorksheetAction;
import net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.DefaultDatabaseExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.InstanceParentExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.OracleTableParentExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.PackageExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.ProcedureExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.SchemaExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.SessionParentExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.TableExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.TriggerParentExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.expander.UserParentExpander;
import net.sourceforge.squirrel_sql.plugins.oracle.explainplan.ExplainPlanExecuter;
import net.sourceforge.squirrel_sql.plugins.oracle.invalidobjects.NewInvalidObjectsWorksheetAction;
import net.sourceforge.squirrel_sql.plugins.oracle.prefs.OraclePluginPreferencesPanel;
import net.sourceforge.squirrel_sql.plugins.oracle.prefs.OraclePreferenceBean;
import net.sourceforge.squirrel_sql.plugins.oracle.sessioninfo.NewSessionInfoWorksheetAction;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.IndexColumnInfoTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.IndexDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.InstanceDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.ObjectSourceTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.OptionsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.SequenceDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.SessionDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.SessionStatisticsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.SnapshotSourceTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.TriggerColumnInfoTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.TriggerDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.TriggerSourceTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.UserDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.ViewSourceTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tokenizer.OracleQueryTokenizer;
import net.sourceforge.squirrel_sql.plugins.oracle.types.OracleXmlTypeDataTypeComponentFactory;
/**
* Oracle plugin class.
*
* @author <A HREF="mailto:colbell@users.sourceforge.net">Colin Bell</A>
*/
public class OraclePlugin extends DefaultSessionPlugin
{
/**
* Logger for this class.
*/
private final static ILogger s_log = LoggerController.createLogger(OraclePlugin.class);
/**
* Internationalized strings for this class.
*/
private static final StringManager s_stringMgr =
StringManagerFactory.getStringManager(OraclePlugin.class);
private PluginResources _resources;
/**
* A list of Oracle sessions that are open so we'll know when none are left
*/
private ArrayList<ISession> oracleSessions = new ArrayList<ISession>();
/**
* SQL to find schemas to which the logged in user has access
*/
private static String SCHEMA_ACCESS_SQL =
"SELECT DISTINCT OWNER FROM ALL_OBJECTS";
/**
* SQL to determine whether or not this account is a DBA account
*/
private static String DBA_ROLE_SQL =
"SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS";
private static final String ORACLE_ALIAS_PREFS_FILE = "oracleAliasPrefs.xml";
private Hashtable<IIdentifier, OracleAliasPrefs> _oracleAliasPrefsByAliasIdentifier =
new Hashtable<IIdentifier, OracleAliasPrefs>();
/** manages our query tokenizing preferences */
private PluginQueryTokenizerPreferencesManager _prefsManager = null;
interface i18n {
// i18n[OraclePlugin.title=Oracle]
String title = s_stringMgr.getString("OraclePlugin.title");
// i18n[OraclePlugin.hint=Preferences for Oracle]
String hint = s_stringMgr.getString("OraclePlugin.hint");
//i18n[OraclePlugin.timestampWarning=The setting to use string literals
//for timestamps may result in the inability to edit tables containing
//these columns. If this problem occurs, open
//Global Preferences -> Data Type Controls and set Timestamps to use
// "JDBC standard escape format"]
String timestampWarning =
s_stringMgr.getString("OraclePlugin.timestampWarning");
}
/**
* Return the internal name of this plugin.
*
* @return the internal name of this plugin.
*/
public String getInternalName()
{
return "oracle";
}
/**
* Return the descriptive name of this plugin.
*
* @return the descriptive name of this plugin.
*/
public String getDescriptiveName()
{
return "Oracle Plugin";
}
/**
* Returns the current version of this plugin.
*
* @return the current version of this plugin.
*/
public String getVersion()
{
return "0.20";
}
/**
* Returns the authors name.
*
* @return the authors name.
*/
public String getAuthor()
{
return "Colin Bell";
}
/**
* Returns a comma separated list of other contributors.
*
* @return Contributors names.
*/
public String getContributors()
{
return "Alexander Buloichik, Rob Manning";
}
/**
* @see net.sourceforge.squirrel_sql.client.plugin.IPlugin#getChangeLogFileName()
*/
public String getChangeLogFileName()
{
return "changes.txt";
}
/**
* @see net.sourceforge.squirrel_sql.client.plugin.IPlugin#getHelpFileName()
*/
public String getHelpFileName()
{
return "readme.html";
}
/**
* @see net.sourceforge.squirrel_sql.client.plugin.IPlugin#getLicenceFileName()
*/
public String getLicenceFileName()
{
return "licence.txt";
}
/**
* Create panel for the Global Properties dialog.
*
* @return properties panel.
*/
public IGlobalPreferencesPanel[] getGlobalPreferencePanels() {
PluginQueryTokenizerPreferencesPanel _prefsPanel =
new OraclePluginPreferencesPanel(_prefsManager);
PluginGlobalPreferencesTab tab = new PluginGlobalPreferencesTab(_prefsPanel);
tab.setHint(i18n.hint);
tab.setTitle(i18n.title);
return new IGlobalPreferencesPanel[] { tab };
}
public void initialize() throws PluginException
{
try
{
super.initialize();
final IApplication app = getApplication();
_resources = new OracleResources(
"net.sourceforge.squirrel_sql.plugins.oracle.oracle",
this);
ActionCollection coll = app.getActionCollection();
coll.add(new NewDBOutputWorksheetAction(app, _resources));
coll.add(new NewInvalidObjectsWorksheetAction(app, _resources));
coll.add(new NewSessionInfoWorksheetAction(app, _resources));
coll.add(new NewSGATraceWorksheetAction(app, _resources));
app.getSessionManager().addAllowedSchemaChecker(new IAllowedSchemaChecker()
{
public String[] getAllowedSchemas(ISQLConnection con, ISQLAliasExt alias)
{
return onGetAllowedSchemas(con, alias);
}
});
File f = getGlobalPrefsFile();
if(f.exists())
{
XMLBeanReader xbr = new XMLBeanReader();
xbr.load(f, getClass().getClassLoader());
for(Iterator<Object> i=xbr.iterator(); i.hasNext();)
{
OracleAliasPrefs buf = (OracleAliasPrefs) i.next();
_oracleAliasPrefsByAliasIdentifier.put(buf.getAliasIdentifier(), buf);
}
}
else
{
_oracleAliasPrefsByAliasIdentifier =
new Hashtable<IIdentifier, OracleAliasPrefs>();
}
_prefsManager = new PluginQueryTokenizerPreferencesManager();
_prefsManager.initialize(this, new OraclePreferenceBean());
/* Register custom DataTypeComponent factory for Oracles XMLType */
CellComponentFactory.registerDataTypeFactory(
new OracleXmlTypeDataTypeComponentFactory() , 2007,
"SYS.XMLTYPE");
}
catch (Exception e)
{
throw new RuntimeException(e);
}
}
public void load(IApplication app) throws PluginException
{
super.load(app);
}
private File getGlobalPrefsFile()
throws IOException
{
return new File(getPluginUserSettingsFolder().getPath() + File.separator + ORACLE_ALIAS_PREFS_FILE);
}
public void unload()
{
try
{
File f = getGlobalPrefsFile();
XMLBeanWriter xbw = new XMLBeanWriter();
Collection<OracleAliasPrefs> set =
_oracleAliasPrefsByAliasIdentifier.values();
if (set.size() > 0) {
xbw.addIteratorToRoot(set.iterator());
}
xbw.save(f);
}
catch (Exception e)
{
throw new RuntimeException(e);
}
}
/**
* Create Alias prefs panel.
*/
public IAliasPropertiesPanelController[] getAliasPropertiesPanelControllers(SQLAlias alias)
{
if(false == isOracle(alias))
{
return new IAliasPropertiesPanelController[0];
}
OracleAliasPrefs aliasPrefs =
_oracleAliasPrefsByAliasIdentifier.get(alias.getIdentifier());
if (null == aliasPrefs)
{
aliasPrefs = new OracleAliasPrefs();
aliasPrefs.setAliasIdentifier(alias.getIdentifier());
_oracleAliasPrefsByAliasIdentifier.put(alias.getIdentifier(), aliasPrefs);
}
return new OracleAliasPrefsPanelController[]{new OracleAliasPrefsPanelController(aliasPrefs)};
}
public void aliasCopied(SQLAlias source, SQLAlias target)
{
if(false == isOracle(source) || false == isOracle(target))
{
return;
}
OracleAliasPrefs sourcePrefs =
_oracleAliasPrefsByAliasIdentifier.get(source.getIdentifier());
if(null != sourcePrefs)
{
OracleAliasPrefs targetPrefs = (OracleAliasPrefs) Utilities.cloneObject(sourcePrefs, getClass().getClassLoader());
targetPrefs.setAliasIdentifier(target.getIdentifier());
_oracleAliasPrefsByAliasIdentifier.put(targetPrefs.getAliasIdentifier(), targetPrefs);
}
}
public void aliasRemoved(SQLAlias alias)
{
_oracleAliasPrefsByAliasIdentifier.remove(alias.getIdentifier());
}
/**
* Called when a session shutdown.
*
* @param session The session that is ending.
*/
public void sessionEnding(ISession session)
{
super.sessionEnding(session);
oracleSessions.remove(session);
}
public PluginSessionCallback sessionStarted(final ISession session)
{
if (!isOracle(session))
{
return null;
}
IQueryTokenizerPreferenceBean prefs = _prefsManager.getPreferences();
if (prefs.isInstallCustomQueryTokenizer()) {
session.setQueryTokenizer(new OracleQueryTokenizer(prefs));
}
if (((OraclePreferenceBean)prefs).isShowErrorOffset()) {
OracleExceptionFormatter formatter = new OracleExceptionFormatter();
formatter.setSession(session);
session.setExceptionFormatter(formatter);
}
GUIUtils.processOnSwingEventThread(new Runnable()
{
public void run()
{
addActions(session);
}
});
oracleSessions.add(session);
checkTimestampSetting(session);
PluginSessionCallback ret = new PluginSessionCallback()
{
public void sqlInternalFrameOpened(SQLInternalFrame sqlInternalFrame, ISession sess)
{
onSQLInternaFrameOpened(sqlInternalFrame, sess);
}
public void objectTreeInternalFrameOpened(ObjectTreeInternalFrame objectTreeInternalFrame, ISession sess)
{
onObjectTreeInternalFrameOpened(objectTreeInternalFrame);
}
};
SwingUtilities.invokeLater(new Runnable()
{
public void run()
{
ISQLPanelAPI sqlPaneAPI = session.getSessionSheet().getSQLPaneAPI();
sqlPaneAPI.addExecutor(new ExplainPlanExecuter(session, sqlPaneAPI));
updateObjectTree(session.getSessionSheet().getObjectTreePanel());
}
});
return ret;
}
/**
* This will check the setting for using timestamps in where clauses and
* display a warning message to the user if string literal - which is known
* not to work correctly in Oracle - is set to be used.
*/
private void checkTimestampSetting(ISession session) {
String tsClassName = DataTypeTimestamp.class.getName();
String timeStampWhereClauseUsage =
DTProperties.get(tsClassName, DataTypeTimestamp.WHERE_CLAUSE_USAGE_KEY);
if (timeStampWhereClauseUsage != null) {
int timeStampWhereClauseUsageInt = Integer.parseInt(timeStampWhereClauseUsage);
if (DataTypeTimestamp.USE_STRING_FORMAT == timeStampWhereClauseUsageInt) {
session.showWarningMessage(i18n.timestampWarning);
s_log.warn(i18n.timestampWarning);
}
}
}
@Override
protected boolean isPluginSession(ISession session) {
return DialectFactory.isOracle(session.getMetaData());
}
private void addActions(ISession session)
{
ActionCollection coll = getApplication().getActionCollection();
session.addSeparatorToToolbar();
session.addToToolbar(coll.get(NewDBOutputWorksheetAction.class));
session.addToToolbar(coll.get(NewInvalidObjectsWorksheetAction.class));
session.addToToolbar(coll.get(NewSessionInfoWorksheetAction.class));
session.addToToolbar(coll.get(NewSGATraceWorksheetAction.class));
session.getSessionInternalFrame().addToToolsPopUp("oracleoutput", coll.get(NewDBOutputWorksheetAction.class));
session.getSessionInternalFrame().addToToolsPopUp("oracleinvalid", coll.get(NewInvalidObjectsWorksheetAction.class));
session.getSessionInternalFrame().addToToolsPopUp("oracleinfo", coll.get(NewSessionInfoWorksheetAction.class));
session.getSessionInternalFrame().addToToolsPopUp("oraclesga", coll.get(NewSGATraceWorksheetAction.class));
}
private void onSQLInternaFrameOpened(SQLInternalFrame sqlInternalFrame, final ISession session)
{
final ISQLPanelAPI panel = sqlInternalFrame.getSQLPanelAPI();
panel.addExecutor(new ExplainPlanExecuter(session, panel));
}
private void onObjectTreeInternalFrameOpened(ObjectTreeInternalFrame objectTreeInternalFrame)
{
final IObjectTreeAPI objTree = objectTreeInternalFrame.getObjectTreeAPI();
updateObjectTree(objTree);
}
/**
* Return a node expander for the object tree for a particular default node type.
* <p/> A plugin could return non null here if they wish to override the default node
* expander bahaviour. Most plugins should return null here.
*/
public INodeExpander getDefaultNodeExpander(ISession session, DatabaseObjectType type) {
boolean isOracle = isOracle(session.getAlias());
boolean isOracleWithFlashBack = isOracleWithFlashBack(session);
if ((type == DatabaseObjectType.PROC_TYPE_DBO) && isOracle) {
return new ProcedureExpander();
}
if (type == DatabaseObjectType.DATABASE_TYPE_DBO && isOracle) {
return new DefaultDatabaseExpander(session);
}
if (type == DatabaseObjectType.TABLE_TYPE_DBO && isOracleWithFlashBack) {
OraclePreferenceBean prefs =
(OraclePreferenceBean)_prefsManager.getPreferences();
return new OracleTableParentExpander(prefs);
}
return null;
}
private boolean isOracleWithFlashBack(ISession session) {
boolean result = false;
if (DialectFactory.isOracle(session.getMetaData())) {
// Not all Oracle's, just 10g and above.
try {
int version =
session.getMetaData().getDatabaseMajorVersion();
if (version >= 10) {
result = true;
}
} catch (SQLException e) {
s_log.error("Unexpected exception while attempting to get " +
"the database version", e);
}
}
return result;
}
private boolean isOracle(ISession session) {
boolean result = false;
if (DialectFactory.isOracle(session.getMetaData())) {
result = true;
}
return result;
}
private boolean isOracle(ISQLAliasExt alias)
{
IIdentifier driverIdentifier = alias.getDriverIdentifier();
Driver jdbcDriver = getApplication().getSQLDriverManager().getJDBCDriver(driverIdentifier);
if(null == jdbcDriver)
{
return false;
}
return jdbcDriver.getClass().getName().startsWith("oracle.");
}
private String[] onGetAllowedSchemas(ISQLConnection con, ISQLAliasExt alias)
{
if(isOracle(alias))
{
OracleAliasPrefs prefs =
_oracleAliasPrefsByAliasIdentifier.get(alias.getIdentifier());
if(null == prefs)
{
prefs = new OracleAliasPrefs();
prefs.setAliasIdentifier(alias.getIdentifier());
_oracleAliasPrefsByAliasIdentifier.put(prefs.getAliasIdentifier(), prefs);
}
return getAccessibleSchemas(prefs, con);
}
else
{
return null;
}
}
/**
* Returns an array of schema names that represent schemas in which there
* exist tables that the user associated with the specified session has
* privilege to access.
*
* @param session the session to retrieve schemas for
* @param con
* @return an array of strings representing the names of accessible schemas
*/
private String[] getAccessibleSchemas(OracleAliasPrefs aliasPrefs, ISQLConnection con)
{
String[] result = null;
ResultSet rs = null;
Statement stmt = null;
SQLDatabaseMetaData md = con.getSQLMetaData();
String currentUserName = null;
try
{
if (hasSystemPrivilege(con) || aliasPrefs.isLoadAllSchemas())
{
result = md.getSchemas();
}
else
{
currentUserName = md.getUserName();
stmt = con.getConnection().createStatement();
rs = stmt.executeQuery(SCHEMA_ACCESS_SQL);
ArrayList<String> tmp = new ArrayList<String>();
while (rs.next())
{
tmp.add(rs.getString(1));
}
if (currentUserName != null && !tmp.contains(currentUserName))
{
tmp.add(currentUserName);
}
tmp.remove("SYS");
if(aliasPrefs.isLoadAccessibleSchemasAndSYS())
{
tmp.add("SYS");
}
result = tmp.toArray(new String[tmp.size()]);
}
}
catch (SQLException e)
{
// i18n[DefaultDatabaseExpander.error.retrieveschemaprivs=Unable to retrieve schema privileges]
String msg = s_stringMgr.getString("DefaultDatabaseExpander.error.retrieveschemaprivs");
s_log.error(msg, e);
}
finally
{
if (rs != null) try
{
rs.close();
}
catch (SQLException e)
{
}
if (stmt != null) try
{
stmt.close();
}
catch (SQLException e)
{
}
}
return result;
}
/**
* Checks whether or not the user associated with the specified session has
* been granted the DBA privilege.
*
* @param session the session to check
* @return true if the user has the DBA privilege; false otherwise.
*/
private boolean hasSystemPrivilege(ISQLConnection con)
{
boolean result = false;
Statement stmt = null;
ResultSet rs = null;
try
{
stmt = con.createStatement();
rs = stmt.executeQuery(DBA_ROLE_SQL);
while (rs.next())
{
String role = rs.getString(1);
if ("DBA".equalsIgnoreCase(role))
{
result = true;
break;
}
}
}
catch (SQLException e)
{
// i18n[DefaultDatabaseExpander.error.retrieveuserroles=Unable to retrieve user roles]
String msg =
s_stringMgr.getString("DefaultDatabaseExpander.error.retrieveuserroles");
s_log.error(msg, e);
}
finally
{
if (rs != null) try
{
rs.close();
}
catch (SQLException e)
{
}
if (stmt != null) try
{
stmt.close();
}
catch (SQLException e)
{
}
}
return result;
}
/**
* Check if we can run query.
*
* @param session session
* @param query query text
* @return true if query works fine
*/
public static boolean checkObjectAccessible(final ISession session, final String query)
{
PreparedStatement pstmt = null;
ResultSet rs = null;
try
{
pstmt = session.getSQLConnection().prepareStatement(query);
rs = pstmt.executeQuery();
return true;
}
catch (SQLException ex)
{
return false;
}
finally
{
try
{
if (rs != null)
{
rs.close();
}
if (pstmt != null)
{
pstmt.close();
}
}
catch (SQLException ex)
{
}
}
}
private void updateObjectTree(final IObjectTreeAPI objTree) {
ISession session = objTree.getSession();
addDetailTab(objTree, DatabaseObjectType.SESSION, new OptionsTab());
addDetailTab(objTree, IObjectTypes.CONSUMER_GROUP, new DatabaseObjectInfoTab());
addDetailTab(objTree, DatabaseObjectType.FUNCTION, new DatabaseObjectInfoTab());
addDetailTab(objTree, DatabaseObjectType.INDEX, new DatabaseObjectInfoTab());
addDetailTab(objTree, DatabaseObjectType.INDEX, new IndexColumnInfoTab());
addDetailTab(objTree, DatabaseObjectType.INDEX, new IndexDetailsTab());
addDetailTab(objTree, IObjectTypes.LOB, new DatabaseObjectInfoTab());
addDetailTab(objTree, DatabaseObjectType.SEQUENCE, new DatabaseObjectInfoTab());
addDetailTab(objTree, DatabaseObjectType.TRIGGER, new DatabaseObjectInfoTab());
addDetailTab(objTree, IObjectTypes.TRIGGER_PARENT, new DatabaseObjectInfoTab());
addDetailTab(objTree, IObjectTypes.TYPE, new DatabaseObjectInfoTab());
// Expanders.
addExpander(objTree, DatabaseObjectType.SCHEMA, new SchemaExpander());
addExpander(objTree, DatabaseObjectType.TABLE, new TableExpander());
addExpander(objTree, IObjectTypes.PACKAGE, new PackageExpander());
addExpander(objTree, IObjectTypes.USER_PARENT, new UserParentExpander(session));
addExpander(objTree, IObjectTypes.SESSION_PARENT, new SessionParentExpander());
addExpander(objTree, IObjectTypes.INSTANCE_PARENT, new InstanceParentExpander());
addExpander(objTree, IObjectTypes.TRIGGER_PARENT, new TriggerParentExpander());
addDetailTab(objTree, DatabaseObjectType.PROCEDURE, new ObjectSourceTab("PROCEDURE", "Show stored procedure source"));
addDetailTab(objTree, DatabaseObjectType.FUNCTION, new ObjectSourceTab("FUNCTION", "Show function source"));
addDetailTab(objTree, IObjectTypes.PACKAGE, new ObjectSourceTab("PACKAGE", "Specification", "Show package specification"));
addDetailTab(objTree, IObjectTypes.PACKAGE, new ObjectSourceTab("PACKAGE BODY", "Body", "Show package body"));
addDetailTab(objTree, IObjectTypes.TYPE, new ObjectSourceTab("TYPE", "Specification", "Show type specification"));
addDetailTab(objTree, IObjectTypes.TYPE, new ObjectSourceTab("TYPE BODY", "Body", "Show type body"));
addDetailTab(objTree, IObjectTypes.INSTANCE, new InstanceDetailsTab());
addDetailTab(objTree, DatabaseObjectType.SEQUENCE, new SequenceDetailsTab());
addDetailTab(objTree, IObjectTypes.SESSION, new SessionDetailsTab());
addDetailTab(objTree, IObjectTypes.SESSION, new SessionStatisticsTab());
addDetailTab(objTree, DatabaseObjectType.TRIGGER, new TriggerDetailsTab());
addDetailTab(objTree, DatabaseObjectType.TRIGGER, new TriggerSourceTab());
addDetailTab(objTree, DatabaseObjectType.TRIGGER, new TriggerColumnInfoTab());
addDetailTab(objTree, DatabaseObjectType.USER, new UserDetailsTab(session));
addDetailTab(objTree, DatabaseObjectType.VIEW, new ViewSourceTab());
addDetailTab(objTree, DatabaseObjectType.TABLE, new SnapshotSourceTab());
// This fixes the issue where the tree is getting constructed prior to
// the Oracle plugin expanders being registered.(USERS, SESSIONS,
// INSTANCES nodes have no children until the tree is refreshed). Even
// though this is a hack, it doesn't seem to negatively impact
// performance even when loading all schemas.
GUIUtils.processOnSwingEventThread(new Runnable() {
public void run() {
objTree.refreshTree();
}
});
}
private void addExpander(final IObjectTreeAPI objTree,
final DatabaseObjectType dboType,
final INodeExpander exp)
{
objTree.addExpander(dboType, exp);
}
private void addDetailTab(final IObjectTreeAPI objTree,
final DatabaseObjectType dboType,
final IObjectTab tab)
{
objTree.addDetailTab(dboType, tab);
}
}
The table below shows all metrics for OraclePlugin.java.
| Metric | Value | Description | |
|---|---|---|---|
| BLOCKS | 97.00 | Number of blocks | |
| BLOCK_COMMENT | 19.00 | Number of block comment lines | |
| COMMENTS | 136.00 | Comment lines | |
| COMMENT_DENSITY | 0.32 | Comment density | |
| COMPARISONS | 37.00 | Number of comparison operators | |
| CYCLOMATIC | 90.00 | Cyclomatic complexity | |
| DECL_COMMENTS | 27.00 | Comments in declarations | |
| DOC_COMMENT | 101.00 | Number of javadoc comment lines | |
| ELOC | 426.00 | Effective lines of code | |
| EXEC_COMMENTS | 6.00 | Comments in executable code | |
| EXITS | 113.00 | Procedure exits | |
| FUNCTIONS | 40.00 | Number of function declarations | |
| HALSTEAD_DIFFICULTY | 81.79 | Halstead difficulty | |
| HALSTEAD_EFFORT | 0.00 | Halstead effort | |
| INTERFACE_COMPLEXITY | 90.00 | Interface complexity | |
| JAVA0001 | 1.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 | 5.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 | 3.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 | 4.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 | 1.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 | 1.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 | 0.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 | 3.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 | 3.00 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0109 | 2.00 | JAVA0109 Incorrect javadoc: no parameter 'parameter' | |
| JAVA0110 | 5.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 | 1.00 | JAVA0114 Incorrect javadoc: no @version tag | |
| JAVA0115 | 0.00 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| JAVA0116 | 3.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 | 7.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 | 1.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 | 4.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 | 0.00 | JAVA0163 Empty statement | |
| JAVA0165 | 0.00 | JAVA0165 Conflicting return statement in finally block | |
| JAVA0166 | 2.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 | 0.00 | JAVA0173 Unused method parameter | |
| JAVA0174 | 0.00 | JAVA0174 Assigned local variable never used | |
| JAVA0175 | 0.00 | JAVA0175 Successive assignment to variable | |
| JAVA0176 | 1.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 | 1.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 | 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 | 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 | 848.00 | Number of lines in the source file | |
| LINE_COMMENT | 16.00 | Number of line comments | |
| LOC | 605.00 | Lines of code | |
| LOGICAL_LINES | 298.00 | Number of statements | |
| LOOPS | 3.00 | Number of loops | |
| NEST_DEPTH | 4.00 | Maximum nesting depth | |
| OPERANDS | 1541.00 | Number of operands | |
| OPERATORS | 2600.00 | Number of operators | |
| PARAMS | 38.00 | Number of formal parameter declarations | |
| PROGRAM_LENGTH | 4141.00 | Halstead program length | |
| PROGRAM_VOCAB | 521.00 | Halstead program vocabulary | |
| PROGRAM_VOLUME | 0.00 | Halstead program volume | |
| RETURNS | 52.00 | Number of return points from functions | |
| SIZE | 30574.00 | Size of the file in bytes | |
| UNIQUE_OPERANDS | 471.00 | Number of unique operands | |
| UNIQUE_OPERATORS | 50.00 | Number of unique operators | |
| WHITESPACE | 107.00 | Number of whitespace lines | |