This is an SQLException and it's reporting an invalid column name, so I'd start by looking at the column names in your SQL. Is "Couunt1" a valid column name? How about the others? Also, you are not fetching the query_answered column in your outer SELECT, and why is your SQL nested anyway?
Take your SQL query and test it in your SQL interpreter shell before you put it into Java. That way you can be sure the query is correct.
No more Blub for me, thank you, Vicar.
posted 4 years ago
Thanks for the answer Chris
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads