db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bruce Wen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4957) describe and show commands failed to execute in Eclipse Plugin
Date Wed, 05 Jan 2011 14:19:46 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12977773#action_12977773
] 

Bruce Wen commented on DERBY-4957:
----------------------------------

Hi Myrna,

You are right. The commands work fine by Apache Derby -> Run SQL script using 'ij'

My problem is the execution in SQL editor. Highlight statement "show schemas;" and Right click
-> Execute Selected Text. In SQL Results view, you will see Syntax Error:Encountered
"show" at line 1, column 1. See attached snapshot for reference.

Answers for your questions:
1. Eclipse: eclipse-jee-ganymede-SR2-win32.zip
2. Derby Plugin: derby_core_plugin_10.4.2.zip and derby_ui_plugin_1.1.2.zip
3. Derby Plugin's jar files are correct.
4. The problem occurred no matter new database or existing database.

In default, eclipse-jee-ganymede-SR2-win32 provides derby plugin. The following jar files
are in ECLIPSE_HOME/plugins:
org.eclipse.datatools.connectivity.apache.derby.dbdefinition_1.0.2.v200901090940.jar
org.eclipse.datatools.connectivity.apache.derby.ui_1.0.1.v200807010433.jar
org.eclipse.datatools.connectivity.apache.derby_1.0.3.v200902070611.jar
org.eclipse.datatools.sqltools.db.derby_1.0.0.v200805152355.jar
org.eclipse.datatools.modelbase.derby_1.0.0.v200805152355.jar

And in ECLIPSE_HOME/plugins/org.apache.derby.core_10.4.2:
derby.jar
derbyclient.jar
derbynet.jar
derbyrun.jar
derbytools.jar

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


Mime
View raw message