my dog learned polymorphism*
The moose likes EJB and other Java EE Technologies and the fly likes Accessing Connection  pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Accessing Connection  pool" Watch "Accessing Connection  pool" New topic
Author

Accessing Connection pool

Joe
Greenhorn

Joined: Aug 22, 2000
Posts: 10
Hi,
I have created a connection pool in Weblogic.I want to access the pool from my client.
There is one remote interface which is defined as follows
ResultSet executeDataBaseQuery(Connection conn,String queryString) throws RemoteException;

My bean implements this interface and sends back the resultset
as follows
public ResultSet executeDataBaseQuery(Connection conn,String queryString)
{
Statement stmt=null;
ResultSet result=null;
try
{
if (conn==null)
{
System.out.println("Connection is null");
}
System.out.println("Inside bean first stmt");
stmt = conn.createStatement();
result=stmt.executeQuery(queryString);
stmt.close();
} catch(SQLException e)
{
System.out.println("Exception inside JDBCConnector.executeDataBaseQuery"+e.getErrorCode());
e.printStackTrace();
return null;
}
return result;

The client code is as follows
public Connection getConn() throws ClassNotFoundException, InstantiationException, IllegalAccessException
{
try
{
Connection conn = null;
Class.forName("weblogic.jdbc.pool.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:weblogic ool raclePool");
System.out.println("Got a connection from JDBC Pool");
if (conn == null)
{
System.out.println("Connection is null in the function getConn()");
}
return conn;
}
catch(Exception e)
{
System.out.println("Could not get free Connection from the pool "+e.getMessage());
e.printStackTrace();
return null;
}
}

When I call the above getconn() from the application it gives error message as
"Pool connect failed"
Could U please tell me where the problem is
Do reply
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
when you set up the connectionpool,you have to set up the txdatasource in the properties file.then lookup on that datasource name to get the connection.hope this helps.if it is weblogic5.1,look into the properties file you get the info.
Joe
Greenhorn

Joined: Aug 22, 2000
Posts: 10
Hey,
I changed the txdatasource in the properties file, but still am not able to solve the problem. Am using weblogic 5.1
Can U help me out
 
GeeCON Prague 2014
 
subject: Accessing Connection pool