wood burning stoves
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

Win a copy of Elasticsearch in Action this week in the Big Data forum!
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
Don't get me started about those stupid light bulbs.
subject: Verifying Queries