You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bruce Wen (JIRA)" <ji...@apache.org> on 2011/01/04 11:18:46 UTC

[jira] Updated: (DERBY-4957) describe and show command failed in Eclipse Plugin

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

Bruce Wen updated DERBY-4957:
-----------------------------

    Description: 
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

  was:
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.

It seems that show and describe commands can not be recognize by the SQL Engine of Eclipse Derby plugin.


> describe and show command failed 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
>
> 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.