Teradata Datasource configuration in WAS6 for connection pooling

[Swathi Sri]

Hi All,

I have configured my WAS6 server for connecting to Teradata database. I am using connection pooling option.

The problem I am facing is even though I connect using to database using ds.getConnection(username, password) and username sent as parameter is different from the user configured in the server, The connection returned uses the user configured in the server. The username and password sent as parameters are ignored.

Can anybody please tell me if this is any sort of bug in RAD or am I messing up with server configuration ?

Thanks in advance,
Swathi.

[Merrill Higginson]

When you use connection pooling, you are restricted to using a single user ID and password for the entire pool. When you think about it, that's the only way it could work: WebSphere is maintaining a pool of live database connections. The User ID and password are specified at the time the connection is created. There's no way to change the credentials after the connection is already created.

If you have two or three different groups of users with different database authority, I'd suggest creating a different Data Source for each group of users.