Re: partial resultset in java - Mailing list pgsql-general

From surabhi.ahuja
Subject Re: partial resultset in java
Date
Msg-id 8626C1B7EB748940BCDD7596134632BE398669@jal.iiitb.ac.in
Whole thread Raw
In response to partial resultset in java  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
 
on which object is this method "cancel()" avaialble.
the peice of code that i am looking at right now is :
 
Statement stmt_ = this.dbSession_.getDBConnection().createStatement();
String queryStr = dbxQuery.createQuery(DBObject.getLevelNumber(qLevel), q, this);
long t = System.currentTimeMillis();
rs = stmt_.executeQuery(queryStr);
this.dbSession_.logger_.log(Level.FINE, "GOT RESULT SET;"
 + (System.currentTimeMillis() - t));
   
ResultSetMetaData rsmd = rs.getMetaData();
   int colCount = rsmd.getColumnCount();
   t = System.currentTimeMillis();
   while (rs.next()) {
    vals = new HashMap();
    for (int j = 0; j < colCount; j++) {
     vals.put(rsmd.getColumnName(j + 1), rs.getObject(j + 1));
    }
    objList.add(new DBObject(qLevel, vals, this.dbSession_));
   }
   this.dbSession_.logger_.log(Level.FINE, "CONVERT RESULTSET TO DBOBJECT;"
     + (System.currentTimeMillis() - t));
    
 
where exactly will the cancel be placed?
thanks,
regards
Surabhi

From: pgsql-general-owner@postgresql.org on behalf of William ZHANG
Sent: Wed 3/22/2006 4:27 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] partial resultset in java

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********


There is a method called cancel() in interface Statement. But I don't know
if it is
implemented correctly in JDBC. Maybe you can try it.

Regards,
William ZHANG



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


pgsql-general by date:

Previous
From: Steven Brown
Date:
Subject: Re: Enforcing serial uniqueness?
Next
From: "surabhi.ahuja"
Date:
Subject: Re: back slash separated values