[asdf999]

DB explorer is working but disturbing error message allways appears.
“An error has accured, see error log for more details”
In log is:

!SESSION 2006-02-27 08:29:17.735 ———————————————–
eclipse.buildId=I20050627-1435
java.version=1.5.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=sk_SK
Command-line arguments: -os win32 -ws win32 -arch x86

This is a continuation of log file C:\2_eclipse\eclipse\workspace\.metadata\.bak_0.log
Created Time: 2006-03-03 09:14:25.341

!ENTRY org.eclipse.ui.workbench 4 2 2006-03-03 09:14:25.341
!MESSAGE Problems occurred when invoking code from plug-in: “org.eclipse.ui.workbench”.
!STACK 0
java.lang.NullPointerException at com.genuitec.eclipse.sqlexplorer.editors.SQLEditor$7.partActivated(SQLEditor.java:344)
at org.eclipse.ui.internal.PartListenerList$1.run(PartListenerList.java:72)
at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044)
at org.eclipse.core.runtime.Platform.run(Platform.java:783)
at org.eclipse.ui.internal.PartListenerList.fireEvent(PartListenerList.java:58)
at org.eclipse.ui.internal.PartListenerList.firePartActivated(PartListenerList.java:70)
at org.eclipse.ui.internal.PartService.firePartActivated(PartService.java:73)
at org.eclipse.ui.internal.PartService.setActivePart(PartService.java:171)
at org.eclipse.ui.internal.WorkbenchPagePartList.fireActivePartChanged(WorkbenchPagePartList.java:56)
at org.eclipse.ui.internal.PartList.setActivePart(PartList.java:108)
at org.eclipse.ui.internal.WorkbenchPage.setActivePart(WorkbenchPage.java:2859)
at org.eclipse.ui.internal.WorkbenchPage.requestActivation(WorkbenchPage.java:2471)
at org.eclipse.ui.internal.PartPane.requestActivation(PartPane.java:249)
at org.eclipse.ui.internal.EditorPane.requestActivation(EditorPane.java:88)
at org.eclipse.ui.internal.PartPane.handleEvent(PartPane.java:214)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:867)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:848)
at org.eclipse.swt.widgets.Shell.setActiveControl(Shell.java:998)
at org.eclipse.swt.widgets.Control.sendFocusEvent(Control.java:1855)
at org.eclipse.swt.widgets.Widget.wmSetFocus(Widget.java:1961)
at org.eclipse.swt.widgets.Control.WM_SETFOCUS(Control.java:3630)
at org.eclipse.swt.widgets.Canvas.WM_SETFOCUS(Canvas.java:247)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3102)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:3706)
at org.eclipse.swt.internal.win32.OS.SetFocus(Native Method)
at org.eclipse.swt.widgets.Control.forceFocus(Control.java:651)
at org.eclipse.swt.widgets.Control.setSavedFocus(Control.java:2360)
at org.eclipse.swt.widgets.Decorations.restoreFocus(Decorations.java:806)
at org.eclipse.swt.widgets.Decorations.WM_ACTIVATE(Decorations.java:1623)
at org.eclipse.swt.widgets.Shell.WM_ACTIVATE(Shell.java:1476)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3036)
at org.eclipse.swt.widgets.Decorations.windowProc(Decorations.java:1582)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:3706)
at org.eclipse.swt.internal.win32.OS.DestroyWindow(Native Method)
at org.eclipse.swt.widgets.Control.destroyWidget(Control.java:527)
at org.eclipse.swt.widgets.Widget.dispose(Widget.java:383)
at org.eclipse.swt.widgets.Decorations.dispose(Decorations.java:441)
at org.eclipse.swt.widgets.Shell.dispose(Shell.java:499)
at org.eclipse.jface.window.Window.close(Window.java:321)
at org.eclipse.jface.dialogs.Dialog.close(Dialog.java:891)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.close(ProgressMonitorDialog.java:325)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.finishedRun(ProgressMonitorDialog.java:534)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:450)
at com.genuitec.eclipse.sqlexplorer.actions.ExecSQLAction.run(ExecSQLAction.java:65)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:441)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

[Haris Peco]

asdf999 ,

Please send us details what you do when exception happen

Thanks

[Brian Fernandes]

Please also answer all questions asked here: Posting Guidelines

If you recently upgraded MyEclipse try starting with -clean. Details at above link.

Best,
Brian.

[asdf999]

REMOVED

[asdf999]

In DB Excplorer perspective, if I click from any other frame in Eclipse again to SQL Editor frame.

[asdf999]

+it happens to my colegues too, that is why they do not use this DB Explorer, but I do not give up so easy :–)

[Brian Fernandes]

I’m sorry, but there were questions at the above link about your database connection which you have not answered.
Could you tell us which Database you are trying to connect to, what driver you are using etc?

Did you try restarting eclipse using the -clean flag?

Also, I see you are probably using an old version of MyEclipse (probably 4.0.3). 4.1.1 has a large number of ehnacements and bug fixes in this area (though this particular problem was never reported) and I would suggest upgrading for a better experience.

