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