Hello, Interesting. We've seen a couple of references of people using jOOQ with Phoenix / HBase in the past. So far, we have been a bit reluctant of providing a formal integration, as these "Somewhat-SQL" Implementations tend to be very limited in scope, and the jOOQ API might seem to be overkill.
But perhaps we should start looking into a formal integration, nonetheless. I'd be curious about your org.jooq.util.Database implementation. Perhaps, this would indeed be a basis for a contribution! Cheers Lukas 2015-01-08 14:44 GMT+01:00 Kristoffer Sjögren <[email protected]>: > 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. > -- 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.
