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 Is there some limitation to how complex of a select I can use? I'm getting this error when I try to execute my query. The query runs fine inside MySQL Workbench. " Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" It's a very vague error message with not information. I have no idea what the error could be. In my DIH xml on the entity I have the query property, the query spans multiple lines. Does it all have to be on one line? I can't figure out why I get this error. Thanks for the help, Steve
