Hi Shyam,
With other databases, you could use an array type and unnest it into a
table. Another option that works well for SQL Server is to use the VALUES()
constructor:
http://www.jooq.org/javadoc/3.2.x/org/jooq/impl/DSL.html#values(org.jooq.Row1..
.)
Example:
DSL.using(configuration)
.select(...)
.from(values(row(v11, v12, v13),
row(v21, v22, v23),
row(v31, v32, v33)).as("InMemoryTable", "col1", "col2",
"col3")
.fetch();
There might be a warning because of generics, which you can ignore (or
suppress)
2014-01-28 Sha <[email protected]>
> Hi Lukas,
> Me trying to use Result<R> or ArrayList object instead of the temporary
> table.
>
> i.e. constructing a List from the subquery and using the list in place of
> temporary table.
>
> But the business logic demands some of columns(fields) to be "joined" to
> get the result.
>
> So, is there anyway to convert the List into Table type in JOOQ.
> so that i can use join operation on resulted Table.
>
> Thank you.
> ~Shyam
>
> --
> 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.
>
--
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.
