RE: DIH jdbc4.MySQLSyntaxErrorException

2012-08-31 Thread Cirelli, Stephen J.
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

RE: DIH jdbc4.MySQLSyntaxErrorException

2012-08-31 Thread Dyer, James
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