I found an error on my part that had nothing to do with either database or jooq, sorry for the confusion.
We run phoenix.apache.org which is a SQL skin over HBase. It works quite well with the MySQL dialect of JOOQ. I have created a very simple org.jooq.util.Database implementation that read Phoenix DDL statements from file and transform them into JOOQ classes, if you might be interested in a contribution of some sort. On Wed, Jan 7, 2015 at 6:27 PM, Lukas Eder <[email protected]> wrote: > > > 2015-01-07 14:33 GMT+01:00 Kristoffer Sjögren <[email protected]>: > >> Thanks for the tips Lukas. >> >> After looking more closely I can see that the JOOQ code seems to do the >> right thing actually. It more looks like the DB may have problems with >> PreparedStatements. >> > > Interesting, what database are you using? > > >> But as a workaround a prerolled statement like this will work. >> >> con.createStatement().execute("UPSERT into TABLE (A, B, C) values (1, 2, >> 3)"); >> >> Is it possible to create such a query using JOOQ records? >> > > You can specify the jOOQ Settings to generate > StatementType.STATIC_STATEMENT. An example is also given on this page: > > http://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings > > The effect is that all bind values will be escaped and inlined by jOOQ, > and only "static" java.sql.Statements are executed, as opposed to > PreparedStatements. > > -- > You received this message because you are subscribed to a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/jooq-user/-gI2yrEuaik/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" 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/d/optout.
