[tommetoi]

Hello Support,

I am trying to use the DB Explorer perspective. I have 1 DB connection opened ok on the left hand side of Eclipse, and a TEST.SQL window opened on the upper half of the right hand side,
following this instruction:
Section 5.2 “SQL Editing” of http://myeclipseide.com/enterpriseworkbench/help/index.jsp

My problem is at Step 3 “Select the database connection and schema”. This is because I dont have any toolbar for the “database connection” dropdown to work with, as shown in Figure 20. Why?

How can I tell the SQL editor window to “see” and use the connection I already opened on the left hand side “DB Explorer”?

Thank you.

——— My config below ———–
*** Date: Tue Feb 14 16:35:10 PST 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_04

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.0 GA
Build id: 20060122-4.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.0
Build id: I20050627-1435

Eclipse Project SDK

Version: 3.1.0
Build id: I20050627-1435

Eclipse Platform

Version: 3.1.0
Build id: I20050627-1435

Eclipse Java Development Tools

Version: 3.1.0
Build id: I20050627-1435

Eclipse Graphical Editing Framework

Version: 3.1
Build id: 200507071758

Eclipse RCP

Version: 3.1.0
Build id: I20050627-1435

Eclipse Plug-in Development Environment

Version: 3.1.0
Build id: I20050627-1435

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
b38_60
-vm
C:\JDK15\BIN\javaw.exe

[Riyad Kalla]

This might be an editor mapping issue. When you do create the SQL file or open it, does the editor window look similar to the one shown in the screenshot (you see the run icon, save, open, clear) but just not the dropdown? Or does it look nothing like the screenshot?

If it looks nothing like the screenshot, close the file, then right click on it and go to Open With, and select “MyEclipse SQL Editor”, did that do the trick?

[tommetoi]

I was missing the entire toolbar, not just the dropdown box. And you’re right about re-opening the .sql file with “MyEclipse SQL Editor”: the toolbar now appears and usable. I think I was incorrectly using some other “SQL Editor”.

Now a related question. I can run the SQL code successfully now, but I am not getting any output in the bottom “SQL results” window — it’s always empty! How come? The “SQL History” window is good and shown with executed SQL statements.

Thank you.

[Riyad Kalla]

Look here at Figure 22: http://myeclipseide.com/enterpriseworkbench/help/topic/com.genuitec.eclipse.sqlexplorer.doc/doc/quickstarts/dbexplorer/index.html#5-2

So after you enter in your query, and click the “Run” command, you get no result tab in the bottom with results in it, or you do get a results tab, but the table inside of it is empty? (0 rows returned)

[tommetoi]

After enter a SQL query & click on Run command,
I got no individual result tab at all. Only an empty “SQL Results” next to “SQL History” tab.

[Riyad Kalla]

Do me a favor and run “SELECT 1”, do you get a result table?

[tommetoi]

For “select 1”, I got an error:
ORA-00923: FROM keyword not found where expected.

For “select 1 from dual”, I got the result table now, with 1 row of data.

I think my “missing result table” problem was due to my doing DDL statements
(“CREATE TABLE” & “drop table”) and not SELECT/DML statements.

I am cool now. thanks.

[Author]

Posts