Need java API to parse SQL statements [closed]

Question

I am in need of a java API to parse a SQL statement.

For 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 or code snippets if possible.

possible duplicate of SQL parser library for Java

codingbadger
– codingbadger

2011-06-15 12:51:05 +00:00
Commented Jun 15, 2011 at 12:51 — codingbadger
– codingbadger, Commented Jun 15, 2011 at 12:51

Gábor Lipták · Accepted Answer · 2013-08-16 12:36:17Z

4

ANTLR is a parser generator that has a SQL grammar, but that might be more than you bargained for.

It would be simpler to write one on your own, as long as your requirements didn't get too crazy. How general do you need to be?

edited Aug 16, 2013 at 12:36

Gábor Lipták

9,8343 gold badges62 silver badges117 bronze badges

answered May 4, 2011 at 10:25

duffymo

310k46 gold badges376 silver badges571 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

James Anderson Over a year ago

Been there done that! Parsing SQL is a bit of a nightmare -- you need to parse a specific dialect (ORACLE,SQLServer etc.). The vast number of keywords, the inconsistent syntax, the overloading of keywords means you need a massive and complex grammar.

user727272 Over a year ago

I have a very simple requirement, the query posted above is the only format i ll be using.

Vineet Reynolds Over a year ago

@user727272, in that case, you can construct the ANTLR grammar to suit only that format, and parse it. I would suggest getting a copy of Terrence Parr's book - The Definitive ANTLR Reference, if you are finding the tutorials on the ANTLR site to be difficult.

amphibient Over a year ago

parsing SQL is beyond a nightmare... see the post i just made: stackoverflow.com/questions/12863532/…

duffymo Over a year ago

No wonder - you tried to mangage vendor-specific SQL with regex? Your situation sounds like a case study for "do not do this."

user330315 · Accepted Answer · 2011-06-15 08:27:13Z

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.

user727272 · Accepted Answer · 2011-05-05 07:08:15Z

2

Ended up using ZQL Parsing libraries from http://zql.sourceforge.net/.

If you are having simple queries , that should do the job easily

answered May 5, 2011 at 7:08

user727272

4752 gold badges10 silver badges20 bronze badges

2 Comments

user447356 Over a year ago

Please mark this as the Accepted answer unless there is better answer by now.

sky Over a year ago

Does ZQL parser allow us to get table names if we have Joins?

James Wang · Accepted Answer · 2012-01-08 12:27:01Z

Regex matching is only work for simple query, SQL has a complex recursive grammer, and, there will always be some sub select, group by, or literal that will break your regex based parser.

Here is a demo illustrates how to achieve what you need by using general sql parser:

Collectives™ on Stack Overflow

Need java API to parse SQL statements [closed]

4 Answers 4

5 Comments

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

2 Comments

Comments

Linked

Related