aspose file tools*
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
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: 15286
    
    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 - A Test Data Generation Platform
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Validate SQL Queries
 
Similar Threads
does OracleDriver really precompile a PreparedStatement?
Java Lib to Validate SQL Query for Syntex
Specifying Table Name Dynamically in Insert Statement....
avoid sql injection
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???