Parsing SQL Statements using java

Question

I need to parse sql statements and get column names and table names. I tried with sample code. I got table names but I am stucked to get column names for each table.

I am reading few methods in BO API, I got sql statments from those method, now using that sql i need to take table names and column names and store it in database. I am using strings to read sql — Navyah
– Navyah, Commented May 24, 2013 at 12:08

Mike Q · Accepted Answer · 2013-05-24 11:27:58Z

3

If you really really need to do this then you should look at using a proper parser toolkit like ANTLR. It is quite a steep learning curve but there are grammars around for SQL that others have already built.

Hand-cranking your own parser will lead you down a mess of bugs for anything but the most basic of queries.

answered May 24, 2013 at 11:27

Mike Q

23.3k20 gold badges91 silver badges131 bronze badges

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

1 Comment

Navyah Over a year ago

Can u please provide me sample java code to read data , as I am very new for ANTLR

nakosspy · Accepted Answer · 2013-05-24 12:38:24Z

2

What you need is an SQL parser.

You can try JSQLParser, or ZQL.

I have used both successfully for the same thing the you are trying to do.

You can try also sqlparser. This is commercial however and I have no experience using it.

edited May 24, 2013 at 12:38

answered May 24, 2013 at 12:16

nakosspy

3,9621 gold badge28 silver badges31 bronze badges

Comments

NPKR · Accepted Answer · 2013-05-24 11:35:39Z

1

If you are having ResultSet object then, you can read Column names and Table Names of fired Query.

by using ResultSetMetaData to get MetaData of your query (like table names and column names).

example

answered May 24, 2013 at 11:35

NPKR

5,5265 gold badges35 silver badges48 bronze badges

1 Comment

Navyah Over a year ago

I am not using any Resultset object. I am invoking different API from those methods i am getting sql statments, Now from that sql i need to extract table and column names

Sebastien · Accepted Answer · 2013-05-24 11:32:27Z

0

You will need to create a parser for your SQL grammar. ANTLR allows to create such parsers but it can be quite difficult to create a grammar.

Here is a list of exisiting grammar for ANTLR http://www.antlr3.org/grammar/list.html

It contains grammar for mysql, oracle SQL that should work for you.

answered May 24, 2013 at 11:32

Sebastien

6,7105 gold badges30 silver badges39 bronze badges

Comments

kervin · Accepted Answer · 2014-05-03 00:00:07Z

0

Checkout Foundation Parser http://foundationdb.github.io/sql-parser/

Also note JSQLParser is no longer on SourceForge but maintain at https://github.com/JSQLParser/JSqlParser/wiki

answered May 3, 2014 at 0:00

kervin

11.9k6 gold badges48 silver badges60 bronze badges

Collectives™ on Stack Overflow

Parsing SQL Statements using java

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related