One Star

SQL Builder hangs

I am using 5.61.20141207_1530. When I open SQL Builder I cannot close it - whatever I do it doesn't react to any button.
This is a third issue I encounter in first a half an hour. Is it ever been tested?
8 REPLIES
Moderator

Re: SQL Builder hangs

Hi,
What's your OS? Is there any error log which is located in <Talend Studio installation path>/workspace/.metadata/.log?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: SQL Builder hangs

I have the same error, same TOS version, OS: windows 7 32 bits.

!ENTRY org.eclipse.ui 4 0 2015-05-26 16:03:39.044
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NoClassDefFoundError: net/sourceforge/squirrel_sql/fw/sql/ISQLAlias
at org.talend.sqlbuilder.ui.SQLBuilderDialog.clean(SQLBuilderDialog.java:448)
at org.talend.sqlbuilder.ui.SQLBuilderDialog.close(SQLBuilderDialog.java:442)
at org.eclipse.jface.dialogs.Dialog.okPressed(Dialog.java:940)
at org.talend.sqlbuilder.ui.SQLBuilderDialog.okPressed(SQLBuilderDialog.java:645)
at org.eclipse.jface.dialogs.Dialog.buttonPressed(Dialog.java:472)
at org.talend.sqlbuilder.ui.SQLBuilderDialog.access$3(SQLBuilderDialog.java:1)
at org.talend.sqlbuilder.ui.SQLBuilderDialog$1.widgetSelected(SQLBuilderDialog.java:398)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.talend.sqlbuilder.actions.EditQueriesAction.doRun(EditQueriesAction.java:171)
at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:632)
at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:93)
at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:237)
at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3204)
at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:1985)
at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:641)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.rcp.intro.Application.start(Application.java:167)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
Caused by: java.lang.ClassNotFoundException: net.sourceforge.squirrel_sql.fw.sql.ISQLAlias
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:506)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 49 more
One Star

Re: SQL Builder hangs

I have the same error, same TOS version, OS: windows 7 32 bits.
the  previous error message  is mine, 
i mistaken my keybord.
One Star

Re: SQL Builder hangs

it seems to check with this bug:
https://jira.talendforge.org/browse/TDI-31792
thanx
Moderator

Re: SQL Builder hangs

Hi,
Do you take a try on Talend OPen Studio's 6.0.0.M5 to see if this issue is fixed?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: SQL Builder hangs

I'm using TOS 6.1.1.20151214_1327 and having the same issue. When is it targeted to get fixed?
One Star

Re: SQL Builder hangs

Dear all,
Problem stil exists in Talend 6.1 (TOS_DI-20151214_1327-V6.1.1).
To generate the problem (under Windows 7) :
- download Talend,
- extract, execute (I used the x32 executable)
- add the driver to the db used (if necessary)
- cancel thirdparty plugins download (more than 50 !).
Then :
- Create a connection,
- get the schema of one table,
- create a query (right click on the connection edit the query) => query editor will refuse to close (killing Talend is the only solution).
Solved by : downloading all recommended 50 or so add-ons (I do not know which one is mandatory for solving the issue*).
Recommendation for the Talend dev team :
- FORCE DOWNLOAD the third party plugin that solves the issue,
- or distribute it automatically with Talend,
- or mention which thirdparty plugins MUST be installed for correct operation.
Best regards,
Ronan.
*Note that I found this after solving my issue : In bug TDI-32609, a workaround suggested that problem was solved after installing "sqlexplorer.jar" and "squirrel.jar" (are these the plugins that are mandatory ?).
One Star

Re: SQL Builder hangs

Thanks RonanT@, installing all modules available resolves this problem