[jira] Resolved: (DERBY-4957) describe and show commands failed to execute in Eclipse Plugin

["Myrna van Lunteren (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-4957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren resolved DERBY-4957.
---------------------------------------

    Resolution: Invalid

That "SQL Editor" is not something the Derby plugin provides, our sql tool is "ij" which you can access through the Derby Nature...And you said ij works correctly.

It seems to me that the "SQL Editor" is using a version of derby older than 10.2 (so, 10.1, most likely), in which describe and show were not supported. 

Perhaps there is a way you can change the classpath used by the "SQL Editor"  to use the derby*.jar files provided with the 10.4.2 core plugin, but I cannot guarantee that it will work, and/or not break something else.
Perhaps you can get support/help/suggestions for this via the eclipse forum...

Resolving as 'invalid' which is our way to say this is not a bug in code under our control.

> describe and show commands failed to execute in Eclipse Plugin
> --------------------------------------------------------------
>
>                 Key: DERBY-4957
>                 URL: https://issues.apache.org/jira/browse/DERBY-4957
>             Project: Derby
>          Issue Type: Bug
>          Components: Eclipse Plug-in
>         Environment: Eclipse Ganymede (3.4) - Eclipse IDE for Java EE Developers
> Build id: I20080617-2000
> Windows XP Professional
> Dell OPTIPLEX 755
>            Reporter: Bruce Wen
>         Attachments: Derby_ShowCommandFailed.jpg
>
>
> Reproduce Steps:
> 1. Install Derby plugin to Eclipse
> 2. Connect to Derby database 
> 3. Create a SQL file
> 4. Execute "show schemas;" statement --- Execution failed and syntax error message "Encountered "show" at line 1, column 1." showed in status panel.
> 5. Execute "describe task;" statement --- Execution failed and syntax error message "Encountered "describe" at line 1, column 1." showed in status panel. Note: task is the table name.
> Note:
> 1. It seems that show and describe commands can not be recognize by the SQL Engine of Eclipse Derby plugin.
> 2. commands create, drop, select, update, delete, insert work well

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.