Win a copy of Getting started with Java on the Raspberry Pi this week in the Raspberry Pi forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Rob Spoor
  • Devaka Cooray
  • Liutauras Vilda
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
  • Piet Souris

Teradata Datasource configuration on WAS V5

Posts: 15
Eclipse IDE VI Editor Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,

I'm facing a peculiar problem when using Teradata Datasources with Websphere .well..the version is 5.X.. (has jdk 1.4)

I'm using Teradata JDBC Driver. I've configured it on the console. And When I test the Datasource, it says connection successful.

When I use the application, I'm getting an exception. I'm putting forward what all I have done in configuring the Datasource and JDBC provider.

I made an entry for the teradata driver in the Websphere env variables: /apps/dw/saart/htdocs/SAARTONLINEWebEAR.ear/SAARTONLINEWeb.war/WEB-INF/lib/

I've added a JDBC Provider specifying the jar file containing the driver and the TeraconnectionpooDataSource class which is the implementation class.

under Datasource I created a Datasource TeradataDatasource and provided a jndi name. and added a few custom properties like user,password,DATABASE,DSName.

I added J2C authentication entries also with the username and the password and mapped it against (component managed alias) when I installed the application.

When I'm testing the connection for the Datasource, it says connection is successful, but when I'm trying to access from the application(servlet), it throws an exception.

Context ctx = new InitialContext();
dataSource =(DataSource)ctx.lookup("jdbc/teradata");
connection = dataSource.getconnection() //earlier I tried with getConnection("uatb01","uatb01"); Doesn't work
stmt = connection.createStatement();
rset = stmt.executeQuery(query.toString());

The exception thrown is

Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/teradata, throwing ResourceAllocationException. Original exception: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: [NCR] [Teradata DBMS] : Invalid password.. with SQL State : 28000 SQL Code : 3003

All the passwords are working fine. I tried logging on to the Teradata machine. I'm able to execute queries.

I've attached a compressed archive. It contains the screenshots of the Websphere admin console. and also the jar files which contain the Teradata driver files. all the jar files are in the class path.

The same configurations are working for WAS 6. I'm trying to find out why this is not working for WAS5.

I really appreciate all your suggestions and help.

Your mother was a hamster and your father was a tiny ad:
Low Tech Laboratory
    Bookmark Topic Watch Topic
  • New Topic