DBCP connection problems with credentials

["q.werty@laposte.net" <q....@laposte.net>]

Hi,

I'am starting with DBCP and Tomcat because of some pooling 
problems with Tyrex and Poolman.
First of all, It seems like DBCP works very well.

Now, I've got just a little problem with getConnection method 
and credentials : PoolingDataSource object doesn't support 
getConnection(user, password) method and throw 
an "UnsupportedOperationException".

I understand it as a pooled connections can't be shared among 
multiple database users. My problem is that some application 
still use getConnection(user, password) method even with 
DataSource, so using DBCP with those applications is impossible 
without modifing app. code.

So, here is my proposal : Why not modifing getConection(user, 
password) in BasicDataSource so that :
- if username/password are good ones, this method forward 
toward getConnection()
- if not, this method throw a SQLExeption, saying something 
like "Invalid username/password"

I've tried to modify source code and I ask you if it would be 
correct to transform getConnection(username, password) in 
BasicDataSource like this :

-----------------------------------------------------------
public Connection getConnection(String username, String 
password)
  throws SQLException {
  
  if(username.equalsIgnoreCase(this.username) && 
password.equalsIgnoreCase(this.password)) {
    return (createDataSource().getConnection());
  } else {
    throw new SQLException("DBCP : Invalid username/password");
  }
}
-----------------------------------------------------------

Thanks in advance for your responses


Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 €/mn) ; tél : 08 92 68 13 50 (0,34€/mn)"




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>