0 Replies Latest reply on Mar 15, 2003 2:05 PM by yudan

    connection to database using java Beans

    yudan Newbie

      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