Looks like it was because it was on multiple lines. Or there was a tab
in there. I put the query all on one line and it runs now.
-Original Message-
From: Cirelli, Stephen J.
Sent: Friday, August 31, 2012 3:22 PM
To: solr-user@lucene.apache.org
Subject: DIH jdbc4.MySQLSyntaxErrorException
I have very long SQL statements that span multiple lines and it works for me.
You might want to paste your SQL into a tool like Squirrel and see if it
executes outside of DIH. One guess I have is you've got something like this...
where blah='${my.property}'
...but the variable is not resolving