Getting Column list from Select queries using JSQLParser.

[satyen1]

Hi All,

I have just started exploring this Parser.
Is there a method already available to get the list of columns referenced in the SELECT queries.

Kindly let me know how I can implement above requirement.

Thanks !

[wumpz]

He @satyen1,

this one should give you a good start: https://stackoverflow.com/questions/40908062/parsing-table-and-column-names-from-sql-hql-java.

Using the TableNamesFinder is always a way to go. Sure you have some overhead for collecting table names as well, but it is a complete implementation of visitors.

Hope that helps.