How to define a datasource to DB2 in WSAD 5?

[Sean Li]

ergent!
I tried every means to make it, just failed always. seems everything is fine, just cannot use it. is there any step by step tutorial? pls help me.
what I did is:
1, define a datasource in Server configuration->datasurce page. a DB2 datasource, I use v5. but don't know where to add username and password information. and used the jndi name of "jdbc/epc".
2, later, i look up in my bmp like this: lookup("java:comp/env/jdbc/epc"), everytime failed. said could not find the name specified.
3, later, i set the datasource i defined as a default datasource. thought websphere still didn't find, it used the default. then another error message was no auth**.
I am really comfused by this, help me pls.
How to configure? How to use? step by step, as specific as possiable. thanks!

[David O'Meara]

You set up a database user in the 'security' section, then assign this user to the datasource.
In the server configuraton, select the 'Security' tab at the bottom.
In the "JAAS Authentication Entries", add a new alias called "Database user" with the datasource username and password.
Go back to your datasource, edit, at the bottom it refers to the "Component-managed authentication alias" and "Container-managed authentication allias", you should be able to select your new database user in both of these lists.
I've heard it's also possible to set the username and password as name-value pairs in the datasource properties, but I haven't tried this and it isn't the recommended way to do it.
Dave

[Sean Li]

Thank you. fix it. got it.