MySQL Forums
Forum List  »  Microsoft Access

regarding sql exception: invalid handle
Posted by: vivi kururu
Date: January 06, 2005 07:11PM

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);
}

Options: ReplyQuote


Subject
Views
Written By
Posted
regarding sql exception: invalid handle
6070
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.