aspose file tools*
The moose likes JDBC 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
Bookmark "Verifying Queries" Watch "Verifying Queries" New topic
Author

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


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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Verifying Queries