I have a mysql database on Netbeans and I want to see that view data but I have a error 1064 'OPTION SQL_SELECT_LIMIT=DEFAULT'
. how can I fix ? thanks.
Some google foo lead me to this:
http://bugs.mysql.com/bug.php?id=66659
That bug report sound pretty much like your problem - there is no good fix for you. But there is a lead for some more reading.
The similarity to you problem:
So I tried to find the problem in the mysql-connector-java sources and found the statement in StatementImpl.java
in version 5.1.18 - an older version can be found here:
http://www.docjar.com/html/api/com/mysql/jdbc/StatementImpl.java.html
Look for "SET OPTION SQL_SELECT_LIMIT=DEFAULT
" in the file and you will find it.
I also checked the most recent version
I checked the source of mysql-connector-java 5.1.22 and the problem seems to be fixed:
SET SQL_SELECT_LIMIT=DEFAULT
So suggested fix for the user: Please download the newer version of connector/j and modify the driver entry in databases.
Suggested fix: Update bundled connector/j version
Found the answer from another question... The steps are quite straightforward.
Download latest jar file from here: http://dev.mysql.com/downloads/mirror.php?id=412737. Unzip it Copy jar file "mysql-connector-java-5.1.25-bin.jar
" to this folder: C:\Program Files\NetBeans 7.3\ide\modules\ext
In Netbeans IDE: Disconnect from database. Click Services. Expand Drivers. Right-click on MySQL and press Customize. Add latest driver Remove previous driver.
Re-connect to dabatase within IDE.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With