List:MySQL and Java« Previous MessageNext Message »
From:Harry Rickards Date:June 13 2009 10:28am
Subject: SQL Syntax Error '????????????????'
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've written some sample code in Java that connects to localhost using
the MySQL JDBC. I've tried multiple variations of the code, but even
when using the proper code from MySQL's website, I get the following error:

SQLException: 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 '????????????????' at line 1
SQLState: 42000
VendorError: 1064

I don't know where the question marks are coming from, as there aren't
even any question marks in the code. The code is at
http://github.com/l33tmyst/dtelectrics/blob/master/src/connect.java, and
if it's any help I'm using Eclipse 3.4.2 on Debian Sid. The java version is:

hrickards <at> siddy:~$ java -version
java version "1.6.0_14"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) Client VM (build 14.0-b16, mixed mode, sharing)

and the kernel version is 2.6.26-1-486. I've tried STFW, but I can't
find anyone with a similar problem.

- -- 
Many thanks
Harry Rickards (GPG Key ID:646ED06A)

- -----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GAT/GCM/GCS/GCC/GIT/GM d? s: a? C++++ UL++++ P- L+++ E--- W+++ N o K+
w--- O- M- V- PS+  PE Y+ PGP++ t 5 X R tv-- b+++ DI D---- G e* h! !r y?
- ------END GEEK CODE BLOCK------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iJwEAQECAAYFAkozYucACgkQ+9DWHFhEn29s1wP+IKe3V1ACtMCAPgvtl5ZYwk/j
dyGeHe3f3twv2vBviwbXxWQsafEiVOXyyu4R/qJQfT+E30rJ/ogo8L2h5ciGYFGV
kgcbw94Hg+VAQ+ohTOw30tF4P2QCMfGSV/D58lo6Uym5bS4BEF8CXtVfX2hyAHxT
C2gs0Z4Ec4CvRoaa2c0=
=RSf+
-----END PGP SIGNATURE-----

Thread
SQL Syntax Error '????????????????'Harry Rickards13 Jun 2009
Re: SQL Syntax Error '????????????????'Harry Rickards13 Jun 2009