Parser to parse an SQL query and return the column name's and the corresponding table name in Java [duplicate]

Question

Possible Duplicate:
SQL parser library for Java

I need a parser that should return me column names with their corresponding table names in the format

column_name table_name

Preferably a java library, that can make the implementation easier as I dont want to get into all the nuances of SQL parsing.

regards,

Answer 1

If you have a connection to the database, you can do that using a prepared statement:

String sql = "....";
PreparedStatement pstmt = connection.prepareStatement(sql);
ResultSetMetaData meta = pstmt.getMetaData();

Then you can use ResultSetMetaData.getColumnCount() and getColumnName(int) to retrieve the column names. If your JDBC driver supports it, you can even get the underlying table name using getTableName(int)

Note that not all drivers support getting the metadata before actually executing the statement, you need to test that with the one you are using.

Answer 2

Good question! I have just performed some google search and found the following interesting references:

SQL parser library for Java

http://www.gibello.com/code/zql/

http://www.sqlparser.com/sql-parser-java.php

I hope this helps.