my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Verifying Queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Verifying Queries" Watch "Verifying Queries" New topic

Verifying Queries

Chinmay Bajikar
Ranch Hand

Joined: Dec 08, 2001
Posts: 159
Hi all,
Is there any Query parser which will look at the Query and tell me that the Query is right.
I m writing a Gui appln to allow user to write a qry thru a gui.After the qry is formed i need to chk if the qry is properly generated.
Thanks in adv,

The strength of the Wolf is the pack & the strength of the pack is the wolf....Rudyard Kipling
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
well someone suggested doing an 'explain plan' for the query.
personally i dont like the idea of syntax checking queries. really the only way you are going to check if the query is ok is by running it.
my 2c
I agree. Here's the link:
subject: Verifying Queries
It's not a secret anymore!