Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
Have you checked out Aspose?
 
subject: Verifying Queries
 
It's not a secret anymore!