Hello,
2013/9/24 Rob Nikander <[email protected]>
> Hi,
>
> Here's a weird one...
>
> val suffix = now.toString("_yyyy_MM_dd_")
>
> val updateQuery = dsl.update(t).set(t.FOO, concat(t.FOO, value(suffix)))
> ....
>
> This renders SQL like:
>
> ... set Foo = (cast(Foo as varchar) + ?), ...
>
> This truncates Foo to 30 chars before appending to it. If I manually
> change varchar to varchar(max) it works fine. Strangely, the first
> version works fine when I type the query into SQL Studio. It's only when I
> go through JDBC and the jtds driver that this truncation happens. Also I'm
> using SQL Server 2008 R2, and your docs specifically say you support R8 and
> later.
>
> But... any idea for a workaround, short of going back to manual SQL? Can I
> somehow tell it to use varchar(max) (or not cast at all?).
>
This is a known issue and will be fixed in jOOQ 3.2:
> BTW, I've posted a few things here recently. Thank you for this library.
> For me it's a lot more usable than Slick for everyday work.
>
> Rob
>
> --
> 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.
