Pentaho Schema Workbench

Working directory must be set for Schema Workbench to work

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Medium Medium
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 3.5.0 GA
  • Component/s: None
  • QA Validation Status:
    Validated by QA
  • Description:
    Hide
    Schema Workbench 3.0.4 requires the working directory set to be the directory where it is installed.

    If you do not, you get a ClassNotFoundException error on the database driver when trying to make a DB connection.

    The terminal output is:

    15:22:05,513 ERROR [JDBCMetaData] Database connection exception : ClassNotFoundException : com.mysql.jdbc.Driver
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
            at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
            at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
            at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
            at java.lang.Class.forName0(Native Method)
            at java.lang.Class.forName(Class.java:164)
            at mondrian.gui.JDBCMetaData.initConnection(JDBCMetaData.java:105)
            at mondrian.gui.JDBCMetaData.<init>(JDBCMetaData.java:75)
            at mondrian.gui.Workbench.resetWorkbench(Workbench.java:1562)
            at mondrian.gui.Workbench.toolbarPreferencesButtonActionPerformed(Workbench.java:1037)
            at mondrian.gui.Workbench.access$800(Workbench.java:59)
            at mondrian.gui.Workbench$23.actionPerformed(Workbench.java:551)
            at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
            at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
            at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
            at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
            at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
            at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
            at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
            at java.awt.Component.processMouseEvent(Component.java:5517)
            at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
            at java.awt.Component.processEvent(Component.java:5282)
            at java.awt.Container.processEvent(Container.java:1966)
            at java.awt.Component.dispatchEventImpl(Component.java:3984)
            at java.awt.Container.dispatchEventImpl(Container.java:2024)
            at java.awt.Component.dispatchEvent(Component.java:3819)
            at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
            at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
            at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
            at java.awt.Container.dispatchEventImpl(Container.java:2010)
            at java.awt.Window.dispatchEventImpl(Window.java:1791)
            at java.awt.Component.dispatchEvent(Component.java:3819)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
            at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

    The solution is to cd into the directory first:

    $ cd /opt/pentaho/workbench
    $ sh workbench.sh

    More detail at http://wiki.bizcubed.com.au:8080/xwiki/bin/view/Pentaho+Tutorial/Troubleshooting+GUI+tools#HCheckworkingdirectory

    This is similar to PMD-458 and PRD-1034.
    Show
    Schema Workbench 3.0.4 requires the working directory set to be the directory where it is installed. If you do not, you get a ClassNotFoundException error on the database driver when trying to make a DB connection. The terminal output is: 15:22:05,513 ERROR [JDBCMetaData] Database connection exception : ClassNotFoundException : com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver         at java.net.URLClassLoader$1.run(URLClassLoader.java:200)         at java.security.AccessController.doPrivileged(Native Method)         at java.net.URLClassLoader.findClass(URLClassLoader.java:188)         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)         at java.lang.ClassLoader.loadClass(ClassLoader.java:251)         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)         at java.lang.Class.forName0(Native Method)         at java.lang.Class.forName(Class.java:164)         at mondrian.gui.JDBCMetaData.initConnection(JDBCMetaData.java:105)         at mondrian.gui.JDBCMetaData.<init>(JDBCMetaData.java:75)         at mondrian.gui.Workbench.resetWorkbench(Workbench.java:1562)         at mondrian.gui.Workbench.toolbarPreferencesButtonActionPerformed(Workbench.java:1037)         at mondrian.gui.Workbench.access$800(Workbench.java:59)         at mondrian.gui.Workbench$23.actionPerformed(Workbench.java:551)         at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)         at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)         at javax.swing.AbstractButton.doClick(AbstractButton.java:302)         at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)         at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)         at java.awt.Component.processMouseEvent(Component.java:5517)         at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)         at java.awt.Component.processEvent(Component.java:5282)         at java.awt.Container.processEvent(Container.java:1966)         at java.awt.Component.dispatchEventImpl(Component.java:3984)         at java.awt.Container.dispatchEventImpl(Container.java:2024)         at java.awt.Component.dispatchEvent(Component.java:3819)         at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)         at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)         at java.awt.Container.dispatchEventImpl(Container.java:2010)         at java.awt.Window.dispatchEventImpl(Window.java:1791)         at java.awt.Component.dispatchEvent(Component.java:3819)         at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)         at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)         at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)         at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) The solution is to cd into the directory first: $ cd /opt/pentaho/workbench $ sh workbench.sh More detail at http://wiki.bizcubed.com.au:8080/xwiki/bin/view/Pentaho+Tutorial/Troubleshooting+GUI+tools#HCheckworkingdirectory This is similar to PMD-458 and PRD-1034.
  • Environment:
    Tested on Fedora 8

