I am in need of a java API to parse a SQL statement.
forFor example, I have a SQL query
SELECT PRODUCTS.PROD_ID, PRODUCTS.PROD_NAME, PRODUCTS.PROD_CATEGORY, PRODUCTS.PROD_TOTAL_ID FROM PRODUCTS I need to retrieve the table name "Products" and the column names as "Prog_ID" etc.
Please provide any links to tutorials ooror code snippets if possible
regards.