HELP: SQL Query Validator

[rjuyal]

Hi,
I have created a module in JAVA which lets the user to create the SQL Query through GUI. But at last now i have to validate the Query whether it will executable properly without error or not. how can i do this ? Please help


Thanks
Rakesh

[rjuyal]

I am using execute method of preparedStatement. before executing i set the autoCommit property to false, and at last i roll back also.

in case of exception, i show Invalid Query, otherwise the Query Syntax is correct. I am displaying the exception message in case of failure. The messge is good from a prograamer point of view, but end user can't guess what the message means!!1


if anyone have better solution please let me know.