We tried to do this, but somehow the datasource does not seem to be picking up the new
login and password.
i.e
The userprofile seems to be getting set with the new login and password. But, the
datasource seems to be still using the default login and password that we had set up
in the studio.
Are we missing something here??
Andrea
Mahesh Harpale <[EMAIL PROTECTED]> wrote:
>Hi Philippe,>>If you want to customize the User Profile, you need to use
>CSpUserProfile
class. This is necessary because there are multiple users and connections
are>pooled.
You can use following code:>> protected void setLoginProfile(String user,
String
pass)> {> try> {> CSpUserProfile userProfile = CSpider.getUserProfile();>
CSpLogin
userLogin = userProfile.getDBUserLogin("myDS");>> if (userLogin != null)>
{>
userLogin.setUserId( user );> userLogin.setPassword( pass );> }>
else>
{> CSpLogin newUserLogin = new CSpLogin( user, pass);>
userProfile.addDBUserLogin("myDS",
newUserLogin);> }> }> catch(Exception ex)> {> CSpLog.send(this,
CSpLog.ERROR,
"Exception in setLoginProfile" + e);> }> }>>Please, avoid using
setRuntimeUserID/Password
methods.>>Thank
you.>>Regards,>Mahesh>------------------------------------------------------------------------------>Mahesh
Harpale>>Indus Consultancy Services>140, East Ridgewood Ave., Paramus, NJ
07652>>E-Mail:
[EMAIL PROTECTED]>Phone: (201) 261-3100 (ext. 237)>Fax: (201)
261-1399>------------------------------------------------------------------------------>>>[EMAIL PROTECTED]
wrote:>>> We're having many problems with the RDBMS service : our Netdynamics
application
accesses Oracle databases and>> we're using stored procedures.>>>> Before
describing
it, here is our configuration :>>>>
==============================================================================================================>>
CONFIGURATION>>
==============================================================================================================>>
Server plateform : Solaris 2.6>> Netdynamics server version : 4.1.2>> We're
using
Oracle via SQLnet ; version 7.3.4>> The configuration of our RDBMS Service
:>>
- number of workers = 1>> - number of high priority workers = 0>> -
in-of-process>>
- worker properties :>> > maximum database connections per
process =
5>> > maximum database connections per DB = 5>> > maximum
records
to retrieve = 5000>> > number of worker processes = 1>> >
port number
= 0>> > maximum number of clients per worker = 5>>>>
==============================================================================================================>>
PROBLEM 1>>
==============================================================================================================>>>>
At the initialization of the project, we're setting the values of our Oracle
Data
Source with values retrieved from>> a configuration file :>>>>
CSpDataSource
DS= (CSpDataSource) CSpider.getDataSource("xxxx");>>
DS.setRuntimeUserID(cgConfig_.getValue(
"xxxx", "DBuserID" ));>> DS.setRuntimePassword(cgConfig_.getValue(
"xxxx",
"DBpassword" ));>> DS.setRuntimeServer(cgConfig_.getValue( "xxxx",
"DBserverName"
));>>>> Some times, at random, it seems that Oracle connexion fall down, and
the
project re-initializes the Data Source value, with>> the hard values set in
the Studio
; the problem is that these values are false, and so we got the following
DSRdbmsService
error :>>>> DSRdbmsService:c:<numeric_value>:w:<numeric_value>:cannot
open
databaseserver=<database_server_name_fixed_in_studio>>>>> QUESTION 1 : IS
THERE ANY
WAY TO CATCH THIS EVENT TO RE-INITIALIZE IT WITH OUR CONFIGURATION FILE
VALUES ??>>>>
==============================================================================================================>>
PROBLEM 2>>
==============================================================================================================>>>>
Some times, at random, we're having the following DSRdbmsService error
telling us
that the socket connexion had been reset by peer exception.>> I read in the
document
"Netdynamics 4.0.2 for Unix (solaris), that there's a known bug about this
point,
which is a Visigenic problem.>>>> IS THIS BUG STILL EXISTING UNDER
NETDYNAMICS 4.1.2
???>>>> In the same document, it is written, that, in general, we have to
restrict
database client library access to a single thread by setting the "maximum>>
number
of clients per worker" configuration of the DSRdbms service to 1. Regarding
our DSRdbms
service configuration, do you think>> our problem is comming from that
configuration,
or this limitation had been canceled in Netdynamics 4.1.2 ?????>>>>
==============================================================================================================>>
Best regards,>>>> -->> \\\\\//>> \\|//
_\\|//_ | | _\\|//_ \\|//>> (@ @) (' 0-0
')
(.) (.) (' @-@ ') (o-o)>>
+-=oOOo-(_)-oOOo=oo0-(_)-0oo=oOO==(_)==OOo=oo0-(_)-0oo=oOOo-(_)-oOOo=-+>>
Philippe MAISONNAVE - Engineer>>>>
CAP
GEMINI TELECOM PARIS>> [EMAIL PROTECTED]>>
01.49.00.46.97>>
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+>>>
_________________________________________________________________________
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]
