File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Validate SQL Queries
Joined: Aug 13, 2001
Feb 18, 2003 23:29:00
Is there any way I can validate the syntax of an SQL query in
without actually executing it in the database ?
Joined: Feb 03, 2003
Feb 19, 2003 10:04:00
CHeck and see if your Database server has a SQL console you can use, and try your SQL there.
Joined: Jul 11, 2001
Feb 19, 2003 10:08:00
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
Joined: Oct 11, 2000
Feb 19, 2003 22:44:00
Asked (and answered -- by me) in this forum:
[Assumes you are using an Oracle database!]
I agree. Here's the link:
subject: Validate SQL Queries
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???
Specifying Table Name Dynamically in Insert Statement....
does OracleDriver really precompile a PreparedStatement?
Java Lib to Validate SQL Query for Syntex
avoid sql injection
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015