[kbailey]

System Setup ——————————-
Operating System and version: Win xp
Eclipse version: 3.0.2
Eclipse build id: 200503110845
Fresh Eclipse install (y/n): y
If not, was it upgraded to its current version using the update manager?
Other installed external plugins:
Number of plugins in the <eclipse>/plugins directory that begin with org.eclipse.pde.*: 8
MyEclipse version: 3.8.4
Eclipse JDK version: j2rel.4.2_08
Application Server JDK version: Oracle
Are there any exceptions in the Eclipse log file?

If this is a DB related question please answer the following:

RDBMS vendor and version:
JDBC driver vendor and version, and access type (thin, type-2, etc):
Connection URL:
Eclipse error logs related to com.genuitec.eclipse.sqlexplorer packages:

– Message Body ——————————-
I’ve gone through the quickstart for My eclipse Enterprise Workbench. Created database connection and right clicked to create New SQL Editor, written sql statment and received results, but I cannot save the sql script. In the quickstart 5.2 SQL Editing and Snippet Exectuion figure 19 Location of SQL Editor file is empty. I cannot enter/select a parent folder. If I type a filename the Finish button is not active. At the top Create a new empty SQL file it states “The folder is empty” What am I doing wrong

[Riyad Kalla]

bailey,
We need you to fill out the information that you left blank above. Most importantly we need to know the Version and Build of MyEclipse (from Window > Preferences > MyEclipse) as well as the Eclipse (Help > About).

[kbailey]

I’ve added the setup information… sorry about that

[Riyad Kalla]

Bailey,
I could not reproduce this, here is what I did:

1) File > New > SQL Editor, specify the dir I wanted to put it in, hit Finish.
2) Type in SELECT * FROM <table>
3) Clicked “Save” button in the editor… the file was saved to the location I created it in, there is no need to specify another location.

I don’t quite follow your steps above, you said you were able to create a new file with File > New > SQL Editor as the quickstart guide says, but later you mention when you save it you can’t set a parent directory, this seems strange because if you already created the file using File > New, you should not be prompted for a new name or location, the file already exists, it should just be saved out. The only reason I can think of this happening is if the file was *not* created in the first place possibly due to permission issues with your project directory.

[kbailey]

When I do File, New, SQL Editor, the window Create a new empty SQL File, highlights File name: newfile.sql. I can change this name, BUT the Finish button is not active-so I cannot save the new empty file. Above file name, the window is empty and the HOME <- and -> buttons are inactive also, so I cannot choose another directory either. 😥

[Riyad Kalla]

Can you take a screenshot of this and email it to support@genuitec.com ATTN Riyad, I will have to look into this more as I can reproduce this on our test machines here.

As a workaround you can just create a normal file New > File > File, and give it a name ending in .sql which will trigger the SQL Editor to open.

[Riyad Kalla]

Kathleen,
I received your screenshot, very odd indeed. These types of errors (missing strings, missing data, etc.) are almost always caused by incompatiable installed versions of Eclipse and MyEclipse or “dirty” installs that have lots of older or conflicting versions of plugins. Let’s try something real quick, go to File > Switch Workspace > C:\tempworkspace and hit OK to restart MyEclipse. After MyEclipse restarts, try and create a new Web Project, then try and create a new SQL file using the wizard, is everything still empty or did it work? If it worked, then go to File > Switch Workspace and switch back to your old workspace, then hit OK to restart and shut down MyEclipse after it restarts. Then go edit the shortcut you use to start it and add the -clean command line argument as shown here:
http://www.myeclipseide.com/FAQ+index-myfaq-yes-id_cat-30.html#343

Then fire MyEclipse back up (now you can remove the -clean command line arg). Now try and create a SQL file. If that didn’t work, then there is something wrong with your workspace and we will need to create a new workspace and import your other projects.

If NONE of the above worked and it was broken even with the tempworkspace, then we need to do a clean install of Eclipse and MyEclipse to a new location as there is likely an install issue going on here.

[kbailey]

Riyad,

I got the C:\tempworkspace to work, created web project and new sql file. Switched back, restated with -clean and it doesn’t work.

So from your note, I suppose I should uninstall MyEclipse and Eclipse and start over again. I’ll try that again when I have some spare time

Thanks
Kathy

[Riyad Kalla]

So from your note, I suppose I should uninstall MyEclipse and Eclipse and start over again. I’ll try that again when I have some spare time

Actually not that drastic, if the new workspace worked than that is all you need to do, is create a new workspace and then reimport all your projects back into it (File > Import > Existing Project…).

The situation is that Eclipse (and MyEclipse) store ALL their information in your Workspace, so if a new clean workspace works and your existing one does not (and -clean didn’t fix it) then it means there is some broken plugin state being stored in your workspace that is causing MyEclipse to die, so the solution is to create a new workspace and move our projects back into it. Also keep in mind you might want to export your preferences from one and import it into the other.

[Author]

Posts