java - how to concat 2 vrchar in jdbc/derby? -

java - how to concat 2 vrchar in jdbc/derby? -

i want run code in jdbc/derby got below error. how can handle in jdbc?

code:

select id,namee+ " " + family names students

errorr:

the '+' operator left operand type of 'varchar' , right operand type of 'varchar' not supported.

derby uses || operator concat strings (like oracle):

select id, namee || " " || family names students

java netbeans jdbc derby