facebook

can’t view data in MySQL database…

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #221064 Reply

    jjupin
    Member

    Okay – version of myEclipse is 3.8.3 -> connecting to a MySQL database. (connector is 2.0.14)… Now the table connector connects and you can see all the tables in the database – and even the schema structure. But when you right click on the table to edit table data – nothing shows. I checked the log and found the following errors:

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Dec 14, 2004 16:22:37.198
    !MESSAGE Error activating columns detail view
    !STACK 0
    java.sql.SQLException: Communication link failure: java.net.SocketException
    at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
    at com.mysql.jdbc.MysqlIO.sqlQuery(Unknown Source)
    at com.mysql.jdbc.Connection.execSQL(Unknown Source)
    at com.mysql.jdbc.Connection.execSQL(Unknown Source)
    at com.mysql.jdbc.Statement.executeQuery(Unknown Source)
    at com.mysql.jdbc.jdbc2.Statement.executeQuery(Unknown Source)
    at com.mysql.jdbc.DatabaseMetaData.getTables(Unknown Source)
    at com.mysql.jdbc.DatabaseMetaData.getColumns(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:940)
    at com.genuitec.eclipse.sqlexplorer.model.TableNode.getColumns(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail$3.run(Unknown Source)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
    at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail.activate(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.DetailManager.activate(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.TableInfoView.setInput(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.DatabaseTreeViewer$4.selectionChanged(Unknown Source)
    at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:159)
    at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:615)
    at org.eclipse.core.runtime.Platform.run(Platform.java:747)
    at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:157)
    at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:1394)
    at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:693)
    at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:718)
    at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:180)
    at org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:175)
    at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:324)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2772)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2431)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1377)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:254)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:141)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:96)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:335)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:183)
    at org.eclipse.core.launcher.Main.run(Main.java:644)
    at org.eclipse.core.launcher.Main.main(Main.java:628)

    any ideas on why I can’t see the data – but can see the schema in the explorer? Thanx…

    peace. JOe…

    #221065 Reply

    jjupin
    Member

    oh forgot to mention – database is remote – on another machine. That’s why I’m assuming the socket connection errors – question is why …

    peace. JOe…

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: can’t view data in MySQL database…

You must be logged in to post in the forum log in