File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 19973

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!