I have a query in JOOQ concatenationAsk Questions

 Posted on 08/22/2018

I have a query like this:

Result<?> result = create.select(CONSUMER.CONS_ID_NO,
                                             concat(CONSUMER.AREA_CODE, "/", CONSUMER.CONS_NO, "/", CONSUMER.CAT_CODE).as("ConsNo"),

I wrote this according to the JOOQ Manual, but I am getting an error that says:

The method concat(String...) in the type Factory is not applicable for the arguments (TableField, String, TableField, String, TableField)

I am using JOOQ-3.

Share On: facebook gplus twitter
Asked by hardik chaudhary on 08/22/2018 Score: 432 points
Add Comment:


1 Answers

1 Corrected Answers
Aproved Answers
Answered by on 9/20/2018 7:06:34 AM Score: 89 points

It seems that the sample in the manual doesn't work. However, you can convert a string to Filed via org.jooq.impl.Factory.val.

    Record result = create.select(
            concat(AUTHOR.FIRST_NAME, val(" "), AUTHOR.LAST_NAME).as("Full Name")

Please refer to this email from Lukas Eder for details


Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.