| From: | Dave Cramer <Dave(at)micro-automation(dot)net> | 
|---|---|
| To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> | 
| Subject: | possible memory leak?? | 
| Date: | 2002-11-08 13:11:45 | 
| Message-ID: | 1036761105.12348.10.camel@inspiron.cramers | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-jdbc | 
If I run the following program for an extended period of time the 
memory consumed by java keeps increasing 4M at a time. Can anyone else 
confirm this, and next; can anyone explain why? Is this normal? I doubt it, but
can't confirm it?
Does anyone have access to an optimizer to run this on?
-- 
Dave Cramer <Dave(at)micro-automation(dot)net>
import java.lang.Runnable;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
public class TestRoutes implements Runnable
{
  Connection con;
  public TestRoutes()
  {
    try
    {
      Class.forName("org.postgresql.Driver");
      con = DriverManager.getConnection("jdbc:postgresql://localhost/symcor", "davec", "" );
    }
    catch ( Exception ex)
    {
      ex.printStackTrace();
    }
  }
  public void selectRoutes()
  {
    Statement stmt = null;
    ResultSet rs = null;
    try
    {
      stmt = con.createStatement();
      rs = stmt.executeQuery("select * from route");
      for( int i=0; rs.next(); i++ )
      {
	System.out.println( "Route " + i );
      }
    }
    catch ( Exception ex )
    {
      ex.printStackTrace();
    }
    finally
    {
      try
      {
	rs.close();
	stmt.close();
	rs=null;
	stmt=null;
      }
      catch (SQLException ex)
      {
      }
    }
  }
  public void run()
  {
    while(true)
    {
      try
      {
        //RouteModel.getAllRoutes();
	selectRoutes();
        Thread.sleep(2000);
      }
      catch( Exception ex )
      {
	return;
      }
    }
  }
  public static void main( String [] args )
  {
    TestRoutes t = new TestRoutes();
    new Thread(t).start();
  }
}
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paesold | 2002-11-08 13:31:47 | Re: possible memory leak?? | 
| Previous Message | snpe | 2002-11-07 22:22:57 | DatabaseMetaData.getTables problem |