Results 1 to 2 of 2
  1. #1
    rjuyal's Avatar
    rjuyal is offline Senior Member
    Join Date
    Mar 2008
    Location
    Delhi, India
    Posts
    194
    Rep Power
    7

    Default HELP: SQL Query Validator

    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:confused:


    Thanks
    Rakesh

  2. #2
    rjuyal's Avatar
    rjuyal is offline Senior Member
    Join Date
    Mar 2008
    Location
    Delhi, India
    Posts
    194
    Rep Power
    7

    Default Solved

    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.
    i am the future

Similar Threads

  1. Struts Validator
    By anoop.retnakumar in forum Web Frameworks
    Replies: 1
    Last Post: 03-05-2008, 06:54 AM
  2. sql validator
    By Joe2003 in forum Advanced Java
    Replies: 0
    Last Post: 02-07-2008, 05:23 PM
  3. Commons validator
    By aczuczor in forum Web Frameworks
    Replies: 0
    Last Post: 07-27-2007, 08:46 AM
  4. Replies: 1
    Last Post: 07-06-2007, 04:39 PM
  5. Validator framework
    By Daniel in forum Web Frameworks
    Replies: 1
    Last Post: 06-25-2007, 05:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •