[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    SQL Syntax Error '????????????????'
From:       Harry Rickards
Date:       2009-06-13 8:28:00
Message-ID: loom.20090613T082536-124 () post ! gmane ! org
[Download RAW message or body]

-----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-----


[prev in list] [next in list] [prev in thread] [next in thread]