How exactly are you running the code? The Gist really doesn't provide enough information for anyone to be able to diagnose this...
On Tue, Jan 14, 2014 at 5:15 PM, Christopher Allen <c...@bitemyapp.com> wrote: > Verify with clojure.java.jdbc would by my first approach, but it's not clear > to me how you can know migratus and Korma aren't touching two different > instantiations of the H2 in memory database using c.j.j. > > I don't know anything about H2. I'm a PostgreSQL user. > > > > On Tuesday, January 14, 2014 7:50:07 AM UTC-8, Arlandis Lawrence wrote: >> >> The errors I'm getting indicate that the tables don't exist. >> "Table "itinerary" not found; SQL statement: >> DELETE FROM "itinerary" [42102-164] >> org.h2.jdbc.JdbcSQLException: Table "itinerary" not found; SQL >> statement: >> DELETE FROM "itinerary" [42102-164] >> at >> org.h2.message.DbException.getJdbcSQLException(DbException.java:329) >> at org.h2.message.DbException.get(DbException.java:169) >> at org.h2.message.DbException.get(DbException.java:146) >> at org.h2.command.Parser.readTableOrView(Parser.java:4753) >> at org.h2.command.Parser.readTableOrView(Parser.java:4731) >> at org.h2.command.Parser.readSimpleTableFilter(Parser.java:709) >> at org.h2.command.Parser.parseDelete(Parser.java:731) >> at org.h2.command.Parser.parsePrepared(Parser.java:336) >> at org.h2.command.Parser.parse(Parser.java:279) >> at org.h2.command.Parser.parse(Parser.java:251) >> at org.h2.command.Parser.prepareCommand(Parser.java:217) >> at org.h2.engine.Session.prepareLocal(Session.java:415) >> at org.h2.engine.Session.prepareCommand(Session.java:364) >> at >> org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1121) >> at >> org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71) >> at >> org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267) >> at >> com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213) >> ... 4 stack levels elided ... >> at korma.db$exec_sql.invoke(db.clj:206) >> at korma.db$do_query$fn__2578.invoke(db.clj:227) >> ... 1 stack levels elided ... >> at korma.db$do_query.invoke(db.clj:226) >> at korma.core$exec.invoke(core.clj:474)" >> >> I've verified that using postgres instead of h2 works and that the >> migrations actually occur in the h2 in-memory database, but for some reason >> korma doesn't see the tables. >> I suspect that korma is actually connecting to a different database, or is >> connecting after the original in-memory database has closed (I used the >> "DB_CLOSE_DELAY=-1" argument to try and mitigate this). >> Do you have any tips for examining the in-memory database manually in h2 >> or verifying that the databases I'm connecting to are the same? >> >> On Monday, January 13, 2014 4:35:30 PM UTC-6, Christopher Allen wrote: >>> >>> Try it without H2 and check the contents of the database manually. "Korma >>> cooperating" doesn't mean a lot if the tables don't actually exist. >>> >>> Error messages should be provided in future. >>> >>> On Monday, January 13, 2014 1:44:28 PM UTC-8, Arlandis Lawrence wrote: >>>> >>>> I'm trying to use H2's in-memory database feature for running specs, so >>>> I'm using Ragtime to run migrations before the test. >>>> Problem is, I can't get Korma to cooperate. Could someone take a look at >>>> this gist and see if it makes sense? >>>> >>>> https://gist.github.com/arlandism/8408370 > > -- > -- > You received this message because you are subscribed to the Google > Groups "Clojure" group. > To post to this group, send email to clojure@googlegroups.com > Note that posts from new members are moderated - please be patient with your > first post. > To unsubscribe from this group, send email to > clojure+unsubscr...@googlegroups.com > 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 clojure+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ World Singles, LLC. -- http://worldsingles.com/ "Perfection is the enemy of the good." -- Gustave Flaubert, French realist novelist (1821-1880) -- -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com 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 clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
