Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 333621 - show and describe failed to execute in SQL Editor
Summary: show and describe failed to execute in SQL Editor
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: SQL Editor Framework (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: dtp.sqldevtools-inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-06 00:12 EST by Bruce Wen CLA
Modified: 2011-01-06 15:47 EST (History)
1 user (show)

See Also:

Attachments
show command failed to execute from SQL Editor (39.75 KB, image/jpeg)
2011-01-06 00:17 EST, Bruce Wen CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Bruce Wen CLA 2011-01-06 00:12:12 EST 
Build Identifier: I20080617-2000

show and describe commands failed to execute from SQL Editor. The following message displayed:
Encountered "show" at line 1, column 1

Reproducible: Always

Steps to Reproduce:
1. connect to derby database in Data Source Explorer
2. create a sql file: Type - Derby_10.x; Name - connection name; database - derby database name
3. type SQL statement "show schemas;" or "describe ${TableName}"
4. high-light the statement and right click -> execute selected text

Expected Result:
The SQL statement executed successfully

Actual Result:
Failed and error message says: Encountered "show" at line 1, column 1
Comment 1 Bruce Wen CLA 2011-01-06 00:17:27 EST 
Created attachment 186143 [details]
show command failed to execute from SQL Editor
Comment 2 Brian Payton CLA 2011-01-06 15:47:08 EST 
"show" and "describe" are Derby ij commands, not SQL statements.  DTP uses JDBC to connect to the Derby database, so it can only issue SQL statements to the database.