The first lines of the trace says:
Failure to execute query with SQL:
SELECT "GUESTBOOK" .* FROM "GUESTBOOK" :: []
JdbcSQLException:
Message: Table "GUESTBOOK" not found; SQL statement
SELECT "GUESTBOOK".* FROM "GUESTBOOK" ...
I see that there is a "create-guestbook-table" in schema.clj
(defn create-guestbook-table []
(sql/with-connection
db-spec
(sql/create-table
:guestbook
[:id "INTEGER PRIMARY KEY AUTO_INCREMENT"]
[:timestamp :timestamp]
[:name "varchar(30)"]
[:message "varchar(200)"])
(sql/do-commands
"CREATE INDEX timestamp_index ON guestbook (timestamp)")))
which is called by create-tables function underneath it
(defn create-tables
"creates the database tables used by the application"
[]
(create-guestbook-table))
How can I find out why this table is not created?
I copied the code from this tutorial
http://www.luminusweb.net/docs/guestbook.md
I am looking for help about how to read these traces and good practice to
debug. This is just my first clojure project.
And these are the references and line numbers to .clj files in the trace
that I could find:
db.clj line #21
20 (defn get-messages []
21 (select guestbook))
home.clj line #34
33 (defn about-page []
34 (GET "/" [] (home-page))
The entirety of the trace is copied below:
Failure to execute query with SQL:
SELECT "GUESTBOOK".* FROM "GUESTBOOK" :: []
JdbcSQLException:
Message: Table "GUESTBOOK" not found; SQL statement:
SELECT "GUESTBOOK".* FROM "GUESTBOOK" [42102-174]
SQLState: 42S02
Error Code: 42102
org.h2.jdbc.JdbcSQLException: Table "GUESTBOOK" not found; SQL statement:
SELECT "GUESTBOOK".* FROM "GUESTBOOK" [42102-174]
DbException.java:332
org.h2.message.DbException.getJdbcSQLException
DbException.java:172 org.h2.message.DbException.get
DbException.java:149 org.h2.message.DbException.get
Parser.java:4900 org.h2.command.Parser.readTableOrView
Parser.java:1117 org.h2.command.Parser.readTableFilter
Parser.java:1724
org.h2.command.Parser.parseSelectSimpleFromPart
Parser.java:1832
org.h2.command.Parser.parseSelectSimple
Parser.java:1718 org.h2.command.Parser.parseSelectSub
Parser.java:1560
org.h2.command.Parser.parseSelectUnion
Parser.java:1548 org.h2.command.Parser.parseSelect
Parser.java:415 org.h2.command.Parser.parsePrepared
Parser.java:289 org.h2.command.Parser.parse
Parser.java:261 org.h2.command.Parser.parse
Parser.java:226 org.h2.command.Parser.prepareCommand
Session.java:437 org.h2.engine.Session.prepareLocal
Session.java:380 org.h2.engine.Session.prepareCommand
JdbcConnection.java:1138
org.h2.jdbc.JdbcConnection.prepareCommand
JdbcPreparedStatement.java:70
org.h2.jdbc.JdbcPreparedStatement.<init>
JdbcConnection.java:267
org.h2.jdbc.JdbcConnection.prepareStatement
jdbc.clj:474 clojure.java.jdbc/prepare-statement
RestFn.java:425 clojure.lang.RestFn.invoke
AFn.java:163 clojure.lang.AFn.applyToHelper
RestFn.java:132 clojure.lang.RestFn.applyTo
core.clj:621 clojure.core/apply
jdbc.clj:670 clojure.java.jdbc/with-query-results*
db.clj:216 korma.db/exec-sql
db.clj:239 korma.db/do-query[fn]
jdbc.clj:302 clojure.java.jdbc/with-connection*
db.clj:238 korma.db/do-query
core.clj:476 korma.core/exec
db.clj:21 guestbook.models.db/get-messages
home.clj:12 guestbook.routes.home/home-page
RestFn.java:397 clojure.lang.RestFn.invoke
home.clj:34 guestbook.routes.home/fn
core.clj:94 compojure.core/make-route[fn]
core.clj:40 compojure.core/if-route[fn]
core.clj:25 compojure.core/if-method[fn]
core.clj:107 compojure.core/routing[fn]
core.clj:2443 clojure.core/some
core.clj:107 compojure.core/routing
RestFn.java:139 clojure.lang.RestFn.applyTo
core.clj:619 clojure.core/apply
core.clj:112 compojure.core/routes[fn]
core.clj:107 compojure.core/routing[fn]
core.clj:2443 clojure.core/some
core.clj:107 compojure.core/routing
RestFn.java:139 clojure.lang.RestFn.applyTo
core.clj:619 clojure.core/apply
core.clj:112 compojure.core/routes[fn]
handler.clj:53
guestbook.handler/template-error-page[fn]
middleware.clj:44
noir.util.middleware/wrap-request-map[fn]
keyword_params.clj:32
ring.middleware.keyword-params/wrap-keyword-params[fn]
nested_params.clj:70
ring.middleware.nested-params/wrap-nested-params[fn]
params.clj:58
ring.middleware.params/wrap-params[fn]
middleware.clj:12 hiccup.middleware/wrap-base-url[fn]
format_params.clj:98
ring.middleware.format-params/wrap-format-params[fn]
format_params.clj:98
ring.middleware.format-params/wrap-format-params[fn]
format_response.clj:113
ring.middleware.format-response/wrap-format-response[fn]
multipart_params.clj:107
ring.middleware.multipart-params/wrap-multipart-params[fn]
validation.clj:135
noir.validation/wrap-noir-validation[fn]
cookies.clj:66 noir.cookies/noir-cookies[fn]
cookies.clj:171
ring.middleware.cookies/wrap-cookies[fn]
session.clj:141 noir.session/noir-flash[fn]
flash.clj:31 ring.middleware.flash/wrap-flash[fn]
session.clj:96 noir.session/noir-session[fn]
session.clj:85
ring.middleware.session/wrap-session[fn]
Var.java:415 clojure.lang.Var.invoke
reload.clj:18
ring.middleware.reload/wrap-reload[fn]
stacktrace.clj:17
ring.middleware.stacktrace/wrap-stacktrace-log[fn]
stacktrace.clj:80
ring.middleware.stacktrace/wrap-stacktrace-web[fn]
jetty.clj:18 ring.adapter.jetty/proxy-handler[fn]
(Unknown Source)
ring.adapter.jetty.proxy$org.eclipse.jetty.server.handler.AbstractHandler$0.handle
HandlerWrapper.java:116
org.eclipse.jetty.server.handler.HandlerWrapper.handle
Server.java:363
org.eclipse.jetty.server.Server.handle
AbstractHttpConnection.java:483
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest
AbstractHttpConnection.java:920
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete
AbstractHttpConnection.java:982
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete
HttpParser.java:635
org.eclipse.jetty.http.HttpParser.parseNext
HttpParser.java:235
org.eclipse.jetty.http.HttpParser.parseAvailable
AsyncHttpConnection.java:82
org.eclipse.jetty.server.AsyncHttpConnection.handle
SelectChannelEndPoint.java:628
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle
SelectChannelEndPoint.java:52
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run
QueuedThreadPool.java:608
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob
QueuedThreadPool.java:543
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run
Thread.java:744 java.lang.Thread.run
--
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
