aspose file tools*
The moose likes JDBC and the fly likes connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connection pooling" Watch "connection pooling" New topic
Author

connection pooling

jyotsana dang
Ranch Hand

Joined: Sep 26, 2003
Posts: 135
what is connection pooling in java? i have seen a program code which uses connection pooling:
it imports the hashthable and java.lang.object:
package com;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Hashtable;
import java.lang.Object;
public class LoginManager
{
private Hashtable currentLogins;
private ConnectionPool connectionPool;
private static final String SELECT_PASSWORD="SELECT password FROM idpassword WHERE userid=";
private static final String QUOTE="'";
private class LoginProfile extends UserCredentials
{
boolean isLoggedIn=false;
public LoginProfile(UserCredentials credentials)
{
setUser(credentials.getUser());
setPassword(credentials.getPassword());
isLoggedIn=false;
}
}
public LoginManager() throws Exception
{
connectionPool=new ConnectionPool();
connectionPool.intialize();
currentLogins=new Hashtable();
}
public boolean alreadyLoggedIn(UserCredentials credentials)
{
boolean loggedIn=false;
String user=credentials.getUser();
if(currentLogins.containsKey(user))
{
LoginProfile aProfile=(LoginProfile)currentLogins.get(user);
loggedIn=aProfile.isLoggedIn;
}
return loggedIn;
}
public boolean login(UserCredentials credentials) throws SQLException
{
if(alreadyLoggedIn(credentials))
{
return false;
}
LoginProfile profile=new LoginProfile(credentials);
Connection con=connnectionPool.getConnection();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(SELECT_PASSWORD+QUOTE+credentials.getUser()+QUOTE);
while(rs.next())
{
if(rs.getString(1).equals(credentials.getPassword()))
{
profile.isLoggedIn=true;
currentLogins.put(credentials.getUser(),profile);
break;
}
}
return profile.isLoggedIn;
}
}
iam trying to implement the same in the intranet project for my department..
how do we use the connection pooling ..
jyotsana
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61769
    
  67

Moving this to the JDBC Forum since there's nothing JSP specific.
bear


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8997
    
    9

Where did you get that code? They probably provided the code for the ConnectionPool class as well. Connections are expensive to allocate in Java, so it is a common practice to open a few and keep them around in a pool to reuse. If you are using Oracle, a pool is implemented as oracle.jdbc.pool.OracleDataSource. If you aren't, you do have that ConnectionPool class.


[How To Ask Questions On JavaRanch]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connection pooling