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

RE: DIH jdbc4.MySQLSyntaxErrorException

2012-08-31 Thread Dyer, James
- From: Cirelli, Stephen J. [mailto:stephen.j.cire...@saic.com] Sent: Friday, August 31, 2012 2: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 quer

DIH jdbc4.MySQLSyntaxErrorException

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