Hi - great feedback thanks.  Slightly kicking myself for not going deeper
into the manual now - as the SQL builder functionality is exactly what I
was looking for (and I've just finished writing my own implementation!)  Oh
well, like Lukas said perhaps there is scope for more integrated support in
the future...:-)

Thanks again,

Tim


On Fri, Jun 7, 2013 at 11:37 AM, Lukas Eder <[email protected]> wrote:

>
>
>
> 2013/6/7 Durchholz, Joachim <[email protected]>
>
> > - A CMIS repository is not a database, and querying
>> >   from a client point of view does not require JDBC.
>> >   All we need is the SQL.
>> > - Will JOOQ only support back-ends that can be
>> >   interfaced by a JDBC driver?
>>
>> See
>> http://www.jooq.org/doc/3.0/manual/getting-started/use-cases/jooq-as-a-standalone-sql-builder/
>>
>> Money quote #1: "The SQL string that you can generate as such can then be
>> executed using JDBC directly, using Spring's JdbcTemplate, using Apache
>> DbUtils and many other tools."
>>
>> > - Type-safety.  CMIS has object types, and these have
>> >   property definitions.  These could be analogous to
>> >   database tables and types could theoretically be
>> >   generated against them.
>>
>> Money quote #2: "Plain SQL: This section contains information useful in
>> particular to those that want to supply table expressions, column
>> expressions, etc. as plain SQL to jOOQ, rather than through generated
>> artefacts."
>>
>> Disclaimer: That's just from reading the manual. I'm more a bystander
>> than an actual Jooq user.
>> But I think the link says that, yes, you can do these things, assuming
>> there are no pitfalls hidden in the details of your use case (or in the
>> details of Jooq).
>
>
> Absolutely!
>
> --
> 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/af-5m56Y3dI/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Check out my wine blog: http://timswineblog.blogspot.com/

-- 
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/groups/opt_out.


Reply via email to