Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to validate a query from Java.

843859Jan 25 2008 — edited Nov 20 2014
Hello,
I want to check weather my query
(i.e. select * from table1 where field1 = 'abcd') is valid or not. (By asking database)
I mean it should check syntax as well as table names, fields, values etc.
& respond me in true or false (or OK or not).

I am using SQL Server 2005 (It is having this facility in SQL Server User Management Studio)

Thanks,
- Nachiket
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2008
Added on Jan 25 2008
7 comments
809 views