Why username and password need to be passed with dataSource.getConnection()

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Why username and password need to be passed...

Rate Topic

Display Mode

Topic Options

Author

Message

prashanth777

Posted 1/12/2006 11:32:43 AM

Forum Newbie

Group: Forum Members
Last Login: 1/13/2006 10:23:00 AM
Posts: 1, Visits: 1

I have configured V5 datasources on WSAD for DB2, Oracle and Teradata. While dataSource.getConnection() with no parameters work fine with DB2 and Oracle, but not with Teradata. For Teradata, we either have to set properties for user and password on the datasource configuration or, pass them as parameters with dataSource.getConnection() method.
Neither of them is an option for us as we want to use the security configured on the WSAD(those are the same user and password that we would otherwise pass with getConnection()) and we set the Component-managed authentication alias and Container-managed authentication alias to use this security setting. That should supply the username and password, why do we duplicate the samething from properties or with method call.
We have a Password protection application that will update the security on WSAD datasource, no one knows what the password is. Writing to the security file on WSAD keeps it encoded. I am using "com.ncr.teradata.TeraConnectionPoolDataSource" as connection pool datasource class. Please let me know if I am missing something.

Regards,

Prashanth

Post #3346

Dennis Calkins

Posted 1/12/2006 11:46:40 AM

Supreme Being

Group: Forum Members
Last Login: 6/16/2007 11:57:00 AM
Posts: 293, Visits: 1

You need to set up Some sort of Single Sign on or other Mutual Authentication method on the Teradata system.

What OS type are your Teradata Database nodes and what version of software are you using?

Post #3347

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 5 ( 5 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 12:52am