[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[dtp-sqldevtools-dev] MySQL select ... for update
|
Hello:
I am trying to use the SQL devtools parser on queries
for a MySQL database.
One of the queries MySQL supports is select ... for update.
Here is a page describing it:
http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html
When I tried used the parser to parse a sample query,
I get this exception:
Exception in thread "main"
org.eclipse.datatools.sqltools.parsers.sql.SQLParserException: Unable to
parse the input: "SELECT col1 FROM table1 FOR UPDATE;".
at
org.eclipse.datatools.sqltools.parsers.sql.AbstractSQLParser.parser(Abstract
SQLParser.java:409)
at
org.eclipse.datatools.sqltools.parsers.sql.SQLParserManager.makeAST(SQLParse
rManager.java:436)
at
org.eclipse.datatools.sqltools.parsers.sql.SQLParserManager.parse(SQLParserM
anager.java:791)
at
org.eclipse.datatools.sqltools.parsers.sql.query.SQLQueryParserManager.parse
Query(SQLQueryParserManager.java:326)
at test.SQLParserTest.main(SQLParserTest.java:28)
Caused by: lpg.lpgjavaruntime.BadParseException
at
lpg.lpgjavaruntime.BacktrackingParser.parse(BacktrackingParser.java:142)
at
lpg.lpgjavaruntime.BacktrackingParser.parse(BacktrackingParser.java:100)
at
org.eclipse.datatools.sqltools.parsers.sql.AbstractSQLParser.parser(Abstract
SQLParser.java:379)
... 4 more
Does the SQL Parser support MySQL's select ... for update query?
Thanks,
Neil
--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.