jQuery in Action, 2nd edition*
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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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.
It is sorta covered in the JavaRanch Style Guide.
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