This works:-
CSpDataSource ds = CSpider.getDataSource("dsPwbRec");
ds.setRuntimePassword(sPassword);
ds.setStudioPassword(sPassword);
ds.setRuntimeUserID(sUsername);
ds.setStudioUserID(sUsername);
CSpSelect doLUSER = (CSpSelect)
CSpider.getDataObject("DoLUSER");
doLUSER.clearDynamicCriteria();
doLUSER.addDynamicCriterion("LUSER_US_DESC",
CSpCriteriaSQLObject.EQUAL_TO_STR_OPERATOR,
cdUsername);
doLUSER.execute();
"Andrea Lewis" <[EMAIL PROTECTED]> wrote:
>>I am trying to dynamically set the RuntimeUserID and RuntimePassword to a specific
datasource depending upon the user. >I have tried the following:>1. To set
the
datasource parameters in the onBeforeExecuteEvent of the dataobject>using the
set
runtimeUserID and setRuntimeUserPassword. This does not work consitently
with multiple
users. > > CSpRequest request =
event.getDBRequest();
> CSpDBConnection dcThis =
request.getDBConnection();> CSpDataSource
dsTest2 = dcThis.getDataSource();>
dsTest2.setRuntimeServer(sDBName);>
dsTest2.setRuntimeUserID(sUserID);>
dsTest2.setRuntimePassword(sPassword);> dcThis.setDataSource(dsTest2
);> request.setDBConnection(dcThis);>>2.To set the CSpLogin element in the
Hashtable
of the CSpUserProfile in the onBeforeExecuteEvent of the DataObject. >It
seems I
am missing something because the userID and password are not being used by
the datasource.>{>
CSpUserProfile userProfile = CSpider.getUserProfile();>
userProfile.setSecurityObjectActivated(false\true);>
CSpHashTable chtLogins = userProfile.getDBUserLogin();>
if (chtLogins.size() > 0)> {>
CSpLogin userLogin = (CSpLogin) chtLogins.get("dsThis");>
userLogin.setUserId( sUserID);>
userLogin.setPassword(sPassword);>
chtLogins.put("dsThis",userLogin);>
userProfile.setDBUserLogin(chtLogins);> }>
else> {> >
> CSpLogin newUserLogin = new
CSpLogin(sUserID,sPassword);>
userProfile.addDBUserLogin("dsThis", newUserLogin);>
}>
CSpider.setUserProfile(userProfile);>
}> catch(Exception ex)>
{> CSpLog.send(this, CSpLog.ERROR, "Exception in
setLoginProfile"
+ ex);> }>>Any sugestions would be greatly appreciated!
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
