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
