Clojure MySQL Syntax Error Exception ("[...] near '????????????????' [...]")

Question

I'm having trouble doing anything with clojure.contrib.sql beyond establishing a connection.

I have a mysqld running on localhost:3306 with a database called clj_db. The user 'clj_user'@'localhost' with password 'clj_pass' can access this database.

When trying to "select * from clj_table" I get a "com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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".

What am I doing wrong?

clj_db.clj_table

CREATE TABLE `clj_table` (
  `col_one` int(11) NOT NULL,
  `col_two` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

mysql_test.clj

(ns test.mysql
    (:use clojure.contrib.sql)
)

(def db-settings
    {:classname "com.mysql.jdbc.Driver"
    :subprotocol "mysql"
    :subname "//localhost:3306/clj_db"
    :user "clj_user"
    :password "clj_pass"})

(with-connection db-settings
    (with-query-results rs ["select * from clj_table"]
        (dorun (map #(println (:col_one :col_two %)) rs))
    ))

Output

Exception in thread "main" com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 (mysql_test.clj:0)
   at clojure.lang.Compiler.eval(Compiler.java:4658)
   at clojure.lang.Compiler.load(Compiler.java:4972)
   at clojure.lang.Compiler.loadFile(Compiler.java:4939)
   at clojure.main$load_script__7405.invoke(main.clj:213)
   at clojure.main$script_opt__7442.invoke(main.clj:265)
   at clojure.main$main__7466.doInvoke(main.clj:346)
   at clojure.lang.RestFn.invoke(RestFn.java:441)
   at clojure.lang.Var.invoke(Var.java:367)
   at clojure.lang.AFn.applyToHelper(AFn.java:179)
   at clojure.lang.Var.applyTo(Var.java:476)
   at clojure.main.main(main.java:37)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1048)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
   at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1859)
   at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3593)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2199)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:350)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
   at java.sql.DriverManager.getConnection(libgcj.so.10)
   at clojure.contrib.sql.internal$get_connection__218.invoke(internal.clj:85)
   at clojure.contrib.sql.internal$with_connection_STAR___226.invoke(internal.clj:102)
   at test.mysql$eval__386.invoke(mysql_test.clj:12)
   at clojure.lang.Compiler.eval(Compiler.java:4642)
   ...10 more

Additional Information: clojure-1.1.0 --- clojure-contrib-1.1.0 --- mysql-connector-java-5.1.11-bin --- java 1.5.0 --- mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1 — uuid0
– uuid0, Commented Jan 31, 2010 at 0:39

uuid0 · Accepted Answer · 2010-01-31 01:30:38Z

2

I've switched to Sun's JDK6 instead of GIJ.

I got "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure". I found this thread, which really helped me a lot.

I've added the option "-Djava.net.preferIPv4Stack=true" and it now works fine.

Thanks everybody!

answered Jan 31, 2010 at 1:30

uuid0

3192 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

knt2e4 · Accepted Answer · 2012-08-07 11:01:15Z

1

I was having the exact same problem only I was using Java. I found this post and the solution described there worked for me.

The trick was to add "useJvmCharsetConverters=true" to the end of the connection-string.

answered Aug 7, 2012 at 11:01

knt2e4

111 bronze badge

Comments

Community · Accepted Answer · 2017-05-23 10:33:01Z

0

the code looks very similar to the (presumably working) code in This Question
perhaps its a problem with the version of clojure-contrib.

when I macroexpand the code from these two question they come out the same so it seems likely that the problem is not with the contents of mysql_test.clj.

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Jan 30, 2010 at 1:45

Arthur Ulfeldt

91.7k30 gold badges205 silver badges285 bronze badges

1 Comment

uuid0 Over a year ago

Yup, I had a look at that, too. Just to be sure I've downloaded clojure and clojure-contrib releases again, but I get the same output.

Collectives™ on Stack Overflow

Clojure MySQL Syntax Error Exception ("[...] near '????????????????' [...]")

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related