JDBC Connector, SQL Query and available variables

1
0
-1

Hello

I can use simple variables in my SQL queries inside JDBC connectors using ${ varname }.
Are complex variables available? Like objects from the BDM or java.util.List?

Is the SQL Query a velocity template or a groovy GString interpolation?

Thanks

1 answer

1
0
-1
This one is the BEST answer!

Use the ecpression builder instead of the simple construct to use complex variables,

Much, much easier...

regards
Seán

PS: If this reply answers your question, please mark a resolved.

Comments

Submitted by g.lapierre on Thu, 03/17/2016 - 09:58

The expression builder is indeed a good solution for non-community editions. I solved my problem switching to a Groovy script returning the SQL statement which gives me all the flexibility I needed. Thanks for your answer.

Submitted by Sean McP on Thu, 03/17/2016 - 10:08

It also works extremely well for Community editions... :)

regards
Seán

Submitted by g.lapierre on Thu, 03/17/2016 - 13:06

I have both community and performance and I did not find the expression builder on the community edition (7.2)

Submitted by Sean McP on Thu, 03/17/2016 - 13:53

Yep, it's still there...

In 7.2.1 add SQL connector then when you get to enter query click the Switch Editor link...it changes the editor allowing the groovy editor...

regards

Submitted by g.lapierre on Thu, 03/17/2016 - 14:29

That's what I did. I thought you were talking of the graphical query builder

Notifications