Skip to main content

Netbeans 7.3 And MySQL Java Connector Versioning Error


Error code 1064, SQL state 42000: 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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

While I was developing J2EE application (using Netbeans 7.3 as my IDE of choice and MYSQL as DB) some days ago, I stumble on the error above.

At first, I thought is was my application querying problem until I made  a little search on the internet. I came across this link which comment helped in solving the issue. 

The solution is:

  1. To download the latest version of MySQL Java Connector,
  2. Copy the jar file into "C:\Program Files\NetBeans 7.3\ide\modules\ext" directory
  3. Open Netbeans Services Panel - Open the Database Node - Open the Drivers Node -Right -Click On the MYSQL(Connector/J Driver) and select Customize
  4. On the customize panel, click add and point to the jar file you copied to "C:\Program Files\NetBeans 7.3\ide\modules\ext
  5. Delete the old path that existed on the customized panel.
  6. Click Ok And Restart Netbeans.


Comments