Hello,
I have a problem connecting to the database.
Until know i had a session connection, I made a java bean that implements HttpSessionListener, and open a new connection each time a new session starts, and close it when it ends.

It didnt worked so good, and didnt always close the connections.
another problem is that many sessions could not open simultaneously.

I tried to use resin DBpool unsecssesfuly - I manage to connect to the database but the bean dosent hold the connection.

I want to implement a bean (my db bean has a function - executeSQL that gets a string from the jsp page and returns a ResultSet).
I would like to keep that structure, but with database pooling, I mean having a java bean that will hold handler to the database and can execute sql commands.

can someone help me ?

Thanks

yudan