Tuesday 27 January 2009

Oracle Aqualogic ESB XQuery to Database

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'



)
}



No comments: