I've simplified my code down to it's bare bones, even the SQL statement, but it's still giving the error and I can't work out why. If I copy and paste the SQL statement into an SQL app, it works fine, but I need this to be automated through Java. Maybe you guys can help?
Joined: May 24, 2011
Nvm, I fixed this. I can't have a ; at the end of the SQL statement, even though it's fine in an SQL app, it doesn't work with JDBC.