Derby: CONCAT equivalent

java derby javadb
Ace Eusebio picture Ace Eusebio · Apr 18, 2012 · Viewed 7.4k times · Source

Good day!

What is the equivalent function of Derby/Java DB to the CONCAT function of MySQL?
I tried using CONCAT to Derby but it commits an error.

Answer

Rangi Lin picture Rangi Lin · Apr 18, 2012

I believe you can concatenate two string with ||

Derby Built-in function reference - concatenation

Related questions

Setting up an embedded Derby database in a standalone Java application

I'm trying to setup an embedded Derby database for a standalone Java application, but after pouring through all sorts of documentation, I just can't seem to find any simple explanations or examples. I'm using Eclipse with the Derby plugin and …

Read More
Database not found error when connecting to Derby network server

I'm having problems initializing my javadb network server and setting a connection to it. It's a JavaFX program. This is what I have so far: try { Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance(); javadbserver = new NetworkServerControl(); javadbserver.start(null); } …

Read More
Derby/JavaDB vs SQLiteJDBC

I found a lot of comparisions here, but not this one; So, what is best in each one?

Read More