wood burning stoves 2.0*
The moose likes JDBC and the fly likes Validate SQL Queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Validate SQL Queries" Watch "Validate SQL Queries" New topic

Validate SQL Queries

padmanabh dongre

Joined: Aug 13, 2001
Posts: 24
Is there any way I can validate the syntax of an SQL query in java without actually executing it in the database ?

kundi kx

Joined: Feb 03, 2003
Posts: 10
CHeck and see if your Database server has a SQL console you can use, and try your SQL there.
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299

If you are needing the syntax to be checked in your program, look into Regular Rxpressions for checking the syntax. It's how compilers work.

GenRocket - Experts at Building Test Data
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Hi Padmanabh,
Asked (and answered -- by me) in this forum:
[Assumes you are using an Oracle database!]
Good Luck,
wood burning stoves
subject: Validate SQL Queries
Similar Threads
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???
does OracleDriver really precompile a PreparedStatement?
Java Lib to Validate SQL Query for Syntex
avoid sql injection
Specifying Table Name Dynamically in Insert Statement....