The moose likes JDBC and Relational Databases and the fly likes Database connection from Java application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database connection from Java application" Watch "Database connection from Java application" New topic

Database connection from Java application

Tom Raj

Joined: Mar 03, 2005
Posts: 11
Hi all,
I have a simple application. I'm trying to connect to my udb database thru the datasource defined on my local websphere server. The code is below. Initially I was getting a ClasscastException at the line 'ds = (DataSource) obj' . After several trials I included the database implementation jars in the websphere directory in the java app's classpath and it worked.

My question here is does my java application go to my server for getting the connection or after getting the datasource instance, the connection happens locally? To test this, I terminated my server after getting the datasource reference by lookup (my java app in debug mode) and then executed the ds.getconnection(). It worked and so I think the connection is obtained locally. So does this connection be in a pool??

Can somebody elaborate what is happening here??

Properties props = new Properties();

DataSource ds = null;
Context context = new InitialContext(props);

Object obj = context.lookup("jdbc/CustDataSource");
ds = (DataSource) obj;
dBconn =ds.getConnection(DAOConstants.DB_USER_ID,DAOConstants.DB_USER_PWD);
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
Hello Tom-

On your way in you may have missed that JavaRanch has a policy on display names, and yours does not comply with it - please adjust it accordingly, which you can do right here. Thanks for your prompt attention to this matter.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32793

Thanks for updating your display name.

Yes, the datasource is likely to be pooling connections. You can verify this by checking your datasource configuration on the server.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Database connection from Java application
It's not a secret anymore!