Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

urgent help (on oracle connection pool)

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am using oracle connection pool ...I am getting new connection each time when i run jsp page ......
It is not getting the connection from pool .............
When i try to print connection object it is giving different object each time .......................
What is the wrong in my code ..............
Is any one using oracle connection pool ................
Please help me ...
Here is my code:

<%@page contentType="text/html"%>
<%@ page language="java" import="java.sql.*,oracle.jdbc.pool.*"%>
<html>
<head><title>JSP Page</title></head>
<body>
<%
Connection con= null;
DbConnectionPool dbcp=null;
dbcp=(DbConnectionPool)application.getAttribute("dbcp");
try{
if(dbcp == null)
{
dbcp=new DbConnectionPool();
application.setAttribute("dbcp",dbcp);
}
else
{
dbcp=(DbConnectionPool)dbcp;
}
con=dbcp.getDatabaseConnection();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from checkout_checkin");
while(rs.next())
{
out.println(rs.getString(1)+"<br>");
}
stmt.close();
rs.close();
dbcp.closeDatabaseConnection(con);
}
catch (Exception e){System.out.println("eeeeeee==="+e);}
%>
</body>
</html>
*********************************
package oracle.jdbc.pool;
import oracle.jdbc.*;
import java.sql.*;
public class DbConnectionPool
{
OracleConnectionCacheImpl myConnectionPool;
OracleConnectionPoolDataSource myDataSource;

public DbConnectionPool()
{
try{
//Create & configure datasource
myDataSource = new OracleConnectionPoolDataSource();
myDataSource.setDriverType("thin");
myDataSource.setNetworkProtocol("tcp");
myDataSource.setServerName ("ipaddr");
myDataSource.setDatabaseName("xxxx");
myDataSource.setPortNumber (1521);
myDataSource.setUser ("xxxx");
myDataSource.setPassword ("xxxx");
//Create & configure pool
myConnectionPool = new OracleConnectionCacheImpl(myDataSource);
myConnectionPool.setMaxLimit(20);
myConnectionPool.setMinLimit(2);
myConnectionPool.setCacheScheme(OracleConnectionCacheImpl.DYNAMIC_SCHEME);
}catch (Throwable ex)
{
System.out.println("initConnectionPool() - Exception catched:"+ex);
}
}
public Connection getDatabaseConnection()
{
try{
return (Connection)myConnectionPool.getConnection();
}
catch (Throwable ex){ System.out.println("getDatabaseConnection()=="+ex); return null; }
}
public void closeDatabaseConnection(Connection connection)
{
try{
connection.close();
}catch (Throwable ex){
System.out.println("closeDatabaseConnection(Connection) - Exception catched: " +ex);
}
}
}

Thanks.
 
Are you here to take over the surface world? Because this tiny ad will stop you!
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic