/*
// $Id: //open/mondrian-release/3.2.2/src/main/mondrian/gui/Workbench.java#3 $
// This software is subject to the terms of the Eclipse Public License v1.0
// Agreement, available at the following URL:
// http://www.eclipse.org/legal/epl-v10.html.
// Copyright (C) 1999-2002 Kana Software, Inc.
// Copyright (C) 2001-2010 Julian Hyde and others
// Copyright (C) 2006-2007 Cincom Systems, Inc.
// Copyright (C) 2006-2007 JasperSoft
// All Rights Reserved.
// You must accept the terms of that agreement to use this software.
//
// Created on September 26, 2002, 11:28 AM
// Modified on 15-Jun-2003 by ebengtso
//
*/
package mondrian.gui;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusAdapter;
import java.awt.event.FocusEvent;
import java.awt.event.KeyEvent;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.net.MalformedURLException;
import java.net.URI;
import java.net.URISyntaxException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.MissingResourceException;
import java.util.Properties;
import java.util.ResourceBundle;
import javax.swing.ImageIcon;
import javax.swing.JCheckBoxMenuItem;
import javax.swing.JEditorPane;
import javax.swing.JFileChooser;
import javax.swing.JInternalFrame;
import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPopupMenu;
import javax.swing.JScrollPane;
import javax.swing.SwingConstants;
import javax.swing.event.InternalFrameAdapter;
import javax.swing.event.InternalFrameEvent;
import javax.swing.filechooser.FileSystemView;
import javax.swing.plaf.basic.BasicArrowButton;
import javax.swing.text.DefaultEditorKit;
import mondrian.olap.DriverManager;
import mondrian.olap.MondrianProperties;
import mondrian.olap.Util.PropertyList;
import mondrian.rolap.agg.AggregationManager;
import mondrian.util.UnionIterator;
import org.apache.commons.io.FileUtils;
import org.apache.log4j.Logger;
import org.eigenbase.xom.XMLOutput;
import org.pentaho.di.core.Const;
import org.pentaho.di.core.KettleEnvironment;
import org.pentaho.di.core.database.DatabaseMeta;
import org.pentaho.di.core.exception.KettleDatabaseException;
import org.pentaho.di.core.exception.KettleException;
import org.pentaho.ui.database.DatabaseConnectionDialog;
import org.pentaho.ui.database.Messages;
import org.pentaho.ui.database.event.DataHandler;
import org.pentaho.ui.xul.XulDomContainer;
import org.pentaho.ui.xul.XulException;
import org.pentaho.ui.xul.XulLoader;
import org.pentaho.ui.xul.containers.XulDialog;
import org.pentaho.ui.xul.swing.SwingXulLoader;
/**
* @author sean
* @version $Id: //open/mondrian-release/3.2.2/src/main/mondrian/gui/Workbench.java#3 $
*/
public class Workbench extends javax.swing.JFrame {
static String WORKBENCH_USER_HOME_DIR;
static String WORKBENCH_CONFIG_FILE;
static String DB_META_CONFIG_FILE;
private static final String LAST_USED1 = "lastUsed1";
private static final String LAST_USED1_URL = "lastUsedUrl1";
private static final String LAST_USED2 = "lastUsed2";
private static final String LAST_USED2_URL = "lastUsedUrl2";
private static final String LAST_USED3 = "lastUsed3";
private static final String LAST_USED3_URL = "lastUsedUrl3";
private static final String LAST_USED4 = "lastUsed4";
private static final String LAST_USED4_URL = "lastUsedUrl4";
private static final String WorkbenchInfoResourceName =
"mondrian.gui.resources.workbenchInfo";
private static final String GUIResourceName = "mondrian.gui.resources.gui";
private static final String TextResourceName =
"mondrian.gui.resources.text";
private static final String FILTER_SCHEMA_LIST = "FILTER_SCHEMA_LIST";
private static final Logger LOGGER = Logger.getLogger(Workbench.class);
private String jdbcDriverClassName;
private String jdbcConnectionUrl;
private String jdbcUsername;
private String jdbcPassword;
private String jdbcSchema;
private boolean requireSchema;
private JdbcMetaData jdbcMetaData;
private final ClassLoader myClassLoader;
private Properties workbenchProperties;
private static ResourceBundle workbenchResourceBundle = null;
private static I18n resourceConverter = null;
private static int newSchema = 1;
private String openFile = null;
private Map<JInternalFrame, JMenuItem> schemaWindowMap =
new HashMap<JInternalFrame, JMenuItem>();
private final List<JInternalFrame> mdxWindows =
new ArrayList<JInternalFrame>();
private final List<JInternalFrame> jdbcWindows =
new ArrayList<JInternalFrame>();
private int windowMenuMapIndex = 1;
private static final String KETTLE_PLUGIN_BASE_FOLDERS = "kettle-plugins,"
+ Const.getKettleDirectory() + Const.FILE_SEPARATOR + "plugins";
private XulDialog connectionDialog = null;
private DataHandler connectionDialogController = null;
private DatabaseMeta dbMeta = null;
/**
* Creates new form Workbench
*/
public Workbench() {
myClassLoader = this.getClass().getClassLoader();
resourceConverter = getGlobalResourceConverter();
// Setting User home directory
WORKBENCH_USER_HOME_DIR =
System.getProperty("user.home")
+ File.separator
+ ".schemaWorkbench";
WORKBENCH_CONFIG_FILE =
WORKBENCH_USER_HOME_DIR + File.separator + "workbench.properties";
DB_META_CONFIG_FILE = WORKBENCH_USER_HOME_DIR + File.separator
+ "databaseMeta.xml";
loadWorkbenchProperties();
loadDatabaseMeta();
initOptions();
initComponents();
loadMenubarPlugins();
ImageIcon icon = new javax.swing.ImageIcon(
myClassLoader.getResource(
getResourceConverter().getGUIReference("productIcon")));
this.setIconImage(icon.getImage());
}
public static I18n getGlobalResourceConverter() {
if (resourceConverter == null) {
ClassLoader currentClassLoader;
ResourceBundle localGuiResourceBundle;
ResourceBundle localTextResourceBundle;
currentClassLoader = Workbench.class.getClassLoader();
localGuiResourceBundle = ResourceBundle.getBundle(
GUIResourceName, Locale.getDefault(), currentClassLoader);
localTextResourceBundle = ResourceBundle.getBundle(
TextResourceName, Locale.getDefault(), currentClassLoader);
resourceConverter = new I18n(
localGuiResourceBundle, localTextResourceBundle);
}
return resourceConverter;
}
/**
* load properties
*/
private void loadWorkbenchProperties() {
workbenchProperties = new Properties();
try {
workbenchResourceBundle = ResourceBundle.getBundle(
WorkbenchInfoResourceName, Locale.getDefault(),
myClassLoader);
File f = new File(WORKBENCH_CONFIG_FILE);
if (f.exists()) {
workbenchProperties.load(new FileInputStream(f));
} else {
LOGGER.debug(WORKBENCH_CONFIG_FILE + " does not exist");
}
} catch (Exception e) {
// TODO deal with exception
LOGGER.error("loadWorkbenchProperties", e);
}
}
/**
* load database meta
*/
public void loadDatabaseMeta() {
if (dbMeta == null) {
File file = new File(DB_META_CONFIG_FILE);
if (file.exists()) {
try {
dbMeta = getDbMeta(FileUtils.readFileToString(file));
} catch (Exception e) {
LOGGER.error("loadDatabaseMeta", e);
}
}
}
if (dbMeta != null) {
syncToWorkspace(dbMeta);
}
}
/**
* returns the value of a workbench property
*
* @param key key to lookup
* @return the value
*/
public String getWorkbenchProperty(String key) {
return workbenchProperties.getProperty(key);
}
/**
* set a workbench property. Note that this does not save the property,
* a call to storeWorkbenchProperties is required.
*
* @param key property key
* @param value property value
*/
public void setWorkbenchProperty(String key, String value) {
workbenchProperties.setProperty(key, value);
}
/**
* save properties
*/
public void storeWorkbenchProperties() {
//save properties to file
File dir = new File(WORKBENCH_USER_HOME_DIR);
try {
if (dir.exists()) {
if (!dir.isDirectory()) {
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.user.home.not.directory",
"{0} is not a directory!\nPlease rename this file and retry to save configuration!",
WORKBENCH_USER_HOME_DIR),
"",
JOptionPane.ERROR_MESSAGE);
return;
}
} else {
dir.mkdirs();
}
} catch (Exception ex) {
LOGGER.error("storeWorkbenchProperties: mkdirs", ex);
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.user.home.exception",
"An error is occurred creating workbench configuration directory:\n{0}\nError is: {1}",
WORKBENCH_USER_HOME_DIR,
ex.getLocalizedMessage()),
"",
JOptionPane.ERROR_MESSAGE);
return;
}
OutputStream out = null;
try {
out = (OutputStream) new FileOutputStream(
new File(
WORKBENCH_CONFIG_FILE));
workbenchProperties.store(out, "Workbench configuration");
} catch (Exception e) {
LOGGER.error("storeWorkbenchProperties: store", e);
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.save.configuration",
"An error is occurred creating workbench configuration file:\n{0}\nError is: {1}",
WORKBENCH_CONFIG_FILE,
e.getLocalizedMessage()),
"",
JOptionPane.ERROR_MESSAGE);
} finally {
try {
out.close();
} catch (IOException eIO) {
LOGGER.error("storeWorkbenchProperties: out.close", eIO);
}
}
}
/**
* save database meta
*/
public void storeDatabaseMeta() {
if (dbMeta != null) {
try {
File file = new File(DB_META_CONFIG_FILE);
PrintWriter pw = new PrintWriter(new FileWriter(file));
pw.println(dbMeta.getXML());
pw.close();
} catch (IOException e) {
LOGGER.error("storeDatabaseMeta", e);
}
}
}
/**
* Initialize the UI options
*/
private void initOptions() {
requireSchema = "true".equals(getWorkbenchProperty("requireSchema"));
}
/**
* This method is called from within the constructor to
* initialize the form.
*/
private void initComponents() {
desktopPane = new javax.swing.JDesktopPane();
jToolBar1 = new javax.swing.JToolBar();
jToolBar2 = new javax.swing.JToolBar();
toolbarNewPopupMenu = new JPopupMenu();
toolbarNewButton = new javax.swing.JButton();
toolbarOpenButton = new javax.swing.JButton();
toolbarSaveButton = new javax.swing.JButton();
toolbarSaveAsButton = new javax.swing.JButton();
jPanel1 = new javax.swing.JPanel();
jPanel2 = new javax.swing.JPanel();
toolbarPreferencesButton = new javax.swing.JButton();
requireSchemaCheckboxMenuItem = new javax.swing.JCheckBoxMenuItem();
menuBar = new javax.swing.JMenuBar();
fileMenu = new javax.swing.JMenu();
newMenu = new javax.swing.JMenu();
newSchemaMenuItem = new javax.swing.JMenuItem();
newQueryMenuItem = new javax.swing.JMenuItem();
newJDBCExplorerMenuItem = new javax.swing.JMenuItem();
newSchemaMenuItem2 = new javax.swing.JMenuItem();
newQueryMenuItem2 = new javax.swing.JMenuItem();
newJDBCExplorerMenuItem2 = new javax.swing.JMenuItem();
openMenuItem = new javax.swing.JMenuItem();
preferencesMenuItem = new javax.swing.JMenuItem();
lastUsed1MenuItem = new javax.swing.JMenuItem();
lastUsed2MenuItem = new javax.swing.JMenuItem();
lastUsed3MenuItem = new javax.swing.JMenuItem();
lastUsed4MenuItem = new javax.swing.JMenuItem();
saveMenuItem = new javax.swing.JMenuItem();
saveAsMenuItem = new javax.swing.JMenuItem();
jSeparator1 = new javax.swing.JSeparator();
jSeparator2 = new javax.swing.JSeparator();
jSeparator3 = new javax.swing.JSeparator();
jSeparator4 = new javax.swing.JSeparator();
exitMenuItem = new javax.swing.JMenuItem();
windowMenu = new javax.swing.JMenu();
helpMenu = new javax.swing.JMenu();
editMenu = new javax.swing.JMenu();
cutMenuItem =
new javax.swing.JMenuItem(new DefaultEditorKit.CutAction());
copyMenuItem =
new javax.swing.JMenuItem(new DefaultEditorKit.CopyAction());
pasteMenuItem =
new javax.swing.JMenuItem(new DefaultEditorKit.PasteAction());
deleteMenuItem = new javax.swing.JMenuItem();
aboutMenuItem = new javax.swing.JMenuItem();
toolsMenu = new javax.swing.JMenu();
viewMenu = new javax.swing.JMenu();
viewDimensionsMenuItem = new javax.swing.JCheckBoxMenuItem();
viewMeasuresMenuItem = new javax.swing.JCheckBoxMenuItem();
viewCubesMenuItem = new javax.swing.JCheckBoxMenuItem();
viewXmlMenuItem = new javax.swing.JCheckBoxMenuItem();
setTitle(
getResourceConverter().getString(
"workbench.panel.title", "Schema Workbench"));
setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
addWindowListener(
new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
storeWorkbenchProperties();
storeDatabaseMeta();
closeAllSchemaFrames(true);
}
});
getContentPane().add(desktopPane, java.awt.BorderLayout.CENTER);
newSchemaMenuItem2.setText(
getResourceConverter().getString(
"workbench.menu.newSchema", "Schema"));
newSchemaMenuItem2.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
newSchemaMenuItemActionPerformed(evt);
}
});
newQueryMenuItem2.setText(
getResourceConverter().getString(
"workbench.menu.newQuery", "MDX Query"));
newQueryMenuItem2.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
newQueryMenuItemActionPerformed(evt);
}
});
newJDBCExplorerMenuItem2.setText(
getResourceConverter().getString(
"workbench.menu.newJDBC", "JDBC Explorer"));
newJDBCExplorerMenuItem2.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
newJDBCExplorerMenuItemActionPerformed(evt);
}
});
toolbarNewPopupMenu.add(newSchemaMenuItem2);
toolbarNewPopupMenu.add(newQueryMenuItem2);
toolbarNewPopupMenu.add(newJDBCExplorerMenuItem2);
jPanel2.setLayout(new java.awt.BorderLayout());
jPanel2.setBorder(javax.swing.BorderFactory.createEtchedBorder());
jPanel2.setMaximumSize(new java.awt.Dimension(50, 28));
toolbarNewButton.setIcon(
new javax.swing.ImageIcon(
getClass().getResource(
getResourceConverter().getGUIReference("new"))));
toolbarNewButton.setToolTipText(
getResourceConverter().getString(
"workbench.toolbar.new", "New"));
toolbarNewButton.setBorderPainted(false);
toolbarNewButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
toolbarNewPopupMenu.show(
jPanel2, 0, jPanel2.getSize().height);
}
});
jToolBar2.setFloatable(false);
jToolBar2.add(toolbarNewButton);
jPanel2.add(jToolBar2, java.awt.BorderLayout.CENTER);
toolbarNewArrowButton = new BasicArrowButton(SwingConstants.SOUTH);
toolbarNewArrowButton.setToolTipText(
getResourceConverter().getString(
"workbench.toolbar.newArrow", "New"));
toolbarNewArrowButton.setBorderPainted(false);
toolbarNewArrowButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
toolbarNewPopupMenu.show(
jPanel2, 0, jPanel2.getSize().height);
}
});
jPanel2.add(toolbarNewArrowButton, java.awt.BorderLayout.EAST);
jToolBar1.add(jPanel2, 0);
toolbarOpenButton.setIcon(
new javax.swing.ImageIcon(
getClass().getResource(
getResourceConverter().getGUIReference("open"))));
toolbarOpenButton.setToolTipText(
getResourceConverter().getString(
"workbench.toolbar.open", "Open"));
toolbarOpenButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
openMenuItemActionPerformed(evt);
}
});
jToolBar1.add(toolbarOpenButton);
toolbarSaveButton.setIcon(
new javax.swing.ImageIcon(
getClass().getResource(
getResourceConverter().getGUIReference("save"))));
toolbarSaveButton.setToolTipText(
getResourceConverter().getString(
"workbench.toolbar.save", "Save"));
toolbarSaveButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
saveMenuItemActionPerformed(evt);
}
});
jToolBar1.add(toolbarSaveButton);
toolbarSaveAsButton.setIcon(
new javax.swing.ImageIcon(
getClass().getResource(
getResourceConverter().getGUIReference("saveAs"))));
toolbarSaveAsButton.setToolTipText(
getResourceConverter().getString(
"workbench.toolbar.saveAs", "Save As"));
toolbarSaveAsButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
saveAsMenuItemActionPerformed(evt);
}
});
jToolBar1.add(toolbarSaveAsButton);
jPanel1.setMaximumSize(new java.awt.Dimension(8, 8));
jToolBar1.add(jPanel1);
toolbarPreferencesButton.setIcon(
new javax.swing.ImageIcon(
getClass().getResource(
getResourceConverter().getGUIReference("preferences"))));
toolbarPreferencesButton.setToolTipText(
getResourceConverter().getString(
"workbench.toolbar.connection", "Connection"));
toolbarPreferencesButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
connectionButtonActionPerformed(evt);
}
});
jToolBar1.add(toolbarPreferencesButton);
getContentPane().add(jToolBar1, java.awt.BorderLayout.NORTH);
fileMenu.setText(
getResourceConverter().getString(
"workbench.menu.file", "File"));
fileMenu.setMnemonic(KeyEvent.VK_F);
newMenu.setText(
getResourceConverter().getString(
"workbench.menu.new", "New"));
newSchemaMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.newSchema", "Schema"));
newSchemaMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
newSchemaMenuItemActionPerformed(evt);
}
});
newMenu.add(newSchemaMenuItem);
newQueryMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.newQuery", "MDX Query"));
newQueryMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
newQueryMenuItemActionPerformed(evt);
}
});
newMenu.add(newQueryMenuItem);
newJDBCExplorerMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.newJDBC", "JDBC Explorer"));
newJDBCExplorerMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
newJDBCExplorerMenuItemActionPerformed(evt);
}
});
newMenu.add(newJDBCExplorerMenuItem);
fileMenu.add(newMenu);
openMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.open", "Open"));
openMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
openMenuItemActionPerformed(evt);
}
});
fileMenu.add(openMenuItem);
saveMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.save", "Save"));
saveMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
saveMenuItemActionPerformed(evt);
}
});
fileMenu.add(saveMenuItem);
saveAsMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.saveAsDot", "Save As ..."));
saveAsMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
saveAsMenuItemActionPerformed(evt);
}
});
fileMenu.add(saveAsMenuItem);
//add last used
fileMenu.add(jSeparator2);
lastUsed1MenuItem.setText(getWorkbenchProperty("lastUsed1"));
lastUsed1MenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
lastUsed1MenuItemActionPerformed(evt);
}
});
fileMenu.add(lastUsed1MenuItem);
lastUsed2MenuItem.setText(getWorkbenchProperty("lastUsed2"));
lastUsed2MenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
lastUsed2MenuItemActionPerformed(evt);
}
});
fileMenu.add(lastUsed2MenuItem);
lastUsed3MenuItem.setText(getWorkbenchProperty("lastUsed3"));
lastUsed3MenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
lastUsed3MenuItemActionPerformed(evt);
}
});
fileMenu.add(lastUsed3MenuItem);
lastUsed4MenuItem.setText(getWorkbenchProperty("lastUsed4"));
lastUsed4MenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
lastUsed4MenuItemActionPerformed(evt);
}
});
fileMenu.add(lastUsed4MenuItem);
updateLastUsedMenu();
fileMenu.add(jSeparator1);
exitMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.exit", "Exit"));
exitMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
exitMenuItemActionPerformed(evt);
}
});
fileMenu.add(exitMenuItem);
menuBar.add(fileMenu);
editMenu.setText(
getResourceConverter().getString(
"workbench.menu.edit", "Edit"));
editMenu.setMnemonic(KeyEvent.VK_E);
cutMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.cut", "Cut"));
editMenu.add(cutMenuItem);
copyMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.copy", "Copy"));
editMenu.add(copyMenuItem);
pasteMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.paste", "Paste"));
editMenu.add(pasteMenuItem);
deleteMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.delete", "Delete"));
editMenu.add(deleteMenuItem);
menuBar.add(editMenu);
viewMenu.setText(
getResourceConverter().getString(
"workbench.menu.view", "View"));
viewMenu.setMnemonic(KeyEvent.VK_V);
viewXmlMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.viewXML", "View XML"));
viewXmlMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
viewXMLMenuItemActionPerformed(evt);
}
});
viewMenu.add(viewXmlMenuItem);
menuBar.add(viewMenu);
toolsMenu.setText(getResourceConverter().getString(
"workbench.menu.options", "Options"));
toolsMenu.setMnemonic(KeyEvent.VK_O);
preferencesMenuItem.setText(getResourceConverter().getString(
"workbench.menu.connection", "Connection"));
preferencesMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
connectionButtonActionPerformed(evt);
}
});
toolsMenu.add(preferencesMenuItem);
requireSchemaCheckboxMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.requireSchema", "Require Schema"));
requireSchemaCheckboxMenuItem.setSelected(requireSchema);
requireSchemaCheckboxMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
requireSchemaActionPerformed(e);
}
});
toolsMenu.add(requireSchemaCheckboxMenuItem);
menuBar.add(toolsMenu);
windowMenu.setText(
getResourceConverter().getString(
"workbench.menu.windows", "Windows"));
windowMenu.setMnemonic(KeyEvent.VK_W);
cascadeMenuItem = new javax.swing.JMenuItem();
cascadeMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.cascadeWindows", "Cascade Windows"));
cascadeMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
cascadeMenuItemActionPerformed(evt);
}
});
tileMenuItem = new javax.swing.JMenuItem();
tileMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.tileWindows", "Tile Windows"));
tileMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
tileMenuItemActionPerformed(evt);
}
});
closeAllMenuItem = new javax.swing.JMenuItem();
closeAllMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.closeAll", "Close All"));
closeAllMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
closeAllMenuItemActionPerformed(evt);
}
});
minimizeMenuItem = new javax.swing.JMenuItem();
minimizeMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.minimizeAll", "Minimize All"));
minimizeMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
minimizeMenuItemActionPerformed(evt);
}
});
maximizeMenuItem = new javax.swing.JMenuItem();
maximizeMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.maximizeAll", "Maximize All"));
maximizeMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
maximizeMenuItemActionPerformed(evt);
}
});
menuBar.add(windowMenu);
aboutMenuItem.setText(
getResourceConverter().getString(
"workbench.menu.about", "About"));
aboutMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
aboutMenuItemActionPerformed(evt);
}
});
helpMenu.add(aboutMenuItem);
helpMenu.setText(
getResourceConverter().getString(
"workbench.menu.help", "Help"));
helpMenu.setMnemonic(KeyEvent.VK_H);
menuBar.add(helpMenu);
setJMenuBar(menuBar);
pack();
}
/**
* this method loads any available menubar plugins based on
*/
private void loadMenubarPlugins() {
// render any plugins
InputStream pluginStream = null;
try {
Properties props = new Properties();
pluginStream = getClass().getResourceAsStream(
"/workbench_plugins.properties");
if (pluginStream != null) {
props.load(pluginStream);
for (Object key : props.keySet()) {
String keystr = (String) key;
if (keystr.startsWith("workbench.menu-plugin")) {
String val = props.getProperty(keystr);
WorkbenchMenubarPlugin plugin =
(WorkbenchMenubarPlugin) Class.forName(val)
.newInstance();
plugin.setWorkbench(this);
plugin.addItemsToMenubar(menuBar);
}
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (pluginStream != null) {
pluginStream.close();
}
} catch (Exception e) {
}
}
}
/**
* @return the workbenchResourceBundle
*/
public ResourceBundle getWorkbenchResourceBundle() {
return workbenchResourceBundle;
}
/**
* @return the resourceConverter
*/
public I18n getResourceConverter() {
if (resourceConverter == null) {
resourceConverter = getGlobalResourceConverter();
}
return resourceConverter;
}
private void tileMenuItemActionPerformed(ActionEvent evt) {
final Dimension dsize = desktopPane.getSize();
final int desktopW = (int) dsize.getWidth();
final int desktopH = (int) dsize.getHeight();
final int darea = (int) (desktopW * desktopH);
final double eacharea =
darea
/ (schemaWindowMap.size() + mdxWindows.size() + jdbcWindows.size());
final int wh = (int) Math.sqrt(eacharea);
try {
int x = 0, y = 0;
for (JInternalFrame sf : getAllFrames()) {
if (sf != null && !sf.isIcon()) {
sf.setMaximum(false);
sf.moveToFront();
if (x >= desktopW
|| (desktopW - x) * wh < eacharea / 2)
{
// move to next row of windows
y += wh;
x = 0;
}
int sfwidth = ((x + wh) < desktopW
? wh
: desktopW - x);
int sfheight = ((y + wh) < desktopH
? wh
: desktopH - y);
sf.setBounds(x, y, sfwidth, sfheight);
x += sfwidth;
}
}
} catch (Exception ex) {
LOGGER.error("tileMenuItemActionPerformed", ex);
//do nothing
}
}
// cascade all the indows open in schema workbench
private void cascadeMenuItemActionPerformed(
ActionEvent evt)
{
try {
int sfi = 1;
for (JInternalFrame sf : getAllFrames()) {
if (sf != null && !sf.isIcon()) {
sf.setMaximum(false);
sf.setLocation(30 * sfi, 30 * sfi);
sf.moveToFront();
sf.setSelected(true);
sfi++;
}
}
} catch (Exception ex) {
LOGGER.error("cascadeMenuItemActionPerformed", ex);
//do nothing
}
}
// close all the windows open in schema workbench
private void closeAllMenuItemActionPerformed(ActionEvent evt) {
closeAllSchemaFrames(false);
}
private void closeAllSchemaFrames(boolean exitAfterClose) {
try {
for (JInternalFrame sf : getAllFrames()) {
if (sf == null) {
continue;
}
if (sf.getContentPane().getComponent(0)
instanceof SchemaExplorer)
{
SchemaExplorer se =
(SchemaExplorer) sf.getContentPane().getComponent(0);
sf.setSelected(true);
int response = confirmFrameClose(sf, se);
switch (response) {
case 2:
// cancel
return;
case 3:
// not dirty
sf.setClosed(true);
break;
}
} else {
sf.setClosed(true);
}
}
// exit Schema Workbench if no files are open
if (((schemaWindowMap.keySet().size()) == 0) && exitAfterClose) {
System.exit(0);
}
} catch (Exception ex) {
LOGGER.error("closeAllSchemaFrames", ex);
}
}
private int confirmFrameClose(
JInternalFrame schemaFrame,
SchemaExplorer se)
{
if (se.isDirty()) {
JMenuItem schemaMenuItem = (JMenuItem) schemaWindowMap.get(
desktopPane.getSelectedFrame());
// yes=0; no=1; cancel=2
int answer = JOptionPane.showConfirmDialog(
null,
getResourceConverter().getFormattedString(
"workbench.saveSchemaOnClose.alert",
"Save changes to {0}?",
se.getSchemaFile().toString()),
getResourceConverter().getString(
"workbench.saveSchemaOnClose.title", "Schema"),
JOptionPane.YES_NO_CANCEL_OPTION);
switch (answer) {
case 0:
saveMenuItemActionPerformed(null);
schemaWindowMap.remove(schemaFrame);
updateMDXCatalogList();
schemaFrame.dispose();
windowMenu.remove(schemaMenuItem);
break;
case 1:
schemaFrame.dispose();
schemaWindowMap.remove(schemaFrame);
windowMenu.remove(schemaMenuItem);
break;
case 2:
try {
schemaFrame.setClosed(false);
schemaFrame.show();
} catch (Exception ex) {
LOGGER.error(ex);
}
}
return answer;
}
return 3;
}
private void minimizeMenuItemActionPerformed(
ActionEvent evt)
{
try {
for (JInternalFrame sf : getAllFrames()) {
if (sf != null && !sf.isIcon()) {
sf.setIcon(true);
}
}
} catch (Exception ex) {
LOGGER.error("minimizeMenuItemActionPerformed", ex);
//do nothing
}
}
private void maximizeMenuItemActionPerformed(
ActionEvent evt)
{
try {
for (JInternalFrame sf : getAllFrames()) {
if (sf != null) {
sf.setIcon(false);
sf.setMaximum(true);
}
}
} catch (Exception ex) {
LOGGER.error("maximizeMenuItemActionPerformed", ex);
//do nothing
}
}
/**
* Returns an iterable over all internal frames.
*/
private Iterable<JInternalFrame> getAllFrames() {
return UnionIterator.over(
schemaWindowMap.keySet(), mdxWindows, jdbcWindows);
}
private void aboutMenuItemActionPerformed(ActionEvent evt) {
try {
JEditorPane jEditorPane =
new JEditorPane(
myClassLoader.getResource(
getResourceConverter().getGUIReference("version"))
.toString());
jEditorPane.setEditable(false);
JScrollPane jScrollPane = new JScrollPane(jEditorPane);
JPanel jPanel = new JPanel();
jPanel.setLayout(new java.awt.BorderLayout());
jPanel.add(jScrollPane, java.awt.BorderLayout.CENTER);
JInternalFrame jf = new JInternalFrame();
jf.setTitle("About");
jf.getContentPane().add(jPanel);
Dimension screenSize = this.getSize();
int aboutW = 400;
int aboutH = 300;
int width = (screenSize.width / 2) - (aboutW / 2);
int height = (screenSize.height / 2) - (aboutH / 2) - 100;
jf.setBounds(width, height, aboutW, aboutH);
jf.setClosable(true);
desktopPane.add(jf);
jf.setVisible(true);
jf.show();
} catch (Exception ex) {
LOGGER.error("aboutMenuItemActionPerformed", ex);
}
}
private void newJDBCExplorerMenuItemActionPerformed(
ActionEvent evt)
{
try {
if (jdbcMetaData == null) {
getNewJdbcMetadata();
}
final JInternalFrame jf = new JInternalFrame();
jf.setTitle(
getResourceConverter().getFormattedString(
"workbench.new.JDBCExplorer.title",
"JDBC Explorer - {0} {1}",
jdbcMetaData.getDatabaseProductName(),
jdbcMetaData.getJdbcConnectionUrl()));
getNewJdbcMetadata();
JdbcExplorer jdbce = new JdbcExplorer(jdbcMetaData, this);
jf.getContentPane().add(jdbce);
jf.setBounds(0, 0, 500, 480);
jf.setClosable(true);
jf.setIconifiable(true);
jf.setMaximizable(true);
jf.setResizable(true);
jf.setVisible(true);
// create jdbc menu item
final javax.swing.JMenuItem jdbcMenuItem =
new javax.swing.JMenuItem();
jdbcMenuItem.setText(
getResourceConverter().getFormattedString(
"workbench.new.JDBCExplorer.menuitem",
"{0} JDBC Explorer",
Integer.toString(windowMenuMapIndex++)));
jdbcMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
try {
if (jf.isIcon()) {
jf.setIcon(false);
} else {
jf.setSelected(true);
}
} catch (Exception ex) {
LOGGER.error("queryMenuItem", ex);
}
}
});
jf.addInternalFrameListener(
new InternalFrameAdapter() {
public void internalFrameClosing(InternalFrameEvent e) {
jdbcWindows.remove(jf);
jf.dispose();
// follow this by removing file from schemaWindowMap
windowMenu.remove(jdbcMenuItem);
return;
}
});
desktopPane.add(jf);
jf.setVisible(true);
jf.show();
try {
jf.setSelected(true);
} catch (Exception ex) {
// do nothing
LOGGER.error(
"newJDBCExplorerMenuItemActionPerformed.setSelected", ex);
}
jdbcWindows.add(jf);
windowMenu.add(jdbcMenuItem, -1);
windowMenu.add(jSeparator3, -1);
windowMenu.add(cascadeMenuItem, -1);
windowMenu.add(tileMenuItem, -1);
windowMenu.add(minimizeMenuItem, -1);
windowMenu.add(maximizeMenuItem, -1);
windowMenu.add(closeAllMenuItem, -1);
} catch (Exception ex) {
JOptionPane.showMessageDialog(
this, getResourceConverter()
.getFormattedString(
"workbench.new.JDBCExplorer.exception",
"Database connection not successful.\n{0}",
ex.getLocalizedMessage()), getResourceConverter()
.getString(
"workbench.new.JDBCExplorer.exception.title",
"Database Connection Error"),
JOptionPane.ERROR_MESSAGE);
LOGGER.error("newJDBCExplorerMenuItemActionPerformed", ex);
}
}
/**
* Convenience method for retrieving the dbMeta instance that handles
* required Kettle initialization.
*
* @param xml
* output of {@link DatabaseMeta#getXML()} or <code>null</code>
* @return the current {@link DatabaseMeta} instance
*/
private DatabaseMeta getDbMeta(String xml) {
try {
if (!KettleEnvironment.isInitialized()) {
System.setProperty(
"KETTLE_PLUGIN_BASE_FOLDERS",
KETTLE_PLUGIN_BASE_FOLDERS);
KettleEnvironment.init();
}
if (dbMeta != null) {
return dbMeta;
}
if (xml == null) {
dbMeta = new DatabaseMeta();
} else {
dbMeta = new DatabaseMeta(xml);
}
} catch (KettleException e) {
throw new RuntimeException(
getResourceConverter()
.getFormattedString(
"workbench.new.Kettle.exception",
"Kettle failed to initialize."), e);
}
return dbMeta;
}
private void connectionButtonActionPerformed(ActionEvent evt) {
if (connectionDialog == null) {
dbMeta = getDbMeta(null);
connectionDialogController = new DataHandler();
connectionDialogController.setName("dataHandler");
XulDomContainer container = null;
try {
XulLoader loader = new SwingXulLoader();
container = loader.loadXul(
DatabaseConnectionDialog.DIALOG_DEFINITION_FILE,
Messages.getBundle());
} catch (XulException e) {
throw new RuntimeException("Xul failed to initialize", e);
}
container.addEventHandler(connectionDialogController);
connectionDialogController.loadConnectionData();
connectionDialogController.setData(dbMeta);
connectionDialog = (XulDialog) container.getDocumentRoot()
.getRootElement();
}
connectionDialog.show();
dbMeta = (DatabaseMeta) connectionDialogController.getData();
if (dbMeta.hasChanged()) {
dbMeta.clearChanged();
syncToWorkspace(dbMeta);
// Enforces the JDBC preferences entered throughout all schemas
//currently opened in the workbench.
resetWorkbench();
}
}
private void syncToWorkspace(DatabaseMeta databaseMeta) {
// sync from dbmeta to wkspc
try {
jdbcConnectionUrl = databaseMeta.getURL();
} catch (KettleDatabaseException e) {
throw new RuntimeException("Failed to determine JDBC URL", e);
}
jdbcDriverClassName = databaseMeta.getDriverClass();
jdbcUsername = databaseMeta.getUsername();
jdbcPassword = databaseMeta.getPassword();
//jdbcSchema = databaseMeta.getPreferredSchemaName();
Map<String, String> options = dbMeta.getExtraOptions();
String dbType = dbMeta.getDatabaseInterface().getPluginId();
jdbcSchema = options.get(dbType + "." + FILTER_SCHEMA_LIST);
// saving to workbench properties for documentation purposes only, since
// persistence
// of the dbmeta object is handled by a separate xml file now
if (jdbcDriverClassName != null) {
setWorkbenchProperty("jdbcDriverClassName", jdbcDriverClassName);
}
if (jdbcConnectionUrl != null) {
setWorkbenchProperty("jdbcConnectionUrl", jdbcConnectionUrl);
}
if (jdbcUsername != null) {
setWorkbenchProperty("jdbcUsername", jdbcUsername);
}
if (jdbcPassword != null) {
setWorkbenchProperty("jdbcPassword", jdbcPassword);
}
if (jdbcSchema != null) {
setWorkbenchProperty("jdbcSchema", jdbcSchema);
}
}
private void requireSchemaActionPerformed(ActionEvent evt) {
requireSchema = ((JCheckBoxMenuItem) evt.getSource()).isSelected();
setWorkbenchProperty("requireSchema", "" + requireSchema);
}
private void newSchemaMenuItemActionPerformed(ActionEvent evt) {
MondrianProperties.instance();
// User's default directory. This default depends on the operating
// system. It is typically the "My Documents" folder on Windows, and
// the user's home directory on Unix.
File defaultDir =
FileSystemView.getFileSystemView().getDefaultDirectory();
File outputFile;
do {
outputFile = new File(defaultDir, "Schema" + newSchema++ + ".xml");
} while (outputFile.exists());
openSchemaFrame(outputFile, true);
}
private void newQueryMenuItemActionPerformed(ActionEvent evt) {
JMenuItem schemaMenuItem =
(JMenuItem) schemaWindowMap.get(desktopPane.getSelectedFrame());
final JInternalFrame jf = new JInternalFrame();
jf.setTitle(
getResourceConverter().getString(
"workbench.new.MDXQuery.title", "MDX Query"));
QueryPanel qp = new QueryPanel(this);
jf.getContentPane().add(qp);
jf.setBounds(0, 0, 500, 480);
jf.setClosable(true);
jf.setIconifiable(true);
jf.setMaximizable(true);
jf.setResizable(true);
jf.setVisible(true);
desktopPane.add(jf);
jf.show();
try {
jf.setSelected(true);
} catch (Exception ex) {
// do nothing
LOGGER.error("newQueryMenuItemActionPerformed.setSelected", ex);
}
// add the mdx frame to this set of mdx frames for cascading method
mdxWindows.add(jf);
// create mdx menu item
final javax.swing.JMenuItem queryMenuItem = new javax.swing.JMenuItem();
queryMenuItem.setText(
getResourceConverter().getFormattedString(
"workbench.new.MDXQuery.menuitem",
"{0} MDX",
Integer.toString(windowMenuMapIndex)));
queryMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
try {
if (jf.isIcon()) {
jf.setIcon(false);
} else {
jf.setSelected(true);
}
} catch (Exception ex) {
LOGGER.error("queryMenuItem", ex);
}
}
});
// disable mdx frame close operation to provide our handler
// to remove frame object from mdxframeset before closing
jf.setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
jf.addInternalFrameListener(
new InternalFrameAdapter() {
public void internalFrameClosing(InternalFrameEvent e) {
mdxWindows.remove(jf);
jf.dispose();
// follow this by removing file from schemaWindowMap
windowMenu.remove(queryMenuItem);
return;
}
});
windowMenu.add(queryMenuItem, -1);
windowMenu.add(jSeparator3, -1);
windowMenu.add(cascadeMenuItem, -1);
windowMenu.add(tileMenuItem, -1);
windowMenu.add(minimizeMenuItem, -1);
windowMenu.add(maximizeMenuItem, -1);
windowMenu.add(closeAllMenuItem, -1);
qp.setMenuItem(queryMenuItem);
qp.setSchemaWindowMap(schemaWindowMap);
qp.setWindowMenuIndex(windowMenuMapIndex++);
if (schemaMenuItem != null) {
qp.initConnection(schemaMenuItem.getText());
} else {
JOptionPane.showMessageDialog(
this, getResourceConverter().getString(
"workbench.new.MDXQuery.no.selection",
"No Mondrian connection. Select a Schema to connect."),
getResourceConverter().getString(
"workbench.new.MDXQuery.no.selection.title", "Alert"),
JOptionPane.WARNING_MESSAGE);
}
}
// inform all opened mdx query windows about the list of opened schema files
private void updateMDXCatalogList() {
Iterator it = mdxWindows.iterator();
while (it.hasNext()) {
JInternalFrame elem = (JInternalFrame) it.next();
QueryPanel qp = (QueryPanel) elem.getContentPane().getComponent(0);
qp.setSchemaWindowMap(schemaWindowMap);
}
}
/**
* returns the currently selected schema explorer object
*
* @return current schema explorer object
*/
public SchemaExplorer getCurrentSchemaExplorer() {
JInternalFrame jf = desktopPane.getSelectedFrame();
if (jf != null && jf.getContentPane().getComponentCount() > 0 && jf
.getContentPane().getComponent(0) instanceof SchemaExplorer)
{
return (SchemaExplorer) jf.getContentPane().getComponent(0);
}
return null;
}
private void saveAsMenuItemActionPerformed(ActionEvent evt) {
JInternalFrame jf = desktopPane.getSelectedFrame();
if (jf != null && jf.getContentPane()
.getComponent(0) instanceof SchemaExplorer)
{
SchemaExplorer se =
(SchemaExplorer) jf.getContentPane().getComponent(0);
java.io.File schemaFile = se.getSchemaFile();
java.io.File oldSchemaFile = schemaFile;
java.io.File suggSchemaFile = new File(
schemaFile == null
? se.getSchema().name.trim() + ".xml"
: schemaFile.getName());
MondrianGuiDef.Schema schema = se.getSchema();
JFileChooser jfc = new JFileChooser();
MondrianProperties.instance();
jfc.setSelectedFile(suggSchemaFile);
if (jfc.showSaveDialog(this) == JFileChooser.APPROVE_OPTION) {
try {
schemaFile = jfc.getSelectedFile();
if (!oldSchemaFile.equals(schemaFile) && schemaFile
.exists())
{ //new file already exists, check for overwrite
int answer = JOptionPane.showConfirmDialog(
null,
getResourceConverter().getFormattedString(
"workbench.saveAs.schema.confirm",
"{0} schema file already exists. Do you want to replace it?",
schemaFile.getAbsolutePath()),
getResourceConverter().getString(
"workbench.saveAs.schema.confirm.title",
"Save As"),
JOptionPane.YES_NO_OPTION);
if (answer == 1) { // no=1 ; yes=0
return;
}
}
if (se.isNewFile() && !oldSchemaFile.equals(schemaFile)) {
oldSchemaFile.delete();
}
if (se.isNewFile()) {
se.setNewFile(false);
}
se.setDirty(false);
se.setDirtyFlag(false);
XMLOutput out =
new XMLOutput(
new java.io.FileWriter(jfc.getSelectedFile()));
out.setAlwaysQuoteCData(true);
out.setIndentString(" ");
schema.displayXML(out);
se.setSchemaFile(schemaFile);
se.setTitle(); //sets title of iframe
setLastUsed(
jfc.getSelectedFile().getName(),
jfc.getSelectedFile().toURI().toURL().toString());
// Update menu item with new file name, then update catalog
// list for mdx queries
JMenuItem sMenuItem = (JMenuItem) schemaWindowMap.get(jf);
String mtexttokens[] = sMenuItem.getText().split(" ");
sMenuItem.setText(
mtexttokens[0] + " " + se.getSchemaFile().getName());
// Schema menu item updated, now update mdx query windows
// with updated catalog list.
updateMDXCatalogList();
} catch (Exception ex) {
LOGGER.error(ex);
}
}
}
}
private void viewXMLMenuItemActionPerformed(ActionEvent evt) {
JInternalFrame jf = desktopPane.getSelectedFrame();
boolean oldValue = viewXmlMenuItem.getState();
if (jf != null
&& jf.getContentPane().getComponent(0) instanceof SchemaExplorer)
{
SchemaExplorer se =
(SchemaExplorer) jf.getContentPane().getComponent(0);
// Call schema explorer's view xml event and update the workbench's
// view menu accordingly'
((JCheckBoxMenuItem) evt.getSource()).setSelected(se.editMode(evt));
return;
}
viewXmlMenuItem.setSelected(!oldValue);
}
public void saveMenuItemActionPerformed(ActionEvent evt) {
JInternalFrame jf = desktopPane.getSelectedFrame();
// Don't save if nothing there
if (jf == null || jf.getContentPane() == null) {
return;
}
if (jf.getContentPane().getComponent(0) instanceof SchemaExplorer) {
SchemaExplorer se =
(SchemaExplorer) jf.getContentPane().getComponent(0);
java.io.File schemaFile = se.getSchemaFile();
if (se.isNewFile()) {
saveAsMenuItemActionPerformed(evt);
return;
}
se.setDirty(false);
se.setDirtyFlag(false);
se.setTitle(); //sets title of iframe
MondrianGuiDef.Schema schema = se.getSchema();
MondrianProperties.instance();
try {
XMLOutput out = new XMLOutput(new FileWriter(schemaFile));
out.setAlwaysQuoteCData(true);
out.setIndentString(" ");
schema.displayXML(out);
setLastUsed(
schemaFile.getName(),
schemaFile.toURI().toURL().toString());
} catch (Exception ex) {
LOGGER.error("saveMenuItemActionPerformed", ex);
}
}
}
/**
* Set last used in properties file
*
* @param name
* @param url
*/
private void setLastUsed(String name, String url) {
int match = 4;
String luName = null;
String propname = null;
String lastUsed = "lastUsed";
String lastUsedUrl = "lastUsedUrl";
for (int i = 1; i <= 4; i++) {
propname = lastUsed + i;
luName = getWorkbenchProperty(propname);
if (luName != null && luName.equals(name)) {
match = i;
break;
}
}
for (int i = match; i > 1; i--) {
if (getWorkbenchProperty(lastUsed + (i - 1)) != null) {
setWorkbenchProperty(
lastUsed + i, getWorkbenchProperty(
lastUsed + (i - 1)));
setWorkbenchProperty(
lastUsedUrl + i, getWorkbenchProperty(
lastUsedUrl + (i - 1)));
}
}
setWorkbenchProperty(LAST_USED1, name);
setWorkbenchProperty(LAST_USED1_URL, url);
updateLastUsedMenu();
storeWorkbenchProperties();
storeDatabaseMeta();
}
private void updateLastUsedMenu() {
if (getWorkbenchProperty(LAST_USED1) == null) {
jSeparator2.setVisible(false);
} else {
jSeparator2.setVisible(true);
}
if (getWorkbenchProperty(LAST_USED1) != null) {
lastUsed1MenuItem.setVisible(true);
} else {
lastUsed1MenuItem.setVisible(false);
}
if (getWorkbenchProperty(LAST_USED2) != null) {
lastUsed2MenuItem.setVisible(true);
} else {
lastUsed2MenuItem.setVisible(false);
}
if (getWorkbenchProperty(LAST_USED3) != null) {
lastUsed3MenuItem.setVisible(true);
} else {
lastUsed3MenuItem.setVisible(false);
}
if (getWorkbenchProperty(LAST_USED4) != null) {
lastUsed4MenuItem.setVisible(true);
} else {
lastUsed4MenuItem.setVisible(false);
}
lastUsed1MenuItem.setText(getWorkbenchProperty(LAST_USED1));
lastUsed2MenuItem.setText(getWorkbenchProperty(LAST_USED2));
lastUsed3MenuItem.setText(getWorkbenchProperty(LAST_USED3));
lastUsed4MenuItem.setText(getWorkbenchProperty(LAST_USED4));
}
private void lastUsed1MenuItemActionPerformed(ActionEvent evt) {
try {
openSchemaFrame(
new File(new URI(getWorkbenchProperty(LAST_USED1_URL))), false);
} catch (Exception e) {
// probably URISyntaxException
LOGGER.error("lastUsed1MenuItemActionPerformed", e);
}
}
private void lastUsed2MenuItemActionPerformed(ActionEvent evt) {
try {
openSchemaFrame(
new File(new URI(getWorkbenchProperty(LAST_USED2_URL))), false);
setLastUsed(
getWorkbenchProperty(LAST_USED2), getWorkbenchProperty(
LAST_USED2_URL));
} catch (URISyntaxException e) {
LOGGER.error("lastUsed2MenuItemActionPerformed", e);
}
}
private void lastUsed3MenuItemActionPerformed(ActionEvent evt) {
try {
openSchemaFrame(
new File(new URI(getWorkbenchProperty(LAST_USED3_URL))), false);
setLastUsed(
getWorkbenchProperty(LAST_USED3), getWorkbenchProperty(
LAST_USED3_URL));
} catch (URISyntaxException e) {
LOGGER.error("lastUsed3MenuItemActionPerformed", e);
}
}
private void lastUsed4MenuItemActionPerformed(ActionEvent evt) {
try {
openSchemaFrame(
new File(new URI(getWorkbenchProperty(LAST_USED4_URL))), false);
setLastUsed(
getWorkbenchProperty(LAST_USED4), getWorkbenchProperty(
LAST_USED4_URL));
} catch (URISyntaxException e) {
LOGGER.error("lastUsed4MenuItemActionPerformed", e);
}
}
/**
* @param file
*/
private void openSchemaFrame(File file, boolean newFile) {
try {
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
if (!newFile) {
// check if file not already open
if (checkFileOpen(file)) {
return;
}
// check if schema file exists
if (!file.exists()) {
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.open.schema.not.found",
"{0} File not found.",
file.getAbsolutePath()),
getResourceConverter().getString(
"workbench.open.schema.not.found.title", "Alert"),
JOptionPane.WARNING_MESSAGE);
return;
}
// check if file is writable
if (!file.canWrite()) {
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.open.schema.not.writeable",
"{0} is not writeable.",
file.getAbsolutePath()),
getResourceConverter().getString(
"workbench.open.schema.not.writeable.title",
"Alert"),
JOptionPane.WARNING_MESSAGE);
return;
}
checkSchemaFile(file);
}
final JInternalFrame schemaFrame = new JInternalFrame();
schemaFrame.setTitle(
getResourceConverter().getFormattedString(
"workbench.open.schema.title",
"Schema - {0}",
file.getName()));
getNewJdbcMetadata();
schemaFrame.getContentPane().add(
new SchemaExplorer(
this, file, jdbcMetaData, newFile, schemaFrame));
String errorOpening =
((SchemaExplorer) schemaFrame.getContentPane().getComponent(0))
.getErrMsg();
if (errorOpening != null) {
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.open.schema.error",
"Error opening schema - {0}.",
errorOpening),
getResourceConverter().getString(
"workbench.open.schema.error.title", "Error"),
JOptionPane.ERROR_MESSAGE);
schemaFrame.setClosed(true);
return;
}
schemaFrame.setBounds(0, 0, 1000, 650);
schemaFrame.setClosable(true);
schemaFrame.setIconifiable(true);
schemaFrame.setMaximizable(true);
schemaFrame.setResizable(true);
schemaFrame.setVisible(true);
desktopPane.add(
schemaFrame, javax.swing.JLayeredPane.DEFAULT_LAYER);
schemaFrame.show();
schemaFrame.setMaximum(true);
displayWarningOnFailedConnection();
final javax.swing.JMenuItem schemaMenuItem =
new javax.swing.JMenuItem();
schemaMenuItem.setText(windowMenuMapIndex++ + " " + file.getName());
schemaMenuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
try {
if (schemaFrame.isIcon()) {
schemaFrame.setIcon(false);
} else {
schemaFrame.setSelected(true);
}
} catch (Exception ex) {
LOGGER.error("schemaMenuItem", ex);
}
}
});
windowMenu.add(schemaMenuItem, 0);
windowMenu.setEnabled(true);
windowMenu.add(jSeparator3, -1);
windowMenu.add(cascadeMenuItem, -1);
windowMenu.add(tileMenuItem, -1);
windowMenu.add(minimizeMenuItem, -1);
windowMenu.add(maximizeMenuItem, -1);
windowMenu.add(closeAllMenuItem, -1);
// add the file details in menu map
schemaWindowMap.put(schemaFrame, schemaMenuItem);
updateMDXCatalogList();
schemaFrame.setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
schemaFrame.addInternalFrameListener(
new InternalFrameAdapter() {
public void internalFrameClosing(InternalFrameEvent e) {
if (schemaFrame.getContentPane()
.getComponent(0) instanceof SchemaExplorer)
{
SchemaExplorer se =
(SchemaExplorer) schemaFrame.getContentPane()
.getComponent(0);
int response = confirmFrameClose(schemaFrame, se);
if (response == 3) { // not dirty
if (se.isNewFile()) {
se.getSchemaFile().delete();
}
// default case for no save and not dirty
schemaWindowMap.remove(schemaFrame);
updateMDXCatalogList();
schemaFrame.dispose();
windowMenu.remove(schemaMenuItem);
}
}
}
});
schemaFrame.setFocusable(true);
schemaFrame.addFocusListener(
new FocusAdapter() {
public void focusGained(FocusEvent e) {
if (schemaFrame.getContentPane()
.getComponent(0) instanceof SchemaExplorer)
{
SchemaExplorer se = (SchemaExplorer)
schemaFrame.getContentPane().getComponent(0);
// update view menu based on schemaframe who gained
// focus
viewXmlMenuItem.setSelected(
se.isEditModeXML());
}
}
public void focusLost(FocusEvent e) {
if (schemaFrame.getContentPane()
.getComponent(0) instanceof SchemaExplorer)
{
SchemaExplorer se = (SchemaExplorer)
schemaFrame.getContentPane().getComponent(0);
// update view menu based on
viewXmlMenuItem.setSelected(
se.isEditModeXML());
}
}
});
viewXmlMenuItem.setSelected(false);
} catch (Exception ex) {
LOGGER.error("openSchemaFrame", ex);
} finally {
setCursor(Cursor.getPredefinedCursor(Cursor.DEFAULT_CURSOR));
}
}
private void openMenuItemActionPerformed(ActionEvent evt) {
JFileChooser jfc = new JFileChooser();
try {
jfc.setFileSelectionMode(JFileChooser.FILES_ONLY);
jfc.setFileFilter(
new javax.swing.filechooser.FileFilter() {
public boolean accept(File pathname) {
return pathname.getName().toLowerCase().endsWith(".xml")
|| pathname.isDirectory();
}
public String getDescription() {
return getResourceConverter().getString(
"workbench.open.schema.file.type",
"Mondrian Schema files (*.xml)");
}
});
String lastUsed = getWorkbenchProperty(LAST_USED1_URL);
if (lastUsed != null) {
jfc.setCurrentDirectory(new File(new URI(lastUsed)));
}
} catch (Exception ex) {
LOGGER.error("Could not set file chooser", ex);
}
MondrianProperties.instance();
if (jfc.showOpenDialog(this) == JFileChooser.APPROVE_OPTION) {
try {
setLastUsed(
jfc.getSelectedFile().getName(),
jfc.getSelectedFile().toURI().toURL().toString());
} catch (MalformedURLException e) {
LOGGER.error(e);
}
openSchemaFrame(jfc.getSelectedFile(), false);
}
}
// checks if file already open in schema explorer
private boolean checkFileOpen(File file) {
Iterator it = schemaWindowMap.keySet().iterator(); // keys=schemaframes
while (it.hasNext()) {
JInternalFrame elem = (JInternalFrame) it.next();
File f = ((SchemaExplorer) elem.getContentPane().getComponent(0))
.getSchemaFile();
if (f.equals(file)) {
try {
// make the schema file active
elem.setSelected(true);
return true;
} catch (Exception ex) {
// remove file from map as schema frame does not exist
schemaWindowMap.remove(elem);
break;
}
}
}
return false;
}
private void getNewJdbcMetadata() {
jdbcMetaData = new JdbcMetaData(
this,
jdbcDriverClassName,
jdbcConnectionUrl,
jdbcUsername,
jdbcPassword,
jdbcSchema,
requireSchema);
}
/**
* Updates the JdbcMetaData for each SchemaExplorer contained in each Schema
* Frame currently opened based on the JDBC preferences entered.
*/
private void resetWorkbench() {
getNewJdbcMetadata();
Iterator theSchemaFrames = schemaWindowMap.keySet().iterator();
while (theSchemaFrames.hasNext()) {
JInternalFrame theSchemaFrame =
(JInternalFrame) theSchemaFrames.next();
SchemaExplorer theSchemaExplorer =
(SchemaExplorer) theSchemaFrame.getContentPane()
.getComponent(0);
File theFile = theSchemaExplorer.getSchemaFile();
checkSchemaFile(theFile);
theSchemaExplorer.resetMetaData(jdbcMetaData);
theSchemaExplorer.getTreeUpdater().update();
theSchemaFrame.updateUI();
}
//EC: If the JDBC preferences entered then display a warning.
displayWarningOnFailedConnection();
for (JInternalFrame jdbcFrame : jdbcWindows) {
JdbcExplorer explorer =
(JdbcExplorer) jdbcFrame.getContentPane().getComponent(0);
explorer.resetMetaData(jdbcMetaData);
jdbcFrame.setTitle(
getResourceConverter().getFormattedString(
"workbench.new.JDBCExplorer.title",
"JDBC Explorer - {0} {1}",
jdbcMetaData.getDatabaseProductName(),
jdbcMetaData.getJdbcConnectionUrl()));
explorer.getTreeUpdater().update();
explorer.updateUI();
}
}
/**
* Display jdbc connection status warning, if connection is uncsuccessful.
*/
private void displayWarningOnFailedConnection() {
if (jdbcMetaData != null && jdbcMetaData.getErrMsg() != null) {
JOptionPane.showMessageDialog(
this,
getResourceConverter().getFormattedString(
"workbench.open.schema.jdbc.error",
"Database connection could not be done.\n{0}\nAll validations related to database will be ignored.",
jdbcMetaData.getErrMsg()),
getResourceConverter().getString(
"workbench.open.schema.jdbc.error.title", "Alert"),
JOptionPane.WARNING_MESSAGE);
}
}
/**
* Check if schema file is valid by initiating a mondrian connection.
*/
private void checkSchemaFile(File file) {
try {
// this connection parses the catalog file which if invalid will
// throw exception
PropertyList list = new PropertyList();
list.put("Provider", "mondrian");
list.put("Jdbc", jdbcConnectionUrl);
list.put("Catalog", file.toURL().toString());
list.put("JdbcDrivers", jdbcDriverClassName);
if (jdbcUsername != null && jdbcUsername.length() > 0) {
list.put("JdbcUser", jdbcUsername);
}
if (jdbcPassword != null && jdbcPassword.length() > 0) {
list.put("JdbcPassword", jdbcPassword);
}
// clear cache before connecting
AggregationManager.instance().getCacheControl(null)
.flushSchemaCache();
DriverManager.getConnection(list, null);
} catch (Exception ex) {
LOGGER.error(
"Exception : Schema file "
+ file.getAbsolutePath()
+ " is invalid."
+ ex.getMessage(), ex);
} catch (Error err) {
LOGGER.error(
"Error : Schema file "
+ file.getAbsolutePath()
+ " is invalid."
+ err.getMessage(), err);
}
}
private void exitMenuItemActionPerformed(ActionEvent evt) {
storeWorkbenchProperties();
storeDatabaseMeta();
closeAllSchemaFrames(true);
}
/**
* Parses arguments passed into Workbench.
*
* <p>Right now, it's very simple. Just search through the list of
* arguments. If it begins with -f=, then the rest is a file name. Ignore
* any others. We can make this more complicated later if we need to.
*
* @param args the command line arguments
*/
private void parseArgs(String args[]) {
for (int argNum = 0; argNum < args.length; argNum++) {
if (args[argNum].startsWith("-f=")) {
openFile = args[argNum].substring(3);
}
}
}
public String getTooltip(String titleName) {
try {
return getWorkbenchResourceBundle().getString(titleName);
} catch (MissingResourceException e) {
return getResourceConverter().getFormattedString(
"workbench.tooltip.error",
"No help available for {0}",
titleName);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
Workbench w = null;
try {
w = new Workbench();
w.parseArgs(args);
w.setSize(800, 600);
// if user specified a file to open, do so now.
if (w.openFile != null) {
File f = new File(w.openFile);
if (f.canRead()) {
w.openSchemaFrame(
f.getAbsoluteFile(),
// parameter to indicate this is a new or existing
// catalog file
false);
}
}
w.setVisible(true);
} catch (Throwable ex) {
if (w != null) {
JOptionPane.showMessageDialog(
w,
w.getResourceConverter().getFormattedString(
"workbench.main.uncoverable_error",
"Pentaho Schema Workbench has encountered an unrecoverable error. \n{0}",
ex.getLocalizedMessage()),
w.getResourceConverter().getString(
"workbench.main.uncoverable_error.title",
"PSW Fatal Error"),
JOptionPane.ERROR_MESSAGE);
}
LOGGER.error("main", ex);
}
}
// Variables declaration - do not modify
private javax.swing.JButton toolbarSaveAsButton;
private javax.swing.JMenuItem openMenuItem;
private javax.swing.JMenuItem lastUsed1MenuItem;
private javax.swing.JMenuItem lastUsed2MenuItem;
private javax.swing.JMenuItem lastUsed3MenuItem;
private javax.swing.JMenuItem lastUsed4MenuItem;
private javax.swing.JMenu fileMenu;
private javax.swing.JMenuItem newQueryMenuItem;
private javax.swing.JMenuItem newQueryMenuItem2;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JButton toolbarOpenButton;
private javax.swing.JButton toolbarNewButton;
private javax.swing.JButton toolbarNewArrowButton;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JSeparator jSeparator2;
private javax.swing.JSeparator jSeparator3;
private javax.swing.JSeparator jSeparator4;
private javax.swing.JMenuItem cutMenuItem;
private javax.swing.JMenuBar menuBar;
private javax.swing.JMenuItem saveMenuItem;
private javax.swing.JMenuItem newJDBCExplorerMenuItem;
private javax.swing.JMenuItem newJDBCExplorerMenuItem2;
private javax.swing.JCheckBoxMenuItem viewCubesMenuItem;
private javax.swing.JButton toolbarSaveButton;
private javax.swing.JMenuItem copyMenuItem;
private javax.swing.JDesktopPane desktopPane;
private javax.swing.JMenu viewMenu;
private javax.swing.JMenu toolsMenu;
private javax.swing.JMenu newMenu;
private javax.swing.JMenuItem deleteMenuItem;
private javax.swing.JMenuItem newSchemaMenuItem;
private javax.swing.JMenuItem newSchemaMenuItem2;
private javax.swing.JMenuItem exitMenuItem;
private javax.swing.JButton toolbarPreferencesButton;
private javax.swing.JCheckBoxMenuItem requireSchemaCheckboxMenuItem;
private javax.swing.JCheckBoxMenuItem viewMeasuresMenuItem;
private javax.swing.JMenu editMenu;
private javax.swing.JMenuItem pasteMenuItem;
private javax.swing.JMenuItem preferencesMenuItem;
private javax.swing.JCheckBoxMenuItem viewDimensionsMenuItem;
private javax.swing.JCheckBoxMenuItem viewXmlMenuItem;
private javax.swing.JMenuItem saveAsMenuItem;
private javax.swing.JToolBar jToolBar1;
private javax.swing.JToolBar jToolBar2;
private javax.swing.JPopupMenu toolbarNewPopupMenu;
private javax.swing.JMenu windowMenu;
private javax.swing.JMenu helpMenu;
private javax.swing.JMenuItem aboutMenuItem;
private javax.swing.JMenuItem cascadeMenuItem;
private javax.swing.JMenuItem tileMenuItem;
private javax.swing.JMenuItem minimizeMenuItem;
private javax.swing.JMenuItem maximizeMenuItem;
private javax.swing.JMenuItem closeAllMenuItem;
// End of variables declaration
/**
* Used by schema framewhen it uses 'view xml' to update view xml menu item
*/
public javax.swing.JCheckBoxMenuItem getViewXmlMenuItem() {
return viewXmlMenuItem;
}
}
// End Workbench.java