Question & Answer > View Question

JDBC binder CONCAT

Confluence User - 08 Sep, 2016

Hello I got problem with jdbc binder and concatenating I got group of 3 columns, where always 2 of columns are NULL and 1 got a value, I need to get that value. Simplest solution working on mysql is this.

select  
CONCAT(IFNULL(c_col1,"")+IFNULL(c_col2,"")+IFNULL(c_col3,"")) as value,
main.* 
from app_fd_main as main

When I run this query directly on mysql everything is fine, when I try to use it as JDBC binder for datalist, I am getting String reference with CONCAT, without CONCAT I am geting numeric value(those columns are strings so also wrong response).

By String reference I mean something like this

[B@a408cdc

[B@4de4ddbe

Thank you for help.

datalists;jdbc;query;mysql;concat

1

Confluence User •

10 Sep, 2016 •

confluenceUser •

•

confluenceUser •

Hi,

As I don't have an app_fd_main table, I modified the query slightly using the dir_user table

select 
CONCAT(IFNULL(username,"")+IFNULL(firstName,"")+IFNULL(lastName,"")) as value,
main.*
from dir_user as main

and it seems to work as expected, returning a numeric value for the value column. I tried it on version 5.0.8

1

CSV | Excel | XML | PDF

Your answer

Print

JDBC binder CONCAT

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

JDBC binder CONCAT.builder-style-7e15567e-abc6-4747-97cb-32f5ca0f4416{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

1.builder-style-071fd615-b5af-47a6-83a5-89022978b630{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-7d137b5b-109d-4de8-a810-0a479ddc38f4{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

JDBC binder CONCAT

1

Your answer