Best,
Brian.

[asdf999]

removed

[asdf999]

connection info:
CacheDB
com.intersys.jdbc.CacheDriver
ConnectionProfiles.xml
<Bean Class=”com.genuitec.eclipse.sqlexplorer.utils.ConnectionProfile”>
<activate>false</activate>
<driverIdentifier Class=”net.sourceforge.squirrel_sql.fw.id.UidIdentifier”>
<string>1bae5f5:ffbb2510d3:-7fe2</string>
</driverIdentifier>
<identifier Class=”net.sourceforge.squirrel_sql.fw.id.UidIdentifier”>
<string>596d90f5:10a92703262:-7fb5</string>
</identifier>
<name>jdbc:Cache://localhost:1972/XXXXX</name>
<password encryption=”true”>fatkhiC+laE=</password>
<promptForPassword>true</promptForPassword>
<schema Indexed=”true”/>
<schemaDisplayPolicy>0</schemaDisplayPolicy>
<url>jdbc:Cache://localhost:1972/XXXXX</url>
<userName>XXXXX</userName>
</Bean>
SQLDrivers.xml
<Bean Class=”net.sourceforge.squirrel_sql.fw.sql.SQLDriver”>
<driverClassName>com.intersys.jdbc.CacheDriver</driverClassName>
<identifier Class=”net.sourceforge.squirrel_sql.fw.id.UidIdentifier”>
<string>-6179e658:1021b431aa9:-7fd5</string>
</identifier>
<jarFileName/>
<jarFileNames Indexed=”true”>
<Bean Class=”net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper”>
<string>C:\Program Files\Java\jdk1.5.0_01\jre\lib\ext\CacheDB.jar</string>
</Bean>
</jarFileNames>
<name>Cache</name>
<url>jdbc:Cache://XXXX:1972/XXXX</url>
</Bean>

[asdf999]

on PC with jdk1.5.0_06 same problem
HELP PLEASE!

[Brian Fernandes]

Hi,

Thank you for all the detail. While there certainly is a bug on our side, bad metadata is being returned by your driver which is causing the problem. Could you check for a more recent driver for your database and see if to solves this problem?

I have filed an internal report for this and we hope to have it fixed in the upcoming 5.0 milestone.

Sorry for the inconvenience caused, thanks again for “not giving up” and following through with all the detail.

Best regards,
Brian.

[asdf999]

Last driver makes same problem. There is some Cache DB (InterSystem) anomaly only.
On Oracle is running OK.

[Haris Peco]

asdf999,

Please, can you do next :

1. open connection to your database, click on node ‘Connected too xxxx’ and send us contents of view ‘Db Connection Info’

2. Execute this application (change your info for driver, url , username and password ) and send us output

Thanks

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class CacheTestApp  {

    //private String driverName = "oracle.jdbc.OracleDriver";
    private String driverName = "com.intersys.jdbc.CacheDriver";

    //private String url = "jdbc:oracle:thin:@spnew:1521:V9";
    private String url = "jdbc:Cache://localhost:1972/XXXXX";
    
    private String username = "YOUR_USERNAME";

    private String password = "YOUR_PASSWORD";
    private static Driver driver;

    public CacheTestApp() {
        if (driver == null) {
            try {
                driver = (Driver) Class.forName(driverName).newInstance();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

    public void testCatalog() {
        Connection connection = null;
        try {
            connection = getConnection();
            DatabaseMetaData dm = connection.getMetaData();
            System.out.println("supportsCatalogsInTableDefinition=" + dm.supportsCatalogsInTableDefinitions());
            System.out.println("supportsCatalogsInDataMainputaltion=" + dm.supportsCatalogsInDataManipulation());
            System.out.println("supportsCatalogsInProcedureCals=" + dm.supportsCatalogsInProcedureCalls());
            System.out.println("Catalogs");
            ResultSet rs = dm.getCatalogs();
            int i = 1;
            while (rs.next()) {
                System.out.println("catalog " + i++ + " " + rs.getString("TABLE_CAT"));
            }
            
            System.out.println("supportsSchemasInTableDefinition=" + dm.supportsSchemasInTableDefinitions());
            System.out.println("supportsSchemasInDataMainputaltion=" + dm.supportsSchemasInDataManipulation());
            System.out.println("supportsSchemasInProcedureCals=" + dm.supportsSchemasInProcedureCalls());
            System.out.println("Shemas");
            rs = dm.getSchemas();
            i = 1;
            while (rs.next()) {
                System.out.println("schema " + i++ + " " + rs.getString("TABLE_SCHEM"));
            }
            
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (connection != null)
                    connection.close();
            } catch (SQLException e) {}
        }
    }

    public static void main(String[] args) {
        CacheTestApp test = new CacheTestApp();
        test.testCatalog();
    }
    
    public Connection getConnection() throws SQLException {
        Properties props = new Properties();
        props.setProperty("user", username);
        props.setProperty("password", password);
        return DriverManager.getConnection(url, props);
    }
}

[Author]

Posts