Hi Gleeson,
I have tried the same but it doesnt work. Throwing error.
Error while reading the relational data
DB2 SQL Error: SQLCODE=-313, SQLSTATE=07001, SQLERRMC=null, DRIVER=3.57.82
I am subclassing the connection manager as discussed in the topic “Dynamic username password in jdbc file”
Below is the code i am using for this
<xe:jdbcRowSet var=“jdbcRowSet1”
sqlQuery="select * from comp.users where user_id='?'"
connectionManager="heerosConnectionManager1">
<xe:this.sqlParameters>
<xe:sqlParameter loaded="true" value="A6B234"></xe:sqlParameter>
</xe:this.sqlParameters>
<xp:this.value><![CDATA[#{javascript:var count=jdbcRowSet1.getCount();
var list=new java.util.ArrayList();
for(i=0;i<count; i++){
list.add(jdbcRowSet1.getRow(i).USER_ID)
}
list}]]></xp:this.value>
I have tried ? with and without quotes. but doesnt work.
This works fine when I hardcode the user_id instead of passing it as parameter. Any ideas please ?