Hi,
it is rather a database pool *normal* behaviour:
returning (freeing) the connection back in the DbConnectionBroker
does NOT closes the JDBC connection to the postgress server, so
the allocated server thread, wich handles the connection is still alive.
That's normal, the DbConnectionBroker keeps connections openend, like any
other database pool manager. That's database pools reason to be.
Cezar.
On Sun, 25 Jul 1999, Chris Pratt wrote:
> Sounds like a question better suited to a PostegreSQL list.
> (*Chris*)
>
> ----- Original Message -----
> From: Dean <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, July 25, 1999 6:57 AM
> Subject: Servlet/Postgresql - backend processes
>
>
> > Hi All
> >
> > My Setup:
> > Redhat5.2, Jrun, Apache1.3.4, Postgresql6.4.2, jdk1.1.7b from blackdown
> >
> > Problem:
> > Ok, Im using DbConnectionBroker to handle my database
> > requests as is good practice. Everything works fine except
> > postgres seems to spawn threads of itself for every request and
> > doesnt close them again - even though i close the resultset, statement
> > and free my connection with DbConnectionBroker
> >
> > Some Code:
> >
> > class MyServlet {
> >
> > public void init(blah) {
> > file://..blah
> > file://..Have tried DBConnection in here - same result though??
> > }
> >
> >
> > public void doGet(HttpServletRequest req, HttpServletResponse res)
> > throws ServletException, IOException {
> >
> >
> > SupportingClass sp = new SupportingClass()
> > out,println(sp.getDBResults(someparameter));
> > }
> >
> >
> > file://Something like this..
> > class SupportingClass {
> >
> > public StringBuffer getDBResults(someparameter) {
> > DbConnectionBroker myBroker;
> > Connection con;
> >
> > int key;
> > StringBuffer WH_sb = new StringBuffer();
> >
> > if (con == null) {
> >
> >
> DbConnectionBroker("postgresql.Driver","jdbc:postgresql://127.0.0.1:5432/som
> edatabase","username","passwd");
> >
> > con = myBroker.getConnection();
> > }
> >
> > Statement st = con.createStatement();
> > ResultSet rs = st.executeQuery("Select somestuff from a
> > database");
> >
> > Hashtable db_result = Result(rs);
> >
> > for (key=0;key<db_result.size(); key++) {
> > Vector I_name = (Vector)db_result.get(new Integer(key))
> > String I_index=(String)I_name.elementAt(0);
> > String I_ingredient= (String)I_name.elementAt(1);
> > WH_ sb.append(I_index);
> > / /etc
> > }
> > st.close();
> > rs.close();
> > myBroker.freeConnection(con);
> > return WH_sb;
> > }
> > }
> >
> > What gives ??? - anyone got an idea?
> >
> > Thanks
> > Dean
> > [EMAIL PROTECTED]
> >
> >
> ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
