Re: [OT] SQL Syntax Error '????????????????'
On 10 Jun 2009, at 23:32, s. keeling keel...@nucleus.com wrote: Harry Rickards hricka...@l33tmyst.com: I know this is off-topic, but I don't really want to have to subscribe to or constantly read the MySQL mailing lists, and the IRC channel's no help. Search the archives: groups.google.com comp.databases.mysql # guessing. However, I think your problem more relates to java than sql. I'll have a look, but I'd have thought if it was in there Google would have come up with it. 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 Does your query run in a commandline session with the db? All it does is connect, there's no query. -- Any technology distinguishable from magic is insufficiently advanced. (*)http://blinkynet.net/comp/uip5.html Linux Counter #80292 - -http://www.faqs.org/rfcs/rfc1855.htmlPlease, don't Cc: me. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Re: [OT] SQL Syntax Error '????????????????'
Harry Rickards hricka...@l33tmyst.com: I know this is off-topic, but I don't really want to have to subscribe to or constantly read the MySQL mailing lists, and the IRC channel's no help. Search the archives: groups.google.com comp.databases.mysql # guessing. However, I think your problem more relates to java than sql. 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 Does your query run in a commandline session with the db? -- Any technology distinguishable from magic is insufficiently advanced. (*)http://blinkynet.net/comp/uip5.html Linux Counter #80292 - -http://www.faqs.org/rfcs/rfc1855.htmlPlease, don't Cc: me. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
[OT] SQL Syntax Error '????????????????'
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I know this is off-topic, but I don't really want to have to subscribe to or constantly read the MySQL mailing lists, and the IRC channel's no help. 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: hricka...@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) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkotN+YACgkQ1kZz3mRu0GrC9wCgtJB9qZ8UhGiB3jtn6DwoYih6 r/4AoM4LQdgG5e2nrkEWnEOOwzs2vk4I =b/Xo -END PGP SIGNATURE- -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org