DevOps, CI/CD and Automation

Hi,

I am trying to use execute sql function in OSB.

Below is the statement i have used.

fn-bea:execute-sql('jdbc/MW_DB_DS', 'select value from GLOBALVARIABLES where Variable=?','ISDown')

data source name - jdbc/MW_DB_DS
Column name - ISDown

I am getting the below error when i am trying to use the function


Error executing the transformation: line 1, column 1: {bea-err}RDBW0001: [jdbc/MW_DB_DS]: [IsDown]: Error obtaining database connection 'jdbc/MW_DB_DS': Unable to resolve 'jdbc.MW_DB_DS'. Resolved 'jdbc'

I tested the datasource from weblogic server console and its fine.

I checked the syntax of the execute sql function and i could see as

fn-bea:execute-sql($datasource-string, $rowElemName, $sql-string, $params...)


So i even tried this


fn-bea:execute-sql('jdbc/MW_DB_DS', 'rec','select * from GLOBALVARIABLES where Variable=?','ISDown')
I am still getting the same error. Is it some thing to do with data source?? I checked the conenctivity and tried increasing the max connections but still i am getting the same erorr.


Any suggestions on this??