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
Author

Validate SQL Queries

padmanabh dongre
Greenhorn

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

Regards,
Padmanabh
kundi kx
Greenhorn

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
    
    6

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!]
http://www.coderanch.com/t/298353/JDBC/java/Compiling-SQL-statement-before-execute
Good Luck,
Avi.
 
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....