Validate SQL Queries

[padmanabh dongre]

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]

CHeck and see if your Database server has a SQL console you can use, and try your SQL there.

[Gregg Bolinger]

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.

[Avi Abrami]

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.