Two Laptop Bag
The moose likes Websphere and the fly likes Connect to websphere data source from external application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Reply locked New topic

Connect to websphere data source from external application

Rahul Chaitanya

Joined: Aug 22, 2010
Posts: 22

I wrote the following code for connecting to the websphere datasource from external application:

Properties prop = new Properties();


InitialContext init = new InitialContext(prop);

DataSource ds = (DataSource) init.lookup("jdbc/testDS");

//Connection conn = ds.getConnection("USER NAME","PASSWORD");
Connection conn = ds.getConnection();

If, I give the username/pwd while retrieving the connection it is working but it is not working if i don't give them.

For resolving the above problem, I tried setting up the authentication alias(custom properties for the data source) and tried to access it through them. But no luck.

Is it possible to connect through the custom proerties ? I set up them with the names: "user and password" and used them while getting the connection. Do I need to create the properties with different names ?

Any suggestions will be a lot helpful.

Paul Clapham

Joined: Oct 14, 2005
Posts: 19874

That's just a duplicate of this post as far as I can see. Please don't post duplicate questions.
I agree. Here's the link:
subject: Connect to websphere data source from external application
It's not a secret anymore!