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
