regarding sql exception: invalid handle
i have been getting this error when i run my java program.. its either i get this error unless i change part of my code but then it will not return the value to my assignated string...
SELECT HChr, count(*) AS cnt FROM Chromosome1 WHERE Zstart > 386400000 And Zend
< 388800000 GROUP BY HChr ORDER BY count(*) DESC
java.sql.SQLException: Invalid handle
count is 161 calculated value is 1361253
try {
String sqlstr3 = "SELECT HChr, count(*) AS cnt FROM "+ qchr +" WHERE Zstart > "+start+ " And Zend < " + end + " GROUP BY HChr ORDER BY count(*) DESC";
System.out.println(sqlstr3);
ResultSet rs3 = s3.executeQuery(sqlstr3);
if (rs3.next())
{
rchr = rs3.getString("HChr");
System.out.println(rchr);
}
rs3.close();
}
catch(Exception sqle)
{
System.out.println(sqle);
}
Subject
Views
Written By
Posted
regarding sql exception: invalid handle
6125
January 06, 2005 07:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.