JSQLParser not able to parse the informatica sql query.

[Jakkani]

Reference: http://www.clearpeaks.com/blog/etl/informatica-best-practice-user-defined-join-syntax-in-the-source-qualifier-transformation

If SQL Query has "{" as mentioned in the above link, JSQL Parser throwing exception.

[wumpz]

Using {} instead of () is a very special use case. JSqlParser does only support ().

[Jakkani]

Thanks for reply, I changed to () and run but my query length is more than 10000 characters. It is showing as ... like LANGUAGE_CODE = '$$LAN... . Please suggest.

[wumpz]

Sorry, but I dont understand what you mean. Give me a concrete example and the output and expected behaviour.

[Jakkani]

Hello, just to know is there any limitation on query length? like max character limit 10000. i am getting the exception like below:

net.sf.jsqlparser.JSQLParserException at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:51) at com.jade.infa.util.SQLUtils.isScalarQuery(SQLUtils.java:414) at com.jade.infa.util.SQLUtils.main(SQLUtils.java:2761) Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "W_PROJ_COST_LINE_FS "" at line 1, column 4116. Was expecting one of: "(" ... "(" ... "(" ... "(" ... "(" ...

[wumpz]

The heap is the limit. So I guess there are syntactical constructs JSqlParser does not know.

[Jakkani]

The below query can not parse since joining condition are in Where clause. And it is showing the above error.

Select columnname1, columnaname2 from W_GL_ACCOUNT_D GL_ACCT_D_CR WHERE { W_PROJ_COST_LINE_FS INNER JOIN W_PROJECT_D ON W_PROJ_COST_LINE_FS.PROJECT_ID = W_PROJECT_D.INTEGRATION_ID AND W_PROJ_COST_LINE_FS.DATASOURCE_NUM_ID = W_PROJECT_D.DATASOURCE_NUM_ID LEFT OUTER JOIN PA_CAL ON W_PROJECT_D.PROJ_OPERATING_UNIT_ID = PA_CAL.ORG_ID } $$HINT2"