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


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