I need to fetch columns of any particular tables by table name. I couldn't find any method in java documentation.
Could you please suggest me any java method or any other solution to get column metadata?
Java JDBC API provides you with this on DatabaseMetadata class, see DatabaseMetaData (Java Platform SE 7 )
If you want to do this using SQL, then Teiid provides "SYS.Columns" table in system metadata. You can execute "select * from Sys.columns where TableName = 'foo'"
Retrieving data ...