Ah, I found the workaround...
set(t.FOO, field("FOO + ?", classOf[String], suffix)) //
classOf[String] is Scala for String.class
Sweet!
Rob
On Monday, September 23, 2013 10:19:35 PM UTC-4, Rob Nikander wrote:
>
> 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?).
>
> 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.