Activity

Ascending order - Click to sort in descending order
Aaron Phillips made changes - 30/Mar/09 2:40 PM
Field Original Value New Value
Project Pentaho Analysis Tool [ 10165 ] Pentaho BI Server [ 10090 ]
Key BISERVER-2987
Workflow jira [ 314556 ] Pentaho Engineering 3.0 Workflow [ 316351 ]
QA Validation Status Not Yet Validated
Component/s GUI [ 10425 ]
Hide
Permalink
Kurtis Cruzada added a comment - 31/Mar/09 9:31 AM - edited
Please address all the .sh and .bat for the cases mentioned in this case.
Show
Kurtis Cruzada added a comment - 31/Mar/09 9:31 AM - edited Please address all the .sh and .bat for the cases mentioned in this case.
Kurtis Cruzada made changes - 31/Mar/09 9:31 AM
Status Open [ 1 ] Open [ 1 ]
Fix Version/s CITRUS [ 10609 ]
Assignee Unassigned User [ unassigned ] Ezequiel Cuellar [ ecuellar ]
Priority Unknown [ 7 ] Medium [ 6 ]
Hide
Permalink
Sridhar Dhanapalan added a comment - 15/May/09 1:33 AM
Hi Kurtis,

I'm not sure what you're asking for as I already mentioned that I am trying to execute workbench.sh.

I think I have a solution. The beginning of my workbench.sh now looks like this:

#!/bin/bash
# $Id: //open/mondrian-release/3.0/workbench/workbench.sh#7 $
# Launch Mondrian Schema Workbench on Linux, UNIX or Cygwin

# Platform specific path-separator.

# first look in directory of the script for lib, then
# look up one folder if lib does not exist

BASEDIR=`dirname $0`
cd $BASEDIR

MONDRIAN_HOME=$(pwd)
if test ! -d $MONDRIAN_HOME/lib; then
  MONDRIAN_HOME=$(cd ..; pwd)
