Build: NetBeans IDE 6.7.1 (Build 200907230233)
VM: Java HotSpot(TM) Client VM, 14.0-b16, Java(TM) SE Runtime Environment, 1.6.0_14-b08
OS: Windows XP, 5.1, x86

User Comments:
GUEST: Editing SQL query in PHP file

GUEST: just trying to get sql auto completion to work

GUEST: mysql autocompletion

GUEST: just trying to get the sql auto-completion, It had already happend a few times. This is boring because I got to restart netbeans in order to make it work !!!!

dako3256: Inserting code into file, was using (ctrl+spacebar) for auto-complete.

gawan: after write "SELECT FROM " I press CTRL+SPACE

GUEST: trying to get the sql auto-completion

GUEST: Attempting to launch sql code complete in a php project using ctrl + space.



Stacktrace: 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:


** BEGIN NESTED EXCEPTION ** 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
MESSAGE: The last packet successfully received from the server was41575 seconds ago.The last packet sent successfully to the server was 41575 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was41575 seconds ago.The last packet sent successfully to the server was 41575 seconds ago, which  is longer than the server configured value of 'wai
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeConstructorAccessorImpl.java:0)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)