Hi Harsh,
Thanks for your message.
The DSLContext.selectFrom() method should probably be overloaded with
versions accepting the usual Table<?>|Name|String type, like many other
methods, for convenience. In the meantime, you can construct your own
tables using jOOQ's API, e.g. by using
// Using an identifier
table(name("SOME_TABLE"))
// Using plain SQL
table("SOME_TABLE")
See also:
https://www.jooq.org/doc/latest/manual/sql-building/names
https://www.jooq.org/doc/latest/manual/sql-building/plain-sql
Or, you use the DSLContext.select().from(String) notation.
I hope this helps,
Lukas
2018-05-12 7:57 GMT+02:00 Harsh Maur <[email protected]>:
> Hello,
>
> I was trying to implement SEEK functionality in my application and I found
> https://blog.jooq.org/2013/10/26/faster-sql-paging-
> with-jooq-using-the-seek-method/.
> The problem I am facing is that I am trying to build pagination
> functionality for all my models. I am using GraphQL and Kotlin with Jooq.
> Jooq accepts the instance of the table for example
>
> ctx.selectFrom(Tables.SOME_TABLE)
>
> For this I need to get its instance before I could construct any statement
> which unfortunately I dont have. What I need is basically
>
> ctx.selectFrom("SOME_TABLE")
>
> This would allow me to create generic SQL statement and leverage Jooq's
> seek functionality as well as other apis out of the box.
> I am not sure if this is the only way, maybe someone can suggest me a
> better way to do the same.
>
> Thanks!
>
> --
> 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.
