Meaningless Drivel is fun!*
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


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Verifying Queries