fi
Show
Sridhar Dhanapalan added a comment - 15/May/09 1:33 AM Hi Kurtis, I'm not sure what you're asking for as I already mentioned that I am trying to execute workbench.sh. I think I have a solution. The beginning of my workbench.sh now looks like this: #!/bin/bash # $Id: //open/mondrian-release/3.0/workbench/workbench.sh#7 $ # Launch Mondrian Schema Workbench on Linux, UNIX or Cygwin # Platform specific path-separator. # first look in directory of the script for lib, then # look up one folder if lib does not exist BASEDIR=`dirname $0` cd $BASEDIR MONDRIAN_HOME=$(pwd) if test ! -d $MONDRIAN_HOME/lib; then   MONDRIAN_HOME=$(cd ..; pwd) fi
Gretchen Moran made changes - 04/Aug/09 6:40 PM
Workflow Pentaho Engineering 3.0 Workflow [ 316351 ] Pentaho Engineering 4.0 Workflow [ 374358 ]
Gretchen Moran made changes - 04/Aug/09 6:43 PM
Workflow Pentaho Engineering 3.0 Workflow [ 374358 ] Pentaho Engineering 4.0 Workflow [ 377209 ]
Marc Batchelor made changes - 04/Aug/09 8:31 PM
Workflow Pentaho Engineering 4.0 Workflow [ 377209 ] Pentaho Engineering 5.0 Workflow [ 404173 ]
Marc Batchelor made changes - 17/Aug/09 10:16 AM
Workflow Pentaho Engineering 5.0 Workflow [ 404173 ] Pentaho Engineering 6.0 Workflow [ 426942 ]
Will Gorman made changes - 04/Sep/09 9:11 AM
Project Pentaho BI Server [ 10090 ] Pentaho Schema Workbench [ 10168 ]
Key BISERVER-2987 PSW-60
Kurtis Cruzada made changes - 11/Sep/09 1:23 PM
Fix Version/s CITRUS [ 10609 ]
Status Open [ 1 ] Open [ 1 ]
Assignee Ezequiel Cuellar [ ecuellar ] Will Gorman [ wgorman ]
Will Gorman made changes - 11/Sep/09 2:37 PM
Fix Version/s CITRUS [ 10696 ]
Will Gorman made changes - 14/Sep/09 9:07 AM
Status Open [ 1 ] In Progress [ 3 ]
Hide
Permalink
Will Gorman added a comment - 14/Sep/09 3:44 PM
I've made this change to the .sh file, this should be available in Schema Workbench version 3.1.4.
Show
Will Gorman added a comment - 14/Sep/09 3:44 PM I've made this change to the .sh file, this should be available in Schema Workbench version 3.1.4.
Will Gorman made changes - 14/Sep/09 3:44 PM
Status In Progress [ 3 ] Ready For Test [ 10004 ]
Assignee Will Gorman [ wgorman ] Jared Pshedesky [ jpshedesky ]
Golda David made changes - 29/Sep/09 3:20 PM
Assignee Jared Pshedesky [ jpshedesky ] Golda David [ gdavid ]
Hide
Permalink
Golda David added a comment - 29/Sep/09 3:20 PM
Tested this in Waynes UBUNTU machine and the .sh script starts fine without any error.

Show
Golda David added a comment - 29/Sep/09 3:20 PM Tested this in Waynes UBUNTU machine and the .sh script starts fine without any error.
Golda David made changes - 29/Sep/09 3:20 PM
Status Ready For Test [ 10004 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Hide
Permalink
Golda David added a comment - 29/Sep/09 3:21 PM
Validated using 3.5.0GA
Show
Golda David added a comment - 29/Sep/09 3:21 PM Validated using 3.5.0GA
Golda David made changes - 29/Sep/09 3:21 PM
Status Resolved [ 5 ] Closed [ 6 ]
QA Validation Status Not Yet Validated Validated by QA
Marc Batchelor made changes - 06/May/10 6:47 PM
Workflow Pentaho Engineering 6.0 Workflow [ 426942 ] Pentaho Engineering 7.0 Workflow [ 499061 ]
Marc Batchelor made changes - 04/Aug/10 10:09 PM
Workflow Pentaho Engineering 7.0 Workflow [ 499061 ] Pentaho Engineering 8.0 Workflow [ 519442 ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
Open Open Open Open
4d 10h 1m
1
Kurtis Cruzada
31/Mar/09 9:31 AM
Open Open Open Open
164d 3h 51m
1
Kurtis Cruzada
11/Sep/09 1:23 PM
Open Open In Progress In Progress
2d 19h 44m
1
Will Gorman
14/Sep/09 9:07 AM
In Progress In Progress Ready For Test Ready For Test
6h 37m
1
Will Gorman
14/Sep/09 3:44 PM
Ready For Test Ready For Test Resolved Resolved
14d 23h 36m
1
Golda David
29/Sep/09 3:20 PM
Resolved Resolved Closed Closed
21s
1
Golda David
29/Sep/09 3:21 PM

People

Dates

  • Created:
    26/Mar/09 11:30 PM
    Updated:
    29/Sep/09 3:21 PM
    Resolved:
    29/Sep/09 3:20 PM
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Pentaho.org. Try JIRA - bug tracking software for your team.