1

I am using Pentaho Design Studio(pds-ce-win-32-4.0.0-stable). In an xaction file I need to change database name in the url like 

jdbc:sqlserver://IP:1433;databaseName=??????;integratedSecurity=false

I generated an output as result set column that holds the url. When I run the xaction that url is shown as output. But when I use that result set column as database url of next process it doesnt work.

Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
MNessa
  • 48
  • 8
  • This is solved now. Actually I had to set the output parameter as session variable. Then it's usable. Of course the first xaction needs to be run at first. – MNessa Jun 17 '13 at 05:55
  • In Message Template, If I try to use {MYPARAM} and set value from table column value is not show in the email, instead '{MYPARAM}' is getting displayed. Can you please let me know what exactly is the issue? – MAX Oct 04 '17 at 12:31

1 Answers1

1

Not sure why you use url pattern, in xaction so far I used the jndi name for DB resource:

<jndi><![CDATA[tsi_test_blade4]]></jndi>

and this can be also replaced with variable:

<jndi>{JNDDDI}</jndi>

So as JNDI you pass as parameter that resource is used.

martinnovoty
  • 896
  • 8
  • 17
  • JNDI is not the standard here. Anyhow this helps. – MNessa Jul 02 '13 at 04:58
  • In Message Template, If I try to use {MYPARAM} and set value from table column value is not show in the email, instead '{MYPARAM}' is getting displayed. Can you please let me know what exactly is the issue? – MAX Oct 04 '17 at 12:30