How to create JDBC call atom in B1IF 2.0 version

[former_member416544]

Hi,

How to created JDBC call in integration framework 2.0 version.

I have created the complex query in xsl atom(before BizIOs1 atom), now I want to call the xsl payload atom into the BizIOs1 atom.

can you please someone suggest me.

Thanks,

Chenna.

[HuanYang · Accepted solution]

Hello Chenna,

What's the exact issue for you?

The xsl payload or some errors?

The following screenshot may help

Thanks & best regards

Huan Yang

[former_member12197 · Accepted solution]

Hello Huan,

Can you show me a real example on using "jdbc:CallStoredProcedure". Example with the parameter would be real great.

Mine isn't working out. I tried with parameters, tried without parameters, tried without parameters and empty tags etc...
What am I missing ? Where should I look into to resolve this?

Please advice

[rafael_ogeda · Accepted solution]

Hi Huan!

We are trying to use JDBC connection values defined in [Deployment Panel]/[Systems]/[Assigment] rather than to define [Outbound Properties]/[sysid] as fixed value, but we are getting error "Mandatory property is linked to SLD, but no SLD entry associated".

In JDBC [Adapter Call in BizFlow] we disabled the [Outbound Properties]/[sysid] property, and we expected that the JDBC Adapter connection parameters would be definied by [Systems]/[Assigment].

Do you have any idea what we might be doing wrong?

Thanks in advance!

Rafael Ogeda