File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Datasource question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Datasource question" Watch "Datasource question" New topic

Datasource question

Shankar Veerashetty

Joined: May 23, 2003
Posts: 4
What happens if a datasource is created with a id and a password and then an application developer gets a connection using
Connection conn = ds.getConnection("other_id","other_password") ;
Does it create a new pool of connections with this new id or gets a new connection everytime user requests for one?
Can anyone please explain what really happens here!!
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8904

Good question.I will have to try this :roll:

Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8904

It is going to create a dynamic connection pool.
I agree. Here's the link:
subject: Datasource question
Similar Threads
Database Connection and Session
Regarding JNDI doubt
Want to use different data source than my security principal
Datasource JNDI Lookup in WSAD from standalone app
DataSource passing param