When trying to create a table using clojure.java.sql/create-table I get the exception

Question

When trying to create a table using clojure.java.sql/create-table I get the exception:

batch entry 0: near "-": syntax error
  [Thrown class java.sql.BatchUpdateException]

The create-table call looks like this:

   (sql/create-table :stories
        [:story-id :integer "PRIMARY KEY"]
        [:story-name :text]
        [:story-name-url :text]
        [:category :text]
        [:genre-one :text]
        [:genre-two :text]
        [:created-on :text]
        [:updated-on :text]
        [:review-count :integer]
        [:chapter-count :integer]
        [:word-count :integer]
        [:rating :integer]
        [:language :integer]
        [:is-complete :boolean]
        [:is-crossover :boolean]
        [:type :text]
        [:pairing :text]))))

Joshua · Accepted Answer · 2012-08-01 05:54:15Z

2

The problem is that fields can't have the '-' character in them. Changing the '-' to '_' will fix the problem.

answered Aug 1, 2012 at 5:54

Joshua

6471 gold badge6 silver badges13 bronze badges

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

1 Comment

Joshua Over a year ago

Yes. A lot of the Clojure code I see uses keywords with - instead of _ in them. I think it happens because Clojure users are allowed to use - inside function names so it has become the defacto space-like character. I figure I'm not the only who keeps making this mistake.

Collectives™ on Stack Overflow

When trying to create a table using clojure.java.sql/create-table I get the exception

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related