[jrpe]

Hi!

(same installation info as my previous topic)

When selecting a table (Sybase) all tabs in the view Table/Object Info works except:
Foreign Keys – displays no results
Preview – nothing is displayed and I get a message at the bottom of the view:
Incorrect syntaxt near ‘[‘

I get the following exception for the Preview tab:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2007-06-18 15:14:43.198
!MESSAGE Error activating preview
!STACK 0
com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near ‘[‘.

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1537)
at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1522)
at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:402)
at com.genuitec.eclipse.sqlexplorer.model.TableNode.getPreview(TableNode.java:286)
at com.genuitec.eclipse.sqlexplorer.views.details.PreviewDetail$1.run(PreviewDetail.java:86)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at com.genuitec.eclipse.sqlexplorer.views.details.PreviewDetail.activate(PreviewDetail.java:78)
at com.genuitec.eclipse.sqlexplorer.views.DetailManager$1.widgetSelected(DetailManager.java:271)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1930)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1894)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:422)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
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:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)

[Riyad Kalla]

Sounds like a driver issue… can you try another JDBC driver and see if that does the trick? For sybase, see here:
https://www.genuitec.com/forums/topic/db-where-can-i-download-a-sybase-jdbc-driver/

[Author]

Posts