From: James Doucette
Date: July 21 1999 5:18pm
Subject: connection problems....
List-Archive: http://lists.mysql.com/java/221
Message-Id: <Pine.SGI.3.91.990721101219.2728C-100000@indy1.pgweb.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


I've been working with java in conjunction with a mysql database to 
produce a variety of company applications.  We have recenlty moved the 
mysql database to a different machine and therefore I have been moving 
code over and setting up the necessary access privileges to the mysql 
database....  Even though I conquered this problem on my own before (on 
the old machine), I don't have the time and patience to muddle around 
again... this is why I'm looking for some general suggestions.  My code 
is correct because it worked on the old machine and the mysql database 
installed on the new machine is the same version... so here is my error 
message:

java.sql.SQLException: Error during 
query: Syntax error or access violation: parse error near ';' at line 1


the stack trace is:

java.sql.SQLException: Error during query: Syntax error or access
violation: parse error near ';' at line 1 java.lang.NullPointerException
        at employeeupdate.populatelist(employeeupdate.java:703)
        at employeeupdate.init(employeeupdate.java:663)
        at sun.applet.AppletPanel.run(AppletPanel.java:287)
        at java.lang.Thread.run(Thread.java:474)

any ideas....