Password in JDBC adapter

[Former Member]

Hi Experts,

We are using a JDBC scenario in my project. but the problem with the receiver JDBC adapter.

is it possible to retrieve the JDBC receiver adapter password if I forget the same?

is it possible by checking the message log in NWA or somewhere else? What I am thinking if a message flow to this database..

in the log something will com up as - trying to connect the database with user name /pwd ...

I am not sure if this will happen.

I have checked the XML format of the receiver channel-

I found all the parameter's values are there. not the password.

I found below-

<AdapterSpecificAttribute xmlns="urn:com.sap.aii.ibdir.server.api.types">

<Name>dbuser</Name>

<Value>ERPWBP01</Value>

</AdapterSpecificAttribute>

<AdapterSpecificAttribute xmlns="urn:com.sap.aii.ibdir.server.api.types">

<Name>dbpassword</Name>

NO password is mentioned there.

Please let me know if this is possible.

Thanks

Sugata B Majumder

[baskar_gopalakrishnan2 · Accepted solution]

>>> NO password is mentioned there.

>>I found all the parameter's values are there. not the password.

>>Please let me know if this is possible

You have to specify the db password in the jdbc receiver communication channel and not in the message.

something similar to the below....(this is for sqlserver database)

JDBC Driver:com.microsoft.sqlserver.jdbc.SQLServerDriver

CONNECTION:jdbc:sqlserver://IP ADDRESS:PORT;Database=HOST NAME;

USER NAME:sa

PWD:XXXXXXXx

Hope this helps.

http://www.riyaz.net/blog/jdbc-adapter-configuration/technology/1200/

[sugata_bagchi2]

I contacted the DBA and got the same

[rajasekhar_reddy14]

Hi,

After creating JDBC CC you will enter password your Data base , that is one time job,If you enter wrong password , if JDBC CC runs more that 3 times, account will be locked.

You will not have any authorization to change/retrieve password of DATA Base from XI/PI.

So Data base administrator is the right person who can share password.

Regards,

Raj

[Former Member]

No , Not from XI end. But Surely u can get it at DB Level , Ask DBA, He/She will get you the password from DB SYSTEM LEVEL TABLE .