One of the neat features you could do is retrieve information from database in side the Bus, one could use this to enrich message. In the example below i am using execute-sql function. The JNDI was defined in weblogic server on which ESB running. in the oracle documentation it say not to use XA driver but i did use XA driver and it worked just fine, as i was doing simple select
{
fn-bea:execute-sql(
'testJNDI',
xs:QName('name'),
'SELECT name FROM tbName'
)
}

{
fn-bea:execute-sql(
'testJNDI',
xs:QName('name'),
'SELECT name FROM tbName'
)
}
No comments:
Post a Comment