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

Post a Comment

Popular posts from this blog

Fix HTTP error code 513 on Wildfly

The Mysterious Case of TIME_WAIT and IDLE Connections Have you ever encountered a network issue where your server is consistently showing a high number of connections in the TIME_WAIT and IDLE states? This phenomenon can be frustrating, especially when it indicates that the connections are not being closed properly by the server or client. In our investigation, we found that the culprit behind this issue was an HTTP error code 513 being sent to clients from servers. This error code indicates that the server is overloaded and cannot handle more requests. Furthermore, the client was logging a socket close event, which meant it was terminating the connection prematurely. To replicate this issue, we used JMeter and found that the max concurrent connection limit was reached, resulting in an HTTP error code 513. The allowed queue was also full, contributing to the problem. So, what are the consequences of this issue? Performance degradation and resource wastage on both servers and clients ca...
Post a Comment
Read more

Java Client SSL Setup and Related Errors

Troubleshooting Tips for Effective Configuration Configuring Secure Sockets Layer (SSL) is a crucial step in ensuring the security of your Java client's communication. In this article, we'll walk you through the process of configuring SSL and provide guidance on troubleshooting common errors that may arise during the setup. To troubleshoot issues effectively, follow these steps: - Enable the JVM option -Djavax.net.debug=all - Capture the network traffic dump for faster analysis. Certificate Setup Go to your console and access your <JAVA_HOME>/bin/keytool NB :  The default location for saving the generated files is the user home directory. You can change this by specifying a path. STEP 1: Generate a new key (private key) for a Keystore. This either creates a file called <KEYSTORE_NAME>.keystore or update an existing file if it already exists. The CSR which will be presented to a Certificate Authority (CA) will be generated with this key and alias. <J...
Post a Comment
Read more