GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — [BUG] JSQLParser 5.0: RDBMS : SQL was automatically intercepted · Issue #2193 · JSQLParser/JSqlParser Closed as duplicate DescriptionAlways check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram Failing SQL Feature:SQL was automatically intercepted SQL Example:select * from user WHERE userId = ? and ( userHead like '%' || ? || '%' or itemName like '%' || ? || '%' or itemCode like '%' || ? || '%' ) Software Information:
Tips:When there are more than 2 consecutive /n, the SQL will be automatically truncated. I use My Demo is String sql = "select * from user\n" + " WHERE userId = ?\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + " and (\n" + " userHead like '%' || ? || '%'\n" + " or itemName like '%' || ? || '%'\n" + " or itemCode like '%' || ? || '%'\n" + " )"; CCJSqlParser parser = CCJSqlParserUtil.newParser(sql); parser.withSquareBracketQuotation(true); try { Statement statement = parser.Statement(); System.out.println(statement); }catch (ParseException e) { throw new RuntimeException(e); } Activity
MetadataMetadataAssigneesLabelsNo labels TypeProjectsMilestoneRelationshipsDevelopmentIssue actions |
| You are visitor 01402503 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |