Connection problem

[Gurpreet Saini]

I am using weblogic6.1 server. When I deploy bean I get the following error:
<Mar 10, 2003 8:16:03 PM IST> <Error> <Management> <Error deploying application
.\config\mydomain\applications\bean.jar: java.lang.reflect.UndeclaredThrowableException>
weblogic.common.ResourceException: No available connections in pool cabinPool
Please let me know where exactly can be the problem.

[Harsh Mahey]

The problem is the the connection in the pool is over.Means you are trying to get connection from the Pool and the pool doesnt have any more connection available.For this, you should increase the no. of connections in the connection pool by setting the properties in config.xml/or form the console.
Please note that if such problems comes regularly then there is some leakage of connections which means that you are not closing the Connections after using it.
Thanks
Harsh

[Gurpreet Saini]

I deployed the bean successfully. The problem was I was not closing the connection in ejbFindByPrimaryKey method. But now when I run the Client program I get the following exception:
java.rmi.RemoteException: Exception in ejbFindByPrimaryKey; nested exception is:
javax.ejb.EJBException
- with nested exception:
[java.sql.SQLException: Connection has already been closed.]
Start server side stack trace:
java.rmi.RemoteException: Exception in ejbFindByPrimaryKey; nested exception is:
javax.ejb.EJBException
- with nested exception:
[java.sql.SQLException: Connection has already been closed.]
java.sql.SQLException: Connection has already been closed.
What can be the problem on client side. It gives me this exception.
thank you,
gurpreet

[Harsh Mahey]

The way to analize such problem is first you increase the no of connections and they see if your 1st problem is gone or not.If yes then focus of closing the connections.For that you can check before closing the connection if it is open or not .Your second response shows that you are trying to close the connection which is already closed ; so for this you first check if the connection is open or not.
Hope this will help.
Thanks
Harsh

[Gurpreet Saini]

Hi there,
My connection problem has been soughted out and the records are inserted successfully in BMP. But when I try to find the object by using primary key class. Then on client side I get the following output:
C:/java Client
null
null
I dont understand why I am getting null. Though records are being inserted in access successfuly.
Please help me on this issue.
thank you,