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));
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@xxxxxxxxxxxxxx on behalf of William ZHANG
Sent: Wed 3/22/2006 4:27 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] partial resultset in java
Sent: Wed 3/22/2006 4:27 PM
To: pgsql-general@xxxxxxxxxxxxxx
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
