InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Patty

As you say, Key is a SQL reserved word. I think the [Key] style of escaping
keywords may be a proprietary extension (Access?), but I don't think it's
allowed by the SQL standard.

If you happen to be using InstantDB then you *might* still be able to get
this to work if you add the property

ignoreKeywords=key

to your .prp file then KEY will be removed from the list of recognised
keywords. However, the effect of this on the SQL parsing is pretty hit and
miss.

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Pat Kolysher" <kolysherp@ironsolutions.com>
To: <jdbc-group@enhydra.org>
Sent: Friday, October 06, 2000 4:48 PM
Subject: JDBC: SQLException Error


> Hi. I keep getting an error when executing this query on a data base:
> "SELECT Key, Value FROM My_Database_Name"
> "SELECT [Key], [Value] FROM My_Database_Name"
> "SELECT * FROM My_Database_Name"
>
> ... none of these work. The error message is always the same:
> "java.sql.SQLException: java.sql.SQLException: Incorrect syntax near the
> keyword 'Key'.".
> This means that the attribute (key) in my table is a reserved word. The
>  and ] are supposed to eliminate any ambiguity between parameters and
> reserved words. This SQL query can run from an SQL query analyser, but not
> thru the enhydra server.
>
> Please tell me if you smart fellows have ever seen this before... and
well,
> you guys know the drill.
> Thanks for your time,
>
> Patty K
> :=]
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe jdbc-group" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-jdbc-group@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.