Hi Brent

You can call concat on the field.

Regards
Thomas

------ Originalnachricht ------
Von: [email protected]
An: [email protected]
Gesendet: 21.06.2015 20:45:14
Betreff: Mapping two sql columns into one Java field

Hi,

Is it possible to map two database columns into a single java field suing jOOQ? What I mean by this is say I have a table (in postgresql or whatever):

create table something(
  id bigserial primary key,
  ...
  amount numeric not null,
  currency varchar(3) not null,
  ...
);

I'd like to map the amount and currency fields into a javax.money.MonetaryAmount but this requires both columns for the mapping so I don't think it's possible using a regular org.jooq.Converter. Does jOOQ support this? I can't really find anything like this in the docs. If it does, are there things that it does/doesn't work for e.g. I can see rendering select, insert and update statements to be doable but I can't see how conditions could work in any reasonable manner.

Thanks in advance,

Brent

--
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.

Reply via email to