Re: SQL Syntax Error '????????????????'
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 06/13/09 09:39, David Psiuk wrote:
> please post some javacode. thx
>
>
> Harry Rickards schrieb:
> 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------
>>
>>
It's online at
http://github.com/l33tmyst/dtelectrics/blob/master/src/connect.java, but
I've actually got it working today. I just swapped a few braces ({ or })
around, and it seems to work.
- --
Many thanks
Harry Rickards (GPG Key ID:58449F6F)
- -----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)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iJwEAQECAAYFAkoz8uUACgkQ+9DWHFhEn29fEwP6A7xk88fF/qpYgPXUCyLuOemu
etp595MKXA7G6u9Iy+5pWphh70xxF7/9mRcJEa3nhOb8Y7ru1EURXsShDncxPjRc
wZcn8JB7fwhv5uDK/30BWP7yDtz2cw/2S8PdAlt6+jNdHQtwaxqFEBzjQg//hxc3
8JIK0dRJH3XX0NRaVYU=
=qgij
-----END PGP SIGNATURE-----
Reply